sc_leap.java

一款高校科研管理系统

package scince;

import java.awt.*;

import javax.swing.*;
import java.awt.BorderLayout;
import java.awt.Rectangle;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.SQLException;
import javax.swing.JOptionPane;

public class sc_leap extends JFrame {
    public sc_leap() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        jLabel1.setForeground(Color.cyan);
        jLabel1.setText("成果编号*");
        jLabel1.setBounds(new Rectangle(5, 13, 95, 31));
        jButton4.addActionListener(new sc_leap_jButton4_actionAdapter(this));
        jButton1.addActionListener(new sc_leap_jButton1_actionAdapter(this));
        jButton2.addActionListener(new sc_leap_jButton2_actionAdapter(this));
        jButton3.addActionListener(new sc_leap_jButton3_actionAdapter(this));
        jButton4.setBounds(new Rectangle(265, 257, 75, 29));
        jButton4.setForeground(Color.cyan);
        jButton4.setText("退出");
        jButton3.setBounds(new Rectangle(178, 258, 71, 30));
        jButton3.setForeground(Color.cyan);
        jButton3.setText("添加");
        jButton2.setBounds(new Rectangle(90, 258, 73, 32));
        jButton2.setForeground(Color.cyan);
        jButton2.setText("删除");
        jButton1.setBounds(new Rectangle(12, 258, 72, 32));
        jButton1.setForeground(Color.cyan);
        jButton1.setText("查看");
        jTextField6.setForeground(Color.cyan);
        jTextField6.setBounds(new Rectangle(288, 112, 93, 32));
        jTextField5.setForeground(Color.cyan);
        jTextField5.setBounds(new Rectangle(290, 55, 94, 33));
        jTextField4.setForeground(Color.cyan);
        jTextField4.setSelectionEnd(11);
        jTextField4.setSelectionStart(11);
        jTextField4.setBounds(new Rectangle(84, 109, 90, 28));
        jTextField3.setForeground(Color.cyan);
        jTextField3.setBounds(new Rectangle(83, 62, 89, 31));
        jTextField2.setForeground(Color.cyan);
        jTextField2.setBounds(new Rectangle(290, 14, 93, 30));
        jTextField1.setForeground(Color.cyan);
        jTextField1.setBounds(new Rectangle(85, 17, 88, 30));
        jLabel6.setForeground(Color.cyan);
        jLabel6.setText("批准时间");
        jLabel6.setBounds(new Rectangle(200, 107, 60, 40));
        jLabel5.setForeground(Color.cyan);
        jLabel5.setText("级别");
        jLabel5.setBounds(new Rectangle(205, 63, 49, 28));
        jLabel4.setForeground(Color.cyan);
        jLabel4.setText("类别");
        jLabel4.setBounds(new Rectangle(13, 101, 56, 32));
        jLabel3.setForeground(Color.cyan);
        jLabel3.setText("项目名称");
        jLabel3.setBounds(new Rectangle(8, 67, 55, 35));
        jLabel7.setForeground(Color.cyan);
        jLabel7.setText("请输入成果编号来查看或删改");
        jLabel7.setBounds(new Rectangle(32, 145, 171, 33));
        jTextField7.setForeground(Color.cyan);
        jTextField7.setBounds(new Rectangle(42, 178, 90, 29));
        jButton5.setBounds(new Rectangle(224, 178, 106, 33));
        jButton5.setForeground(Color.cyan);
        jButton5.setText("清除所有信息");
        jButton5.addActionListener(new sc_leap_jButton5_actionAdapter(this));
        this.getContentPane().setBackground(new Color(234, 37, 161));
        jLabel2.setForeground(Color.cyan);
        this.getContentPane().add(jLabel2);
        this.getContentPane().add(jTextField2);
        this.getContentPane().add(jLabel3);
        this.getContentPane().add(jLabel4);
        this.getContentPane().add(jLabel5);
        this.getContentPane().add(jTextField5);
        this.getContentPane().add(jLabel6);
        this.getContentPane().add(jButton2);
        this.getContentPane().add(jTextField6);
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(jTextField3);
        this.getContentPane().add(jTextField1);
        this.getContentPane().add(jLabel7);
        this.getContentPane().add(jTextField7);
        this.getContentPane().add(jButton5);
        this.getContentPane().add(jButton3);
        this.getContentPane().add(jButton1);
        this.getContentPane().add(jButton4);
        this.getContentPane().add(jTextField4);
        jLabel2.setText("项目编号*");
        jLabel2.setBounds(new Rectangle(194, 6, 69, 40));
    }

    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JLabel jLabel6 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JTextField jTextField2 = new JTextField();
    JTextField jTextField3 = new JTextField();
    JTextField jTextField4 = new JTextField();
    JTextField jTextField5 = new JTextField();
    JTextField jTextField6 = new JTextField();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JButton jButton3 = new JButton();
    JButton jButton4 = new JButton();
    JLabel jLabel7 = new JLabel();
    JTextField jTextField7 = new JTextField();
    JButton jButton5 = new JButton();
    public void jButton4_actionPerformed(ActionEvent e) {
        this.dispose();
    }

    public void jButton1_actionPerformed(ActionEvent e) {
        Connection con;
        Statement sql;
        ResultSet rs;
        String queryString;
        if (!jTextField7.getText().equals("")) {
            queryString = "select * from 科研成果 where 成果编号=" +
                          Integer.parseInt(jTextField7.getText());
        } else {
            queryString = "";
            JOptionPane.showMessageDialog(null, "请输入您要查看的成果编号",
                                          "科研管理查询对话框",
                                          JOptionPane.INFORMATION_MESSAGE);
        }

        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        } catch (java.lang.ClassNotFoundException ee) {
            System.err.print("class not find!");
            System.err.println(ee.getMessage());
        }

        try {
            con = DriverManager.getConnection("jdbc:odbc:scince", "", "");
            sql = con.createStatement();
            rs = sql.executeQuery(queryString);
            if (rs.next()) {
                jTextField1.setText(Integer.toString(rs.getInt(1)));
                jTextField2.setText(Integer.toString(rs.getInt(2)));
                jTextField3.setText(rs.getString(3));
                jTextField4.setText(rs.getString(4));
                jTextField5.setText(Integer.toString(rs.getInt(5)));
                jTextField6.setText(rs.getString(6));

            } else {
                JOptionPane.showMessageDialog(null, "没有找到您要求的项目！",
                                              "科研管理查询对话框",
                                              JOptionPane.INFORMATION_MESSAGE);
                jTextField7.setText("");
            }

            con.close();
        } catch (SQLException ex) {}
    }

    public void jButton2_actionPerformed(ActionEvent e) {
        Connection con;
        Statement sql;
        ResultSet rs;
        String queryString; // 删除语句
        String queryString1; //查找确认语句
        if (!jTextField7.getText().equals("")) {
            queryString = "DELETE from 科研成果 where 成果编号=" +
                          Integer.parseInt(jTextField7.getText());
            queryString1 = "select * from 科研成果 where 成果编号=" +
                           Integer.parseInt(jTextField7.getText());
        } else {
            queryString = "";
            queryString1 = "";
            JOptionPane.showMessageDialog(null, "请输入你要删除的成果编号", "科研成果删除对话框",
                                          JOptionPane.INFORMATION_MESSAGE);

        }

        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        } catch (java.lang.ClassNotFoundException ee) {
            System.err.print("class not find!");
            System.err.println(ee.getMessage());
        }
        try {
            con = DriverManager.getConnection("jdbc:odbc:scince", "", "");
            sql = con.createStatement();
            rs = sql.executeQuery(queryString1);
            if (rs.next()) {
                JOptionPane.showMessageDialog(null, "删除成功！", "科研成果删除对话框",
                                              JOptionPane.INFORMATION_MESSAGE);
                jTextField7.setText("");
            } else {
                JOptionPane.showMessageDialog(null, "没有找到您要删除的成果项目！",
                                              "科研成果删除对话框",
                                              JOptionPane.INFORMATION_MESSAGE);
            }

            sql.executeUpdate(queryString);
            con.close();
            jTextField1.setText(""); //将窗口清空
            jTextField2.setText("");
            jTextField3.setText("");
            jTextField4.setText("");
            jTextField5.setText("");
            jTextField6.setText("");
        } catch (SQLException ex) {}
    }

    public void jButton3_actionPerformed(ActionEvent e) {
        Connection con;
        Statement sql;
        String queryString;
        if(!jTextField1.getText().equals("")){
        queryString = "INSERT INTO 科研成果 VALUES('" +
                      Integer.parseInt(jTextField1.getText()) + "','" +
                      Integer.parseInt(jTextField2.getText()) + "','" +
                      jTextField3.getText() + "','" + jTextField4.getText() +
                      "','" + Integer.parseInt(jTextField5.getText()) + "','" +
                      jTextField6.getText() + "')";

        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        } catch (java.lang.ClassNotFoundException ee) {
            System.err.print("class not find!");
            System.err.println(ee.getMessage());

        }
        try {
            con = DriverManager.getConnection("jdbc:odbc:scince", "", "");
            sql = con.createStatement();
            sql.executeUpdate(queryString);
            con.close();
            jTextField1.setText("");
            jTextField2.setText("");
            jTextField3.setText("");
            jTextField4.setText("");
            jTextField5.setText("");
            jTextField6.setText("");

        } catch (SQLException ex) {
            JOptionPane.showMessageDialog(null, "添加有错误，输入不完整或项目编号不存在",
                                          "科研成果添加对话框",
                                          JOptionPane.INFORMATION_MESSAGE);
        }}
    else
       {  queryString="";
           JOptionPane.showMessageDialog(null,"成果编号不能为空！","添加异常对话框",JOptionPane.WARNING_MESSAGE);
           System.out.print("Hello!");
       }


    }

    public void jButton5_actionPerformed(ActionEvent e) {
        jTextField1.setText("");
        jTextField2.setText("");
        jTextField3.setText("");
        jTextField4.setText("");
        jTextField5.setText("");
        jTextField6.setText("");
        jTextField7.setText("");

    }
}


class sc_leap_jButton5_actionAdapter implements ActionListener {
    private sc_leap adaptee;
    sc_leap_jButton5_actionAdapter(sc_leap adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton5_actionPerformed(e);
    }
}


class sc_leap_jButton2_actionAdapter implements ActionListener {
    private sc_leap adaptee;
    sc_leap_jButton2_actionAdapter(sc_leap adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton2_actionPerformed(e);
    }
}


class sc_leap_jButton1_actionAdapter implements ActionListener {
    private sc_leap adaptee;
    sc_leap_jButton1_actionAdapter(sc_leap adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton1_actionPerformed(e);
    }
}


class sc_leap_jButton4_actionAdapter implements ActionListener {
    private sc_leap adaptee;
    sc_leap_jButton4_actionAdapter(sc_leap adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton4_actionPerformed(e);
    }
}


class sc_leap_jButton3_actionAdapter implements ActionListener {
    private sc_leap adaptee;
    sc_leap_jButton3_actionAdapter(sc_leap adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton3_actionPerformed(e);
    }
}