?? managerloginbean.java
字號:
package internetsignup;
import java.util.Date;
import java.sql.*;
public class ManagerLoginBean
{
String managerName;
String managerPassword;
static Connection con;
static Statement state;
static ResultSet result;
public void setManagerName(String name)
{
managerName=name;
}
public String getManagerName()
{
return managerName;
}
public void setManagerPassword(String pass)
{
managerPassword=pass;
}
public String getManagerPassword()
{
return managerPassword;
}
public ManagerLoginBean()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver" );
}
catch(Exception e)
{}
}
public String checkLogin()
{
try
{
con= DriverManager.getConnection("jdbc:odbc:College", "njgcxx", "njgcxx");
state=con.createStatement();
result=state.executeQuery("select * from ManagerLogin where managerName='"+managerName+"' and managerPassword='"+managerPassword+"'");
if(result.next()) return "success";
else return "fail";
}
catch(Exception e)
{
return "exception";
}
finally
{
try{state.close();con.close();}catch(Exception e){}
}
}
public String getTodayDate()
{
Date d=new Date();
String signupDate=(1900+d.getYear())+"-"+(d.getMonth()+1)+"-"+d.getDate();
return signupDate;
}
public String deleteAll()
{
try
{
con= DriverManager.getConnection("jdbc:odbc:College", "njgcxx", "njgcxx");
state=con.createStatement();
int rs=state.executeUpdate("delete from CollegeStudentInfo");
if(rs>0) return "success";
else return "fail";
}
catch(Exception e)
{
return "exception";
}
finally
{
try{state.close();con.close();}catch(Exception e){}
}
}
public String changePassword()
{
try
{
con= DriverManager.getConnection("jdbc:odbc:College", "njgcxx", "njgcxx");
state=con.createStatement();
int rs=state.executeUpdate("update ManagerLogin set managerPassword='"+managerPassword+"' where managerName='"+managerName+"'");
if(rs>0) return "success";
else return "fail";
}
catch(Exception e)
{
return "exception";
}
finally
{
try{state.close();con.close();}catch(Exception e){}
}
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -