?? verification.java
字號:
package dbms;
import java.sql.*;
import entity.*;
public class Verification {
//驗證管理員合法性
public static boolean isLegal(Admin admin) throws Exception{
boolean isRight =false;
String str=new String("select * from administrator where adminNo=? and adminPass=?");
Connection conn =DBConnection.createConn();
PreparedStatement pstmt=conn.prepareStatement(str);
pstmt.setString(1, admin.getNo());
pstmt.setString(2, admin.getPassword());
ResultSet rs=pstmt.executeQuery();
if(rs.next()){
isRight=true;
admin.setName(rs.getString("adminName"));
}
rs.close();
pstmt.close();
conn.close();
return isRight;
}
// 驗證教師合法性
public static boolean isLegal(Teacher teacher)throws Exception{
boolean isRight =false;
String str=new String("select * from teacher where teachNo=? and teachPassword=?");
Connection conn =DBConnection.createConn();
PreparedStatement pstmt=conn.prepareStatement(str);
pstmt.setString(1, teacher.getNo());
pstmt.setString(2, teacher.getPassword());
ResultSet rs=pstmt.executeQuery();
if(rs.next()){
isRight=true;
teacher.setName(rs.getString("teachName"));
teacher.setDepartmentNo(rs.getString("departmentNo"));
teacher.setAddr(rs.getString("teachAddr"));
teacher.setPhone(rs.getString("teachPhone"));
teacher.setPhotoName(rs.getString("teachPhotoName"));
}
rs.close();
pstmt.close();
conn.close();
return isRight;
}
// 驗證學生合法性
public static boolean isLegal(Student std)throws Exception{
boolean isRight =false;
String str=new String("select * from student where stuUnifiedNo=? and stdPass=?");
Connection conn =DBConnection.createConn();
PreparedStatement pstmt=conn.prepareStatement(str);
pstmt.setString(1, std.getUnifiedNo());
pstmt.setString(2, std.getPassword());
ResultSet rs=pstmt.executeQuery();
if(rs.next()){
isRight=true;
std.setName(rs.getString("stdName"));
std.setClassNo(rs.getString("ClassNo"));
std.setNo(rs.getString("stuNo"));
std.setSex(rs.getString("stdSex"));
std.setAddr(rs.getString("stdAddr"));
std.setPhone(rs.getString("stdPhone"));
std.setGrade(rs.getString("stdGrade"));
std.setAntecedent(rs.getString("stdAntecedent"));
std.setEnterTime(rs.getString("stdEnterTime"));
std.setPhotoName(rs.getString("photoName"));
std.setJcDescription(rs.getString("JCDescription"));
std.setXjInfor(rs.getString("XJInfor"));
std.setWhereToGo(rs.getString("whereToGo"));
}
rs.close();
pstmt.close();
conn.close();
return isRight;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -