jdbc

/**
* 不规范的jdbc
*
* @throws SQLException
* @throws ClassNotFoundException
*/
static void test() throws SQLException, ClassNotFoundException {
// 1.注册驱动
Class.forName("com.mysql.jdbc.Driver");
// 2建立连接
Connection conn = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/booktest", "root", "1");
// 3创建语句
Statement st = conn.createStatement();

// 4执行语句
ResultSet rs = (ResultSet) st
.executeQuery("select * from t_ability_item");
// 5处理结果
while (rs.next()) {
System.out.println(rs.getObject(1) + "\t" + rs.getObject(2) + "\t"
+ rs.getObject(3) + "\t" + rs.getObject(4));
}
// 6释放资源
rs.close();
st.close();
conn.close();
}
jdbc的查询executeQuery
jdbc的增删改executeUpdate