package org.bw88;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import com.mysql.jdbc.Connection;
public class conmysql {
public static void main(String[] args) throws Exception {
String conString="jdbc:mysql://localhost:3306/mydb?useSSL=false&serverTimezone=UTC&characterEncoding=utf-8";
String user="root";
String password="root";
Connection conn=(Connection) DriverManager.getConnection(conString, user, password);
/**
* 插入数据,并获取自增ID,获取的是最后一次插入的记录的ID,前提是id是自增的,
*/
/* Statement statement=conn.createStatement();*/
String sql="INSERT INTO user_table(username,password) VALUES(?,?)";
Prepare