20230217 mysql 与 java 链接

Class.forName("com.mysql.jdbc.Driver");     //不用换任何东西

DriverManager.getConnection("jdbc:mysql://localhost:3306/db2","root","123456").var;   //需要填写自己端口号和用户名以及密码     .var是保存的意思！！

root.createStatement().var     //创建sql语句的处理平台    链接完成

---

在java中使用数据库完成增删改查基本操作

注：如果使用的不是idea，那么下述操作用到scanner的时候记得要将 scanner加载到内存

import java.util .scanner;   //导包

Scanner scanner = new Scanner(System.in);    //  将scannner加载到内存

1. 查询操作     （查询操作较难）

String query = "select * from students";     // 存放sql语句

statement.executeQuery(query).var;                       //statement 在上述代码中会自动生成；将sql   //语句发送到sql中并更新，注意查询操作的发送sql的方法和其他三种有区别！！！！

//  上一条代码的效果为：ResultSet resultSet = statement.executeQuery(query);  返回的是bool类     //型

for (;resultSet.next();){

        System.out.println(resultSet.getInt("id"));

        System.out.println(resultSet.getString("name"));             //因为name字段存放的是varchar类       // 型相当于java中的String类型

        System.out.println("输出完成！");

}

2.增加数据

1.基础版

String insert = "inset into students(id,name)values(9,'YF')";

statement.executeUpdate(insert);

2.进阶版

System.out.println("请输入要增加的学号：");

int id = scanner.nextInt();

System.out.println("请输入要增加的姓名：");

String name = scanner.nextString();

String insert = "insert into students(id,name)values("+id+",'"+name+"')";

statement.executeUpdate(insert);

System.out.println("添加成功！");

3.删除数据

  //  String delete = "delete  from students where id = 3";    简单用法

System.out.println("请输入您要删除的学号did：");

int did = scanner.nextInt();

String delete = "delete from students where id="+did;

statement.executeUpdate(delete);   // 发送sql语句到sql中，并更新

4.修改数据

1.基础：

String update = update students set id = 8,name='abcd' where id = 7;    //将id = 7的数据修改为id    //= 8，name = 'abcd'

2.进阶

System.out.println("请输入要修改的学号oid:");
int oid = scanner.nextInt();
System.out.println("请输入新学号nid：");
int nid = scanner.nextInt();
System.out.println("请输入新的姓名name1：");
String name1 = scanner.next();
String update = "update students set id="+nid+",name='"+name1+"' where id="+oid;
statement.executeUpdate(update);
System.out.println("修改完成！\n");

// 这一段直接赋值的

程序：

import com.mysql.jdbc.Driver;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Scanner;

public class test1 {
    public static void main(String[] args)throws Exception {
        Scanner scanner = new Scanner(System.in);

        // 数据库链接===================
        Class.forName("com.mysql.jdbc.Driver");
        Connection root =                                                        DriverManager.getConnection("jdbc:mysql://localhost:3306/db2", 
         "root", "123456");
        Statement statement = root.createStatement();
        //  链接完成===============


        //填入循环操作========
        for (;;){
            System.out.println("1:数据查看");
            System.out.println("2:数据删除");
            System.out.println("3:数据添加");
            System.out.println("4:数据修改");
            System.out.println("请选择1-----4，按其他键终止程序！");
            int i = scanner.nextInt();
            if (i==1){
                //查询操作=========
                String query = "select * from students";
                ResultSet resultSet = statement.executeQuery(query);
                for (;resultSet.next();){
                    System.out.print("学号：");
                    System.out.println(resultSet.getInt("id"));
                    System.out.println("姓名：");
                    System.out.println(resultSet.getString("name"));
                }
                System.out.println("查询完成！\n");
                //查询完成
            } else if (i==2) {
                // 数据删除
                System.out.println("请输入删除的学号did：");
                int did = scanner.nextInt();
                //String delete = "delete from students where id=200";
                String delete = "delete from students where id="+did;
                statement.executeUpdate(delete);
                System.out.println("删除成功！\n");
            } else if (i==3) {
                // 数据添加======
                System.out.println("请输入要增加的学号：");
                int id = scanner.nextInt();
                System.out.println("请输入要增加的姓名：");
                String name = scanner.next();
                String insert = "insert into students(id,name)values("+id+",'"+name+"')";
                statement.executeUpdate(insert);
                System.out.println("添加成功！\n");
            } else if (i==4) {
                //数据修改
                System.out.println("请输入要修改的学号oid:");
                int oid = scanner.nextInt();
                System.out.println("请输入新学号nid：");
                int nid = scanner.nextInt();
                System.out.println("请输入新的姓名name1：");
                String name1 = scanner.next();
                String update = "update students set id="+nid+",name='"+name1+"' where id="+oid;
                statement.executeUpdate(update);
                System.out.println("修改完成！\n");
            }else {
                System.out.println("程序退出！！");
                break;

            }
        }

    }
}