?? logindao.java
字號:
package com.jxyd.dao;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.jxyd.sql.Mysql;
import com.jxyd.sql.SimpleSqlControl;
import com.jxyd.vo.AdminBean;
import com.jxyd.vo.UserBean;
public class LoginDAO {
private String User_table = "user";
private String Admin_table = "admin";
/**
* 用戶登錄驗證 sign為1時表示管理員登錄驗證,為2時表示用戶
*
* @param username
* @param pwd
* @param sign
* @return
*/
public boolean LoginValidate(String username, String pwd, Integer sign) {
boolean flag = false;
String sql = null;
Mysql ms = new Mysql();
if (sign == 1) {
sql = "select * from " + Admin_table + " where WorkNum='"
+ username + "' and Password='" + pwd + "'";
} else if (sign == 2) {
sql = "select * from " + User_table + " where UserId='" + username
+ "' and Password='" + pwd + "'";
}
try {
ms.prepareStatement(sql);
ResultSet rs = ms.executeQuery(sql);
if (rs.next()) {
flag = true;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
ms.freeResource();
}
return flag;
}
public UserBean selectuser(String username){
String sql="select * from "+User_table+" where UserId="+username;
SimpleSqlControl scon=new SimpleSqlControl();
UserBean ub=null;
try {
ub=(UserBean)scon.sqlSearchObject(sql, "com.jxyd.vo.UserBean");
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return ub;
}
public AdminBean selectadmin(String username){
String sql="select * from "+Admin_table+" where WorkNum="+username;
SimpleSqlControl scon=new SimpleSqlControl();
AdminBean ab=null;
try {
ab=(AdminBean)scon.sqlSearchObject(sql, "com.jxyd.vo.AdminBean");
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return ab;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -