public static void main(String[] args) {
Session session = null;
Transaction tx = null;
try {
session = HibernateSessionFactory.getSession();
tx = session.beginTransaction();
//添加
/* for (int i = 0; i < 3; i++) {
BbscsLogintimes login = new BbscsLogintimes();
login.setUserId(i);
login.setUserName("admin"+i);
session.save(login);
}*/
BbscsLogintimes login = new BbscsLogintimes();
login.setDistrictId(1);//大区
login.setBranchId(2);//分公司
login.setDeptId(3);//部门
login.setUserId(4);//用户
login.setUserName("尼克斯");
login.setNickName("林书豪");
Date aDate = new Date(System.currentTimeMillis());
Calendar calendar = GregorianCalendar.getInstance();
calendar.setTime(aDate);
System.out.println(calendar);
login.setLoginYear(calendar.get(Calendar.YEAR));
login.setLoginMonth(calendar.get(Calendar.MONTH));
login.setLoginDay(calendar.get(Calendar.DATE));
login.setLoginDetailTime(aDate);
session.save(login);
//修改
/*BbscsLogintimes login = new BbscsLogintimes();
login.setId(1);
login.setUserId(100);
login.setUserName("黄飞鸿");
session.update(login);*/
//删除
/*BbscsLogintimes login = new BbscsLogintimes();
login.setId(1);
login.setUserId(100);
login.setUserName("黄飞鸿");
session.delete(login);*/
//查询
/* Query query = session.createQuery("from BbscsLogintimes where id=?");
query.setLong(0, 2);
BbscsLogintimes login = (BbscsLogintimes)query.uniqueResult();
query = null;
System.out.println("查询结果:"+login.getUserId());
System.out.println(login.getUserName());*/
//查询对象
/*long i = 3;
BbscsLogintimes login = (BbscsLogintimes)session.get(BbscsLogintimes.class, i);
System.out.println("查询结果:"+login.getUserId());
System.out.println(login.getUserName());*/
//查询列表
/* String q = "from BbscsLogintimes si order by si.id desc";
Query query = session.createQuery(q);
List list = query.list();
BbscsLogintimes login;
for (int i = 0; i < list.size(); i++) {
login = (BbscsLogintimes) list.get(i);
System.out.println(login.getUserId()+" - " + login.getUserName());
}*/
tx.commit();
session.close();
System.out.println("save object success!");
} catch (HibernateException e) {
e.printStackTrace();
}
}
另外一种方法是:hibernate桥接到jdbc。
public static void main(String[] args) {
Session session = null;
Transaction tx = null;
session = HibernateSessionFactory.getSession();
tx = session.beginTransaction();
java.sql.Connection con=session.connection();
//执行SQL语句方法,添加,修改,删除。
/*int ret = 0;
String q = "delete from bbscs_logintimes where id=?";
PreparedStatement stmt;
try {
stmt = con.prepareStatement(q);
stmt.setLong(1, 2);
// con.createStatement();
ret = stmt.executeUpdate();
// stmt.execute();
stmt.close();
con.close();
} catch (SQLException e) {
e.printStackTrace();
}*/
执行SQL查询语句方法,返回结果集对象
ResultSet rs = null;
String q = "select * from bbscs_logintimes";
PreparedStatement stmt;
try {
stmt = con.prepareStatement(q);
// con.createStatement();
rs = stmt.executeQuery();
// stmt.execute();
while(rs.next()){
System.out.println(rs.getLong("id"));
System.out.println(rs.getLong("UserID"));
System.out.println(rs.getString("UserName"));
}
stmt.close();
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
System.out.println("SQL=" + q);
System.out.println("SQL return=" + rs);
tx.commit();
}