clslogin_condb.java~20~

这是我在北大青鸟的第一学期的一个毕业设计

import java.sql.*;
import javax.swing.JOptionPane;
import java.io.*;

/**
 * 用户管理数据库连接类
 */
public class clsLogin_condb {
   static FrmBook fm;
    static Connection conLo;
   static Statement stLo;
   static ResultSet rsLo;
    public clsLogin_condb(FrmBook f) {
        fm=f;
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        } catch (ClassNotFoundException ex) {
            JOptionPane.showMessageDialog(fm,"找不到驱动","error",JOptionPane.ERROR_MESSAGE);
        }
        try {
            conLo = DriverManager.getConnection("jdbc:odbc:book");
            stLo=conLo.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

        } catch (SQLException ex1) {
            JOptionPane.showMessageDialog(fm,"连接数据库失败","提示信息",JOptionPane.INFORMATION_MESSAGE);
        }
    }

    /**
     * 判断用户名和密码是否正确，正确则登陆
     * @param UserName String
     * @param Password String
     * @return boolean
     */
    static int IsLogin(String UserName,String Password)
    {

        int i=0;
        String str="select * from admin where username='"+UserName+"'";
        try {
            ResultSet rs1 = stLo.executeQuery(str);
            while(rs1.next())
            {
                if(Password.equals(rs1.getString(2)))
                {
                    i++;
                    if("管理员".equals(rs1.getString(3)))
                    {
                        i=2;
                        break;
                    }
                    if("入库员".equals(rs1.getString(3)))
                    {
                        i=3;
                        break;
                    }
                    if("前台人员".equals(rs1.getString(3)))
                    {
                        i=4;
                        break;
                    }
                    break;
                }
            }

        } catch (SQLException ex) {
            JOptionPane.showMessageDialog(fm,"出错","info",JOptionPane.ERROR_MESSAGE);
        }

        return i;
    }

    /**
     * 添加用户
     */
    static void UserAdd(String Name,String Psw,String Limit)
    {
        String str="insert into admin values('"+Name+"','"+Psw+"','"+Limit+"')";
        try {
            stLo.executeUpdate(str);
            JOptionPane.showMessageDialog(fm,"添加成功","OK",JOptionPane.INFORMATION_MESSAGE);
        } catch (SQLException ex) {
            JOptionPane.showMessageDialog(fm,"添加失败","Sorry",JOptionPane.INFORMATION_MESSAGE);
        }
    }

    /**
     * 删除用户
     */
    static void UserDelete(String Name)
    {
        String str1="select * from admin where username='"+Name+"'";
        String str="delete from admin where username='"+Name+"'";
        try {
            ResultSet rsName=stLo.executeQuery(str1);
            if(rsName.next())
            {
                stLo.executeUpdate(str);
                JOptionPane.showMessageDialog(fm, "删除成功", "OK",
                                              JOptionPane.INFORMATION_MESSAGE);
            }
            else
            {
                JOptionPane.showMessageDialog(fm,"此用户不存在","提示",JOptionPane.INFORMATION_MESSAGE);
            }
         } catch (SQLException ex) {
             JOptionPane.showMessageDialog(fm,"删除失败","Sorry",JOptionPane.INFORMATION_MESSAGE);

        }
    }


}