logincontrolclass.java~3~

Java数据库系统项目开发实践2这本书的所有代码

package enterpriseemployeeadministrate;

import java.sql.*; // JDBC package
import java.io.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class LoginControlClass {
  //定义数据库连接的一些参数
  static Connection dbConn;
  public static LoginControlClass self;

//设置连接数据库的方法，它的类型是connection
 static Connection getConn() {
    try{
      //如果数据库的连接没有被关闭，就使用这一连接
      if (self != null && ! (self.dbConn.isClosed())) {
        return self.dbConn;
      }
    }
    //处理异常情况
    catch(Exception err){
      //不做任何的事情
      err.printStackTrace() ;
    }

    //设置本类
    self = new LoginControlClass();

    //定义使用的数据源
    String url = "jdbc:inetdae7:localhost:1433?database=person"; // use your hostname and port number here
    //登录数据库的用户名
    String login = "";
    //登录数据库的密码
    String password = "";

    //试着连接数据库
    try {
     //调试数据库连接情况
      DriverManager.setLogStream(System.out);
      //指定数据库的驱动程序是哪一种驱动，并且实例化
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
      //设置数据库连接在10秒后，连接不上失效
      DriverManager.setLoginTimeout(10);
      //使用驱动程序连接数据库
      self.dbConn = DriverManager.getConnection(url, login, password);
    }
    //获得异常情况
    catch (Exception e) {
      //处理异常情况
      e.printStackTrace();
    }

    //如果一切进展顺利，返回连接成功
    return self.dbConn;
  }

  public static String getString(String s) {
    String temp;
    try {
      //s = new String( s.getBytes("GBK"),"ISO8859_1");
      temp = new String(s.getBytes("ISO8859_1"), "GBK");
    }
    catch (UnsupportedEncodingException e) {
      temp = "Error code";
    }
    return temp;
  }

public String getUserName(String sName1){
    return sName1;
  }

  public String getUserpass(String password){
    return password;
  }



      public  int getUserType(String sName, String sPwd){
        Statement st2=null;
        ResultSet uno2=null;
        Connection connection1=null;
            try
            {
              connection1 = LoginControlClass.getConn();
              st2 = connection1.createStatement();
              uno2 = st2.executeQuery("SELECT passw,userTypeNo FROM userTable WHERE userID='" +
                                      sName + "'");
            }catch(Exception e){}
            String x = "";int usertype;
       try{
      if(uno2.next()) {
        if (uno2.getString(1) != null)
         {
          x = uno2.getString("passw");
          usertype=uno2.getInt("userTypeNO");
          }
     else
     {
     JOptionPane.showMessageDialog(null, "userID or password is wrong");
     }
     if (x.equals(sPwd))
     {
     if(uno2.getInt("userTypeNo")==0) return 0;
     else return uno2.getInt("userTypeNo");
     }
     else return 0;
     }
     else return 0;
    }
    catch (SQLException err) {
        err.printStackTrace();

       return 0;
      }
      finally {
        try {
          uno2.close();

          //close the objects
          st2.close();
       connection1.close();
        }
        catch (Exception err) {
          return 0;
        }
      }

         }

}