增:
DatabaseSession session = new DatabaseSession();
session.setUpdateString("insert into users(userName,sex,address,age,money) values(:userName,:sex,:address,:age,:money)");
session.setString("userName","古刹飞鹰");
session.setBoolean("sex",true);
session.setString("address","中国长春");
session.setBigDecimal("money",new BigDecimal("3000.37"));
session.setInt("age",30);
session.executeUpdate();
删
session.setUpdateString("delete from users where userName=:userName");
session.setString("userName","古刹飞鹰");
session.executeUpdate();
改
session.setUpdateString("update users set age=:age,address=:address where userName=:userName");
session.setInt("age",33);
session.setString("userName","古刹飞鹰");
session.setString("address","中国吉林长春");
session.executeUpdate();
查
session.setQueryString("select * from users where age=:age and userName=:userName");
session.setInt("age",33);
session.setString("userName","古刹飞鹰");
ResultSet rs = session.executeQuery();
if(rs.next()){
System.out.println(rs.getString("userName"));
}
关闭单个rs
session.close(rs);
关闭整个联接和用到的rs
session.close();
开始事务
session.beginTransaction();
提交事务
session.commit();
回滚事务
session.rollBack();
使用指定Connection初始化DatabaseSession
DatabaseSession session = new DatabaseSession(myConn);
DatabaseSession 简单jdbc封装!
最新推荐文章于 2023-08-31 10:57:03 发布