工具:MySQL,Java,,一双手
话不多说开始教程:
打开MySQL,设置连接名studentsmanger(都可以)
新建数据库(stuk)
新建表 mysq(重要!!)
MySQL设置好,进入Java敲代码!!
package MySQL;
import java.util.Scanner;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
public class bookmanger {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
Class.forName("com.mysql.jdbc.Driver");
//自己的账号密码
String userName = "";
String password = "";
String url = "jdbc:mysql://localhost:3306/stuk?characterEncoding=utf8&useSSL=false";
Connection connection = DriverManager.getConnection(url, userName, password);
if(connection == null){
System.out.println("连接失败!");
} else{
System.out.println("连接成功!");
System.out.println("欢迎进入学生管理系统");
System.out.println("任意输入继续");
Scanner po = new Scanner(System.in);
while (true) {
String i = po.nextLine();
if (i.equals("ESC")) {
break;
} else {
System.out.println("请输入需要的操作1.查询学生 2.插入学生 3.修改学生 4.删除学生 5.学生列表 6.ESC退出");
Statement xs = connection.createStatement();
Scanner sc = new Scanner(System.in);
String a = sc.nextLine();
switch (a) {
case "查询学生":
System.out.println("请输入你需要查询的学生学号:");
int b = sc.nextInt();
String scx = "SELECT * FROM mysq WHERE id = " + b;
ResultSet gk = xs.executeQuery(scx);
if (gk.next()) {
int id = gk.getInt("id");
String name = gk.getString("name");
int age = gk.getInt("age");
String sex = gk.getString("sex");
String phone = gk.getString("phone");
System.out.println("学号:" + id + "姓名:" + name + "年龄:" + age + "性别:" + sex + "联系方式:" + phone);
System.out.println("查询成功!退出请按ESC,继续请按回车键");
} else {
System.out.println("查询失败!退出请按ESC,继续请按回车键");
}
break;
case "插入学生":
System.out.println("请输入需要插入的学号:");
int ca = sc.nextInt();
System.out.println("请输入需要插入的名字:");
Scanner ok = new Scanner(System.in);
String cm = ok.nextLine();
System.out.println("请输入需要插入的年龄:");
int cn = sc.nextInt();
System.out.println("请输入需要插入的性别:");
String cx = ok.nextLine();
System.out.println("请输入需要插入的联系方式:");
int cl = sc.nextInt();
String sql = "INSERT INTO mysq(id, name, age, sex, phone) VALUES(" + ca + ", '" + cm + "'," + cn + ",'" + cx + "'," + cl + ")";
if (xs.executeUpdate(sql) >= 1) {
System.out.println("插入成功,退出请按ESC,继续请按回车键");
} else {
System.out.println("插入失败,退出请按ESC,继续请按回车键");
}
break;
case "修改学生":
System.out.println("请输入你需要修改的学生学号:");
int xx = sc.nextInt();
System.out.println("请输入你需要修改学生的什么:");
Scanner ok1 = new Scanner(System.in);
String xm = ok1.nextLine();
System.out.println("请输入你需要修改学生的" + xm + "为多少:");
String xsz = ok1.nextLine();
String sal = "UPDATE mysq SET " + xm + " = "+xsz+" WHERE id = " + xx;
if (xs.executeUpdate(sal) >= 1) {
System.out.println("修改成功,退出请按ESC,继续请按回车键");
} else {
System.out.println("修改失败,退出请按ESC,继续请按回车键");
}
break;
case "删除学生":
System.out.println("请输入你需要删除的学生学号:");
int sx = sc.nextInt();
String scl = "DELETE FROM mysq WHERE id = " + sx;
if (xs.executeUpdate(scl) >= 1) {
System.out.println("删除成功,退出请按ESC,继续请按回车键");
} else {
System.out.println("删除失败,退出请按ESC,继续请按回车键");
}
break;
case "学生列表":
String si = "SELECT * FROM mysq";
ResultSet gki = xs.executeQuery(si);
while (gki.next()) {
int id = gki.getInt("id");
String name = gki.getString("name");
int age = gki.getInt("age");
String sex = gki.getString("sex");
String phone = gki.getString("phone");
System.out.println("学号:" + id + "姓名:" + name + "年龄:" + age + "性别:" + sex + "联系方式:" + phone);
}
System.out.println("查询成功!退出请按ESC,继续请按回车键");
break;
}
}
}
}
}
}
运行效果:
总结:就是些基础的MySQL语法,加上一点点写法思维就可以实现
版权声明:本文为m0_46540496原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。