连接数据库对数据库进行查询、控制游标、更新添加等操作

实行更新、添加操作代码：

import java.sql.*;
public class Record {
    public static void main (String args[]){
        Connection con;
        Statement sql;
        ResultSet rs;
        con = GetDBConnection.connectDB("students","root","ljh");
        System.out.println("connect DB successful !");
        if(con == null) {
        System.out.println("connnect DB error !");
        return;
        }
        String jiLu = "('R11','jiangsan','2000-10-23',1.6)," + "('R10','liwu','1989-7-22',1.8)";
        String sqlStr = "insert into mess values" + jiLu;
        try {
            sql = con.createStatement();
            int ok = sql.executeUpdate(sqlStr);
            rs = sql.executeQuery("select * from mess");
            System.out.println("query database records");
            while(rs.next()) {
                String number = rs.getString(1);
                String name = rs.getString(2);
                Date date = rs.getDate(3);
                float height = rs.getFloat(4);
                System.out.printf("%s\t",number);
                System.out.printf("%s\t",name);
                System.out.printf("%s\t",date);
                System.out.printf("%.2f\n",height);
                System.out.println("insert record to DB is successful!");
            }
            con.close();
            System.out.println("close connection to database");
        }
        catch(SQLException e) {
            e.printStackTrace();
            System.out.println("The number value in the record cannot be repeated"+e);
        }
        System.out.println("程序执行成功！");
    }
}

连接数据库代码：

import java.sql.*;
public class GetDBConnection {
    public static Connection connectDB(String DBName,String id,String p){
        Connection con = null;
        String uri =
        "jdbc:mysql://127.0.0.1:3306/"+DBName+"?id=root&p=ljh&useSSL=true&characterEncoding=utf-8";
        System.out.println(uri);
        try{
            Class.forName("com.mysql.jdbc.Driver");
        }
        catch (Exception e){
            e.printStackTrace();
        }
        try{
            con = DriverManager.getConnection(uri,id,p);
        }
        catch (SQLException e){
            e.printStackTrace();
        }
        return con;
    }
}

连接成功后打印的结果：

登录数据库查看表：