一、statement对象简介
Jdbc中statement对象用于向数据库发送SQL语句,statement对象executeUpdate方法,用于向数据库发送增、删、改的sql语句,执行完后返回整数;executeQuery方法用于向数据库发送查询语句,返回代表查询结果的ResultSet对象。
CRUD操作
1.create
Statement st = conn.createStatement();
String sql = "insert into users(id,name,password,email,birthday) values (4,'天山童老','123456','tstl@qq.com','2012-12-12')";
int result = st.executeUpdate(sql);
if(result>0){
System.out.println("插入成功!!!!");
}
2.update
Statement st = conn.createStatement();
String sql = "update users set name='caocao1' where name='caocao'";
int result = st.executeUpdate(sql);
if(result>0){
System.out.println("跟新成功!!!!");
}
Statement st = conn.createStatement();
String sql = "delete from users where id = 4";
int result = st.executeUpdate(sql);
if(result>0){
System.out.println("删除成功!!!!");
}
Statement st = conn.createStatement();
String sql = "select * from users";
ResultSet result = st.executeQuery(sql);
while(result.next()){
//根据获取列的数据类型,分别调用rs的相应方法映射到java对象中
}