JDBC

JDBC:

//1.下载对应数据库的jar包
    //2.复制jar包到项目的libs文件夹
    //3.右键libs文件夹  add as libary
    //4.注册驱动
    Class.forName("com.mysql.jdbc.Driver");
    Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/db1","root","1");
// 若mysql 是本地服务且是3306 端口的情况下:DriverManager.getConnection("jdbc:mysql:///db1","root","1");
    
    String sql = "UPDATE stu set name = 'www' WHERE id = 3";
    Statement stmt = conn.createStatement();
    int count = stmt.executeUpdate(sql);
    System.out.println(count);
    stmt.close();
    conn.close();

executeUpdate(sql);-- DDL DML 
executeQuery();-- DQL