commonajdbc.java~1~

S1项目本需求规格说明描述了北大青鸟ACCP教学管理系统项目的要求

package xiangmu;

import java.awt.*;
import java.sql.Connection;
import java.sql.DriverManager;
import javax.swing.*;
import java.sql.ResultSet;
import java.sql.PreparedStatement;

/**
 * <p>Title: 第四学习小组-教学管理系统</p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class CommonaJdbc extends JFrame {
    BorderLayout borderLayout1 = new BorderLayout();


    public CommonaJdbc() {
        try {
            jbInit();
            try {
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                    Connection con=DriverManager.getConnection("jdbc:odbc:xiangmu");
                    PreparedStatement pre=con.prepareStatement("select UserName,Password,UserType from SysUser where UserName=? and Password=? and UserType=?");
                    pre.setString(1,this.txtUserName.getText());
                    pre.setString(2,String.valueOf(this.txtPassword.getPassword()));
                    pre.setString(3,this.cmbUserType.getSelectedItem().toString());
                    ResultSet re=pre.executeQuery();
                    if (re.next()) {
                    if (type.equals("系统管理员")) {
                    this.mnusuperadd.setEnabled(true);
                    this.mnustu.setEnabled(true);
                    this.mnuclass.setEnabled(true);
                    this.mnuremerk.setEnabled(true);
                    this.btnclassadd.setEnabled(true);
                    this.btnclassselect.setEnabled(true);
                    this.btnremarkadd.setEnabled(true);
                    this.btnremarkselect.setEnabled(true);
                    this.btnstuadd.setEnabled(true);
                    this.btnstuselect.setEnabled(true);
                    this.trmod.setEnabled(true);
                    this.btnallselect.setEnabled(true);
                    this.btnexit.setEnabled(true);
                    this.btnzhuxiao.setEnabled(true);
                }
                if (type.equals("普通用户")) {
                    this.mnusuperadd.setEnabled(false);
                    this.mnustu.setEnabled(false);
                    this.mnuclass.setEnabled(false);
                    this.mnuremerk.setEnabled(false);
                    this.btnstuadd.setEnabled(false);
                    this.btnclassadd.setEnabled(false);
                    this.btnremarkadd.setEnabled(false);
                    this.btnclassselect.setEnabled(true);
                    this.btnremarkselect.setEnabled(true);
                    this.btnstuselect.setEnabled(true);
                    this.btnallselect.setEnabled(true);
                }
            }
        } catch (Exception ex) {
        }
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(borderLayout1);
    }
}