JDBC

 数据库连接

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

/**
 * @Author: Prado
 * @Date: 2018/7/30 9:21
 */

public class TestJDBC {
    public static void main(String[] args) {
        try {
            //加载驱动
            Class.forName("com.mysql.jdbc.Driver");
            //建立连接
            Connection conn;
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/prado","root","0909");
            //获得链接
            System.out.println(conn);
            conn.close();
        } catch (ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        }
    }
}

//实现SQL语句方法statment
            String sql=" insert into user(name,password) values ('王五',126);";            
            Statement stmt=conn.createStatement();
            stmt.execute(sql);
//实现SQL方法preparestatment+setObject()
            String sql=" insert into user(name,password) values (?,?);";
            PreparedStatement ps=conn.prepareStatement(sql);
            ps.setString(1,"张六");//第一个参数
            ps.setString(2,"123456");//第二个参数
            //或者
            ps.setObject(1,"张六");//第一个参数
            ps.setObject(2,"123456");//第二个参数
            ps.execute();
            conn.close();
//查询方法ResultSet+executeQuery()
            String sql=" SELECT * FROM USER;";
            PreparedStatement ps=conn.prepareStatement(sql);
            ResultSet rs=ps.executeQuery(sql);
            while(rs.next()){
                System.out.println(rs.getInt(1)+rs.getString(2));
            }
//批处理Batch
            Statement stmt=conn.createStatement();
            for (int i = 0; i <20000 ; i++) {
                stmt.addBatch(" insert into user(name,password) values ('齐"+i+"',126);");
            }
            stmt.executeBatch();