?? userlogin.java
字號(hào):
package myBeans;
import java.sql.*;
public class userLogin {
String eno,name,password,email,phone;
String success="false",message="";
Connection con;
Statement sql;
ResultSet rs;
public userLogin(){
//加載橋接器
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e){}
}
//設(shè)置屬性值、獲取屬性值的方法
public void setEno(String num){
eno=num;
}
public String getEno(){
return eno;
}
public void setName(String name){
this.name=name;
}
public String getName(){
return name;
}
public void setPassword(String str){
password=str;
}
public String getPassword(){
return password;
}
public void setEmail(String em){
email=em;
}
public String getEmail(){
return email;
}
public void setPhone(String ph){
phone=ph;
}
public String getphone(){
return phone;
}
public String getSuccess(){
return success;
}
//查詢數(shù)據(jù)庫(kù)的User表
public String getMessage(String Eno, String password){
try{
con=DriverManager.getConnection("jdbc:odbc:bysj","","");
sql=con.createStatement();
String condition="SELECT * FROM users WHERE Eno="+"'"+Eno+"'";
System.out.println(condition);
rs=sql.executeQuery(condition);
int rowcount=0;
String ps=null;
while(rs.next()){
rowcount++;
eno=rs.getString("Eno");
/*Eno=rs.getString("Eno");
logname=rs.getString("logname");
password=rs.getString("password");
realname=rs.getString("realname");
email=rs.getString("email");
phone=rs.getString("phone");
*/
}
if((rowcount==1)&&(password.equals(password))){
message="ok";
success="ok";
System.out.println(message);
}
else{
message="輸入的員工工號(hào)或密碼不正確!";
success="false";
}
con.close();
return message;
}catch(SQLException e){
message="輸入的員工工號(hào)或密碼不正確!";
success="false";
return message;
}
}
}
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -