Hibernate_using_ajax/RegDao.java at master · Smit7550/Hibernate_using_ajax · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
package dao;

import java.util.ArrayList;
import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

import vo.RegVo;
import vo.RegVo1;

public class RegDao {
	public List search(RegVo obj)
	{
		List ls = new ArrayList();
		try
		{
			SessionFactory s=new Configuration().configure().buildSessionFactory();

			Session s1 = s.openSession();

			Transaction t = s1.beginTransaction();

			Query q = s1.createQuery("from RegVo WHERE username='"+obj.getUsername()+"' and password='"+obj.getPassword()+"'");
			ls = q.list();

			t.commit();

			s1.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		return ls;
	}

	public List search(RegVo1 obj)
	{
		List ls = new ArrayList();
		try
		{
			SessionFactory s=new Configuration().configure().buildSessionFactory();

			Session s1 = s.openSession();

			Transaction t = s1.beginTransaction();

			Query q = s1.createQuery("from RegVo1 WHERE firstname='"+obj.getFirstname()+"'");
			ls = q.list();

			t.commit();

			s1.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		return ls;
	}
}