博客

工具：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语法，加上一点点写法思维就可以实现