exam-system/ExamData.java at master · mukes555/exam-system · 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
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
import java.sql.*;

public class ExamData {
	Connection cn = null;
	String sblank="";
	String sstar="";
	Statement st;
	String sql;
	ResultSet rs;
	ExamData()
	{
		 try {
	            Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
	            cn = DriverManager.getConnection("jdbc:ucanaccess://exam.mdb");
	            st=cn.createStatement();
	            System.out.println("connection established...");

	        } catch (Exception e) {
	            System.out.println("inside get connection catch ");
	            System.out.println("Exception : " + e);
	            e.printStackTrace();
	        }

	}
	public Connection getConnection()
	{

        try {
            Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
            cn = DriverManager.getConnection("jdbc:ucanaccess://exam.mdb");
            System.out.println("connection established...");

        } catch (Exception e) {
            System.out.println("inside get connection catch ");
            System.out.println("Exception : " + e);
            e.printStackTrace();
        }
        return cn;

    }
	public ResultSet selectCols(String cols,String table,String condtion)
	{
		if(cols.equals(sblank))
			cols="*";
		if(!condtion.equals(sblank))
			condtion=" Where "+condtion;
		String sql="select "+cols+" from "+table+"  "+condtion+"";
		//System.out.println(sql);
		try
		{
			rs=st.executeQuery(sql);
		}
		catch (Exception e)
		{
			System.out.println("inside get connection catch ");
			System.out.println("Exception : " + e);
			e.printStackTrace();
		}
		return rs;
	}
	//select_cols ends here
	public void insertData(String cols,String table,String values)
	{

		try
		{
			if(!cols.isEmpty())
			{
				sql="insert into "+table+"("+cols+") values("+values+") ";
			}
			else
			{
				sql="insert into "+table+" values("+values+")";
			}
			System.out.println(sql);
			st.execute(sql);
		}
		catch (Exception e)
		{
			System.out.println("inside get connection catch ");
			System.out.println("Exception : " + e);
			e.printStackTrace();
		}
	}
}