?? getinfo.java
字號:
package com.yourcompany.struts.action;
import java.sql.*;
import com.yourcompany.struts.form.*;
public class getInfo {
public int checkLogin (LogonForm logonForm){
Connection con=null;
int check=0;
try{
Statement state ;
ResultSet rst;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:db");
state=con.createStatement();
String name=logonForm.getName();
String pwd=logonForm.getPassword();
String sql="select role from info where name='"+name+"'and password='"+pwd+"'";
rst=state.executeQuery(sql);
String rolename="0";
if(rst.next()){
rolename=rst.getString(1);
}
if(rolename.equals("1")) check=1;
else
if(rolename.equals("2"))check=2;
else check=3;
}
catch (SQLException sqle){
System.err.println(sqle.getMessage());
}
catch (Exception e){
System.err.println(e.getMessage());
}
finally {
try{
if(con!=null){
con.close();
}
}
catch(SQLException sqle){
System.err.println(sqle.getMessage());
}
}
return check;
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -