logincontrolclass.java~7~

这是Java数据库系统项目开发实践源代码,所有代码经过测试

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 connection;
  public static LoginControlClass self;

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

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

    //定义使用的数据源
    String url = "jdbc:odbc: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.connection = DriverManager.getConnection(url, login, password);
    }
    //获得异常情况
    catch (Exception e) {
      //处理异常情况
      e.printStackTrace();
    }

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

  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 user_password,user_type FROM user_info WHERE user_name='" +
                                      sName + "'");
  }catch(Exception e){}

  String x = "";int usertype;
  try{
  if(uno2.next()) {

  if (uno2.getString(1) != ""){
  x = uno2.getString(1);
  usertype=uno2.getInt(2);
   }

   else{
   JOptionPane.showMessageDialog(null, "userID or password is wrong");
   }

   if (x.equals(sPwd)){
     if(uno2.getInt(2)==0) return 0;
     else return uno2.getInt(2);
     }
     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;
        }
      }

         }

}