一、Statement接口
1.由Connection接口的createStatement()方法创建。
2.常用方法有:
close();
executeUpdate(String sql);
executeQuery(String sql);
-----语法------
statement = con.createStatement();
statement.executeUpdate(strSql);
二、PreparedStatement
1.PreparedStatement 接口继承 Statement接口
2.PreparedStatement比普通的Statement对象使用起来更加灵活,更有效率
//使用PreparedStatement插入数据
public class UserInfoDB2 extends BaseDB{
public static void main(String[] args) {
Connection con = null;
PreparedStatement pStatement = null;
try {
SimpleDateFormat hmFromat = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
con = getConnection();
String strSql = "insert into userInfo values(?,?,?,?)";
pStatement = con.prepareStatement(strSql);
pStatement.setInt(1, 1);
pStatement.setString(2, "令狐冲");
pStatement.setString(3, "xajh");
pStatement.setString(4, hmFromat.format(new Date()));
pStatement.executeUpdate();
} catch (SQLException sqlE) {
sqlE.printStackTrace();
} finally {
closeAll(con,pStatement);
}
}
}