其实题目很简单
如果数据库没有主键呢?
如果你想使用hibernate去查询话那你就是要花费点时间了、
所以在这里推荐使用jdbc查询或者是使用hibernatecreateSQLQuery思路方法去查询
下是hibernate查询代码:
1 Session session = HibernateSessionFactory.getSession;
2 Transaction tran = session.beginTransaction;
3
4 Query query = session.createSQLQuery("select * from test where a=? and b=?");
5 query.Integer(0, 4);
6 query.Integer(1, 4);
7 tran.commit;
8 List l = query.list;
9 (l.size != 0 ){
10 .out.prln(l.size);
11 .out.prln("login suc");
12 }
13 {
14 .out.prln("login fail");
15 }
16 }
其实说起来也就是用jdbc思路方法根本没什么hibernate技术
下面温习下jdbc链接及查询思路方法
1 try {
2 Class.forName("com.mysql.jdbc.Driver");
3 con = DriverManager.getConnection(url, name, pas);
4 pstate = con.prepareStatement("select count(*) from test where a = ? and b = ?");
5 pstate.Int(1, 1);
6 pstate.Int(2, 1);
7 rs = pstate.executeQuery;
8
9 while(rs.next){
10 .out.prln(rs.getInt(1));
11 }
12
13
14 } catch (ClassNotFoundException e) {
15 e.prStackTrace;
16 } catch (SQLException e) {
17 e.prStackTrace;
18 }
最新评论