PreparedStatement是预编译的,对于批量处理可以大大提高效率
package com.xmut.zeng.lesson02;
import com.xmut.zeng.lesson01.utils.JdbcUtils;
import java.sql.*;
public class Insert {
public static void main(String[] args) {
Connection conn = null;
PreparedStatement st = null;
try {
conn = JdbcUtils.getConnection();//获取数据库连接
//使用???? 占位符代替参数
String sql = "INSERT INTO users (`id`,`NAME`,`PASSWORD`,`email`,`birthday`)" +
"VALUES (?,?,?,?,?)";
st = conn.prepareStatement(sql); //预编译sql,先写sql 然后不执行
//手动给参数赋值
st.setInt(1,101);
st.setString(2,"CSDN");
st.setString(3,"123456");
st.setString(4,"CSDN@edu.cn");
st.setDate(5,new java.sql.Date(new java.util.Date().getTime()));
int i = st.executeUpdate();
if (i>0){
System.out.println("插入成功 "+i+" 条数据");
}
} catch (SQLException throwables) {
throwables.printStackTrace();
}finally {
}
}
}
执行结果: