checklogin.java

来自「在线考试 jsp+javabean 主要对试题管理 实现分页显示统计分数 」· Java 代码 · 共 62 行

package com;
import java.sql.*;

public class checklogin {


		  public checklogin() {
		  }

		  /* 判断登陆是否正确*/
		  public int isSysUser(String username, String password) {
		    int i = 0;
		    ResultSet rs = null;
		    Connection con = null;
		    Statement stmt = null;
		    String slevel="";
		    dbconnectionbean.ConnectionPoolBean mytest = new dbconnectionbean.
		        ConnectionPoolBean();

		    String sql = "select * from login where username='" + username +
		        "' and password='" + password + "'";

		    System.out.println("sql:" + sql);

		    try {

		      mytest.setinit();
		      mytest.setName("gateway");
		      con = mytest.getSqlCon();

		      stmt = con.createStatement();

		      rs = stmt.executeQuery(sql);
		      

		      if (rs.next()) {
		       slevel=rs.getString(4);
		        if(slevel.equals("0")){
		        	i = 0;
		        	
		        }else if(slevel.equals("1")){
		        	
		        	i=1;
		        	
		        }
		    	  
		    	 
		      }
		      else
		        i = 2;
		    }
		  
		    catch (SQLException ex) {
		      System.out.print(ex.getMessage());
		    }

		    return i;
		  }
 
		 
}