-
Notifications
You must be signed in to change notification settings - Fork 1
/
AdminDaoImpl.java
107 lines (63 loc) · 2.48 KB
/
AdminDaoImpl.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
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
package com.masai.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.masai.bean.Admin;
import com.masai.exceptions.AdminException;
import com.masai.utility.DBUtill;
import com.masai.utility.DBUtill;
public class AdminDaoImpl implements AdminDao {
@Override
public String registerAdmin(Admin admin) {
String message = "Admin Registration Failed";
try(Connection conn= DBUtill.provideConnection()) {
PreparedStatement ps= conn.prepareStatement
("insert into admin(busid,busname,busroute,bustype,seatavail,"
+ "seatcapacity,dtime,atime,adminid,adminpw) values(?,?,?,?,?,?,?,?,?,?)");
ps.setInt(1, admin.getBusid());
ps.setString(2, admin.getBusname());
ps.setString(3, admin.getBusroute());
ps.setString(4, admin.getBustype());
ps.setInt(5, admin.getSeatAvail());
ps.setInt(6, admin.getSeatCapacity());
ps.setString(7, admin.getDepartTime());
ps.setString(8, admin.getAriveTime());
ps.setString(9, admin.getAdminId());
ps.setString(10, admin.getAdminPw());
int x= ps.executeUpdate();
if(x > 0)
message = "Admin Registered Sucessfully !";
} catch (SQLException e) {
message = e.getMessage();
}
return message;
}
@Override
public Admin loginAdmin(String adminId, String adminPw) throws AdminException {
Admin admin = null;
try(Connection conn = DBUtill.provideConnection()) {
PreparedStatement ps= conn.prepareStatement("select * from admin where adminId = ? AND adminPw = ?");
ps.setString(1, adminId);
ps.setString(2, adminPw);
ResultSet rs= ps.executeQuery();
if(rs.next()) {
int busid= rs.getInt("busid");
String busname= rs.getString("busname");
String busroute= rs.getString("busroute");
String bustype= rs.getString("bustype");
int seatavail= rs.getInt("seatavail");
int seatcapacity= rs.getInt("seatCapacity");
String dtime= rs.getString("Dtime");
String atime= rs.getString("Atime");
String id= rs.getString("adminId");
String pw= rs.getString("adminPw");
admin= new Admin(busid, busname,busroute,bustype,seatavail,seatcapacity,dtime,atime,id,pw);
}else
throw new AdminException("Invalid Username or password.. ");
} catch (SQLException e) {
throw new AdminException(e.getMessage());
}
return admin;
}
}