-
Notifications
You must be signed in to change notification settings - Fork 0
/
Admin.java
80 lines (66 loc) · 1.99 KB
/
Admin.java
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
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package com.user;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
/**
*
* @author Muneeb
*/
public class Admin {
private Connection con;
private Statement stmt;
private ResultSet re;
protected String userName;
protected String name;
protected String email;
protected String password;
protected String phone;
public boolean connect() throws Exception
{
try
{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url="jdbc:sqlserver://localhost:1433;databaseName=CareerCounsellingSystem";
String name="new_user";
String password="123";
con=DriverManager.getConnection(url,name,password);
stmt=con.createStatement();
return true;
}
catch(SQLException e)
{
System.out.print(e);
return false;
}
}
public List<Profile> viewUsers(){
List<Profile> result = new ArrayList<Profile>();
try{
String create = "select * from [Profile]";
re = stmt.executeQuery(create);
while(re.next()){
String usrName =re.getString("userName");
String usrType = re.getString("userType");
Profile user = new Profile(); // Creating a user object to fill with user data (I imagine that you have a user class in your model)
user.setUserName(usrName);
user.setUserType(usrType);
//Add the retrived user to the list
result.add(user);
}
//Returning the list of users.
return result;
}catch(Exception e){
e.printStackTrace();
return null;
}
}
}