Java连接MySQL数据库步骤

1、建一个maven工程 quick strat

2、在Java进行

1、装驱动盘
	Class.forName("com.mysql.jdbc.Driver");
2、3个常量字符串
	final String URL = "jdbc:mysql://localhost:3306/schooldb?useSSL=true&userUnicode=true&characterEncoding=utf8";
    final String USER = "root";
    final String PASS = "1831";
3、创建连接对象
	Connection con =DriverManager.getConnection(URL,USER,PASS);
4、与mysql数据库交流（例如：增删改查）
final String SQL = "insert into employee(empName,empPos) values(?,?),(?,?)";
    PreparedStatement pst = con.prepareStatement(SQL);
    pst.setObject(1,"内容1");
    pst.setObject(2,"内容2");

    //删除操作
    final String SQL = "delete from employee where empId in (?,?)";
    PreparedStatement pst = con.prepareStatement(SQL);
    pst.setObject(1,2);
    pst.setObject(2,3);

    //修改操作
    final String SQL = "update employee set empPos=? where empId=?";
    PreparedStatement pst = con.prepareStatement(SQL);
    pst.setObject(1,"内容");
    pst.setObject(2,4);

4、向mysql服务执行SQL命令
    int rowsAffected = pst.executeUpdate();

5、根据rowsAffected输出执行结果
    System.out.println(rowsAffected);

    //查询操作
    final String SQL = "select empId id,empName,empPos pos from employee";
★★★★★预编译执行器
    PreparedStatement pst = con.prepareStatement(SQL);