xuexiaoxinxishezhi.java

中小学校园的教师

package untitled2;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import com.borland.jbcl.layout.*;
import java.awt.event.*;
import com.borland.jbcl.layout.*;
import java.sql.*;
import java.sql.Statement;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.ResultSet;
import com.borland.dbswing.*;
import java.awt.event.*;
import com.borland.dx.sql.dataset.*;


/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2006</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class xueXiaoXInXiSheZhi extends JFrame {
  XYLayout xYLayout1 = new XYLayout();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JLabel jLabel5 = new JLabel();
  JLabel jLabel6 = new JLabel();
  JScrollPane jScrollPane1 = new JScrollPane();
  JButton jButton3 = new JButton();
  JLabel jLabel8 = new JLabel();
  JScrollPane jScrollPane2 = new JScrollPane();
  JButton jButton5 = new JButton();
  Database database1 = new Database();
  QueryDataSet queryDataSet1 = new QueryDataSet();
  JButton jButton1 = new JButton();
  JTextField jTextField1 = new JTextField();
  JTextField jTextField2 = new JTextField();
  JTextField jTextField3 = new JTextField();
  JTextField jTextField4 = new JTextField();
  JTextArea jTextArea1 = new JTextArea();
  JTextArea jTextArea2 = new JTextArea();

  public xueXiaoXInXiSheZhi() {
    try {
      jbInit();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }

  void jbInit() throws Exception {
    this.setResizable(false);
    this.setSize(new Dimension(800, 600));
    this.setTitle("欢迎您进入学校基本信息设置界面");
    this.getContentPane().setLayout(xYLayout1);
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel2.setText("学校编号");
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel3.setText("学校名称");
    jLabel4.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel4.setText("校长");
    jLabel5.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel5.setText("学校地址");
    jLabel6.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel6.setText("学校历史");
    jButton3.setFont(new java.awt.Font("Dialog", 0, 13));
    jButton3.setText("取消");
    jButton3.addActionListener(new xueXiaoXInXiSheZhi_jButton3_actionAdapter(this));
    jLabel8.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel8.setText("备注");
    jButton5.setText("提交");
    jButton5.addActionListener(new xueXiaoXInXiSheZhi_jButton5_actionAdapter(this));
    jButton5.setFont(new java.awt.Font("Dialog", 0, 13));
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:Digital_campus", "dbw", "123456", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
    database1.setTransactionIsolation(java.sql.Connection.TRANSACTION_NONE);
    database1.setDatabaseName("");
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT *\nFROM dbo.school", null, true, Load.ALL));
    jButton1.setFont(new java.awt.Font("Dialog", 0, 13));
    jButton1.setText("更改");
    jButton1.addActionListener(new xueXiaoXInXiSheZhi_jButton1_actionAdapter(this));
    jTextField1.setText("");
    jTextField1.setHorizontalAlignment(SwingConstants.RIGHT);
    jTextField2.setText("");
    jTextField2.setHorizontalAlignment(SwingConstants.RIGHT);

    jTextField3.setText("");
    jTextField3.setHorizontalAlignment(SwingConstants.RIGHT);
    jTextField4.setText("");
    jTextField4.setHorizontalAlignment(SwingConstants.RIGHT);
    jTextArea1.setText("");
    this.getContentPane().add(jLabel4, new XYConstraints(281, 55, -1, -1));
    this.getContentPane().add(jLabel5, new XYConstraints(271, 96, -1, -1));
    this.getContentPane().add(jLabel6, new XYConstraints(36, 135, -1, -1));
    this.getContentPane().add(jScrollPane1,    new XYConstraints(32, 166, 682, 157));
    jScrollPane1.getViewport().add(jTextArea1, null);
    this.getContentPane().add(jLabel3, new XYConstraints(41, 95, -1, -1));
    this.getContentPane().add(jLabel8,    new XYConstraints(34, 333, -1, -1));
    this.getContentPane().add(jScrollPane2,              new XYConstraints(30, 357, 684, 126));
    jScrollPane2.getViewport().add(jTextArea2, null);
    this.getContentPane().add(jLabel2,  new XYConstraints(39, 56, -1, -1));
    this.getContentPane().add(jButton5,  new XYConstraints(302, 488, -1, -1));
    this.getContentPane().add(jTextField1,  new XYConstraints(114, 51, 86, -1));
    this.getContentPane().add(jTextField2,   new XYConstraints(114, 94, 88, -1));
    this.getContentPane().add(jTextField3,  new XYConstraints(358, 47, 85, -1));
    this.getContentPane().add(jTextField4,  new XYConstraints(356, 92, 174, -1));
    this.getContentPane().add(jButton1, new XYConstraints(206, 486, 68, 31));
    this.getContentPane().add(jButton3, new XYConstraints(393, 487, -1, -1));

    String sql = "select * from school";

           Connection con = null;
               try{
                 con = DBConnection.getConnection();
                 PreparedStatement ps = con.prepareStatement(sql);
                  ResultSet rs = ps.executeQuery();
                 if(rs.next())
                 {
                   jTextField1.setText(String.valueOf(rs.getInt(1)));

                   jTextField2.setText(rs.getString(2));
                   jTextField4.setText(rs.getString(3));
                   jTextArea1.setText(rs.getString(4));
                   jTextArea2.setText(rs.getString(5));
                   jTextField3.setText(rs.getString(6));

           }
               DbUtil.close(ps);
               }catch(Exception ex){
                 ex.printStackTrace();
               }finally{
                 DbUtil.close(con);
               }
               jTextField1.setEditable(false);
               jTextField2.setEditable(false);
               jTextField3.setEditable(false);
               jTextField4.setEditable(false);
               jTextArea1.setEditable(false);
               jTextArea2.setEditable(false);
}

  void jButton3_actionPerformed(ActionEvent e) {
this.dispose();
  }



  void jButton5_actionPerformed(ActionEvent e) {
    String sql = "update school set school_id=?,school_name=?,school_address=?,school_history=?,school_content=?,school_master=?";

        Connection con = null;
            try{
              con = DBConnection.getConnection();
              PreparedStatement ps = con.prepareStatement(sql);
                      ps.setString(1, jTextField1.getText());
                       ps.setString(2, jTextField2.getText());
                       ps.setString(3, jTextField4.getText());
                       ps.setString(4, jTextArea1.getText());
                       ps.setString(5, jTextArea2.getText());
                       ps.setString(6, jTextField3.getText());


                   ps.executeUpdate();
                   JOptionPane.showMessageDialog(null, "更改成功！");

              DbUtil.close(ps);
            }catch(Exception ex){
              ex.printStackTrace();
            }finally{
              DbUtil.close(con);
            }
            sql = "select * from school";

           con = null;
               try{
                 con = DBConnection.getConnection();
                 PreparedStatement ps = con.prepareStatement(sql);
                  ResultSet rs = ps.executeQuery();
                 if(rs.next())
                 {
                   jTextField1.setText(String.valueOf(rs.getInt(1)));
                   jTextField2.setText(rs.getString(2));
                  jTextField4.setText(rs.getString(3));
                   jTextArea1.setText(rs.getString(4));
                   jTextArea2.setText(rs.getString(5));
                    jTextField3.setText(rs.getString(6));


           }
            jTextField1.setEditable(false);
           jTextField2.setEditable(false);
   jTextField3.setEditable(false);
   jTextField4.setEditable(false);
   jTextArea1.setEditable(false);
   jTextArea2.setEditable(false);

               DbUtil.close(ps);
               }catch(Exception ex){
                 ex.printStackTrace();
               }finally{
                 DbUtil.close(con);
               }



  }

  void jButton1_actionPerformed(ActionEvent e) {
        jTextField1.setEditable(true);
        jTextField2.setEditable(true);
        jTextField3.setEditable(true);
        jTextField4.setEditable(true);
        jTextArea1.setEditable(true);
        jTextArea2.setEditable(true);

  }







}

class xueXiaoXInXiSheZhi_jButton3_actionAdapter implements java.awt.event.ActionListener {
  xueXiaoXInXiSheZhi adaptee;

  xueXiaoXInXiSheZhi_jButton3_actionAdapter(xueXiaoXInXiSheZhi adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton3_actionPerformed(e);
  }
}

class xueXiaoXInXiSheZhi_jButton5_actionAdapter implements java.awt.event.ActionListener {
  xueXiaoXInXiSheZhi adaptee;

  xueXiaoXInXiSheZhi_jButton5_actionAdapter(xueXiaoXInXiSheZhi adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton5_actionPerformed(e);
  }
}

class xueXiaoXInXiSheZhi_jButton1_actionAdapter implements java.awt.event.ActionListener {
  xueXiaoXInXiSheZhi adaptee;

  xueXiaoXInXiSheZhi_jButton1_actionAdapter(xueXiaoXInXiSheZhi adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}