1、JDBC 连接 MySql
Class.forName("com.mysql.jdbc.Driver"); //生成驱动类对象,并自动向DriverManger注册
Connection conn = DriverManger.getConnection(URL); //获得数据库连接
Statement stmt = conn.creatStatement(); //SQL语句
ResultSet rs = stmt.execute(); //结果集
...
close()
MyEclipse引入驱动jar包 : Build Path - Add External Archives
2、3种Statement
java.sql
接口 Statement
所有超级接口:
Wrapper
所有已知子接口:
CallableStatement, PreparedStatement
pstmt = conn.prepareStatement("insert into myTable values(?,?,?)");
pstmt.setInt(1,11);
pstmt.setString(2, "aa");
pstmt.setString(3, "AA");
pstmt.executeUpdate();
3、批处理语句
try {
......
conn.setAutoCommit(false);
stmt = conn.creatStatement();
stmt.addBatch(sql); //sql语句
...... //sql语句
stmt.addBatch(sql); //sql语句
stmt.executeBatch();
conn.commit();
conn.setAutoCommit(true);
......
} catch (SQLException e){
try {
if(conn != null){
conn.rollback();
conn.setAutoCommit(true);
}
}
}
......