`
simpledev
  • 浏览: 194253 次
  • 性别: Icon_minigender_1
  • 来自: 上海
社区版块
存档分类
最新评论

Hibernate入门级添删改查核心代码

 
阅读更多
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();       

	}

 

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics