📄 frame2.java
字号:
package 学生简易注册管理系统;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import com.borland.jbcl.layout.*;
import com.borland.dbswing.*;
import com.borland.dx.sql.dataset.*;
import java.sql.SQLException;
import java.sql.*;
/**
* <p>Title: </p>
* <p>Description: </p>
* <p>Copyright: Copyright (c) 2005</p>
* <p>Company: </p>
* @author privle
* @version 1.0
*/
public class Frame2 extends JFrame {
JPanel contentPane;
JLabel jLabel1 = new JLabel();
Panel panel1 = new Panel();
JTextField jTextField1 = new JTextField();
JLabel jLabel2 = new JLabel();
JLabel jLabel3 = new JLabel();
JLabel jLabel4 = new JLabel();
JLabel jLabel5 = new JLabel();
JLabel jLabel6 = new JLabel();
JLabel jLabel7 = new JLabel();
JTextField jTextField2 = new JTextField();
JTextField jTextField3 = new JTextField();
JTextField jTextField4 = new JTextField();
JTextField jTextField5 = new JTextField();
JTextField jTextField6 = new JTextField();
JLabel jLabel8 = new JLabel();
JButton jButton1 = new JButton();
JTextField jTextField7 = new JTextField();
JButton jButton2 = new JButton();
JButton jButton3 = new JButton();
JPanel jPanel1 = new JPanel();
Database database1 = new Database();
DBDisposeMonitor dBDisposeMonitor1 = new DBDisposeMonitor();
QueryDataSet queryDataSet1 = new QueryDataSet();
TableScrollPane tableScrollPane1 = new TableScrollPane();
XYLayout xYLayout1 = new XYLayout();
JdbStatusLabel jdbStatusLabel1 = new JdbStatusLabel();
JOptionPane jOptionPane1 = new JOptionPane();
boolean flag = false;
JButton jButton4 = new JButton();
JdbTable jdbTable1 = new JdbTable();
//Construct the frame
public Frame2() {
enableEvents(AWTEvent.WINDOW_EVENT_MASK);
try {
jbInit();
}
catch (Exception e) {
e.printStackTrace();
}
}
//Component initialization
private void jbInit() throws Exception {
contentPane = (JPanel)this.getContentPane();
jLabel1.setBackground(new Color(236, 213, 216));
jLabel1.setFont(new java.awt.Font("Dialog", 2, 30));
jLabel1.setForeground(new Color(80, 70, 170));
jLabel1.setText("查询/修改/删除记录");
jLabel1.setBounds(new Rectangle(181, 15, 288, 46));
contentPane.setLayout(null);
this.setCursor(null);
this.setDefaultCloseOperation(DISPOSE_ON_CLOSE);
this.setSize(new Dimension(618, 480));
this.setTitle("Frame Title");
panel1.setBackground(SystemColor.inactiveCaption);
panel1.setLocale(java.util.Locale.getDefault());
panel1.setBounds(new Rectangle(12, 115, 200, 270));
panel1.setLayout(null);
jTextField1.setFont(new java.awt.Font("Dialog", 0, 12)); jTextField1.setText("");
jTextField1.setBounds(new Rectangle(81, 12, 107, 28));
jLabel2.setFont(new java.awt.Font("Dialog", 0, 12));
jLabel2.setText("学生编号");
jLabel2.setBounds(new Rectangle(3, 14, 56, 35));
jLabel3.setFont(new java.awt.Font("Dialog", 0, 12));
jLabel3.setText("姓名");
jLabel3.setBounds(new Rectangle(7, 55, 47, 31));
jLabel4.setFont(new java.awt.Font("Dialog", 0, 12));
jLabel4.setText("年级");
jLabel4.setBounds(new Rectangle(7, 97, 42, 34));
jLabel5.setFont(new java.awt.Font("Dialog", 0, 12));
jLabel5.setText("班级");
jLabel5.setBounds(new Rectangle(5, 131, 38, 45));
jLabel6.setFont(new java.awt.Font("Dialog", 0, 12));
jLabel6.setText("年度");
jLabel6.setBounds(new Rectangle(6, 178, 43, 24));
jLabel7.setFont(new java.awt.Font("Dialog", 0, 12));
jLabel7.setText("应缴费用");
jLabel7.setBounds(new Rectangle(4, 221, 56, 25));
jTextField2.setFont(new java.awt.Font("Dialog", 0, 12)); jTextField2.setText("");
jTextField2.setBounds(new Rectangle(82, 55, 107, 25));
jTextField3.setFont(new java.awt.Font("Dialog", 0, 12)); jTextField3.setText("");
jTextField3.setBounds(new Rectangle(81, 99, 107, 24));
jTextField4.setFont(new java.awt.Font("Dialog", 0, 12)); jTextField4.setText("");
jTextField4.setBounds(new Rectangle(81, 140, 110, 25));
jTextField5.setFont(new java.awt.Font("Dialog", 0, 12)); jTextField5.setText("");
jTextField5.setBounds(new Rectangle(82, 177, 109, 25));
jTextField6.setFont(new java.awt.Font("Dialog", 0, 12)); jTextField6.setBounds(new Rectangle(81, 220, 109, 25));
jLabel8.setBackground(UIManager.getColor("text"));
jLabel8.setFont(new java.awt.Font("Dialog", 0, 14));
jLabel8.setText("请输入学号");
jLabel8.setBounds(new Rectangle(238, 68, 80, 34));
jButton1.setBackground(UIManager.getColor("window")); jButton1.setBounds(new Rectangle(382, 101, 64, 27));
jButton1.setFont(new java.awt.Font("Dialog", 0, 12));
jButton1.setText("确定");
jButton1.addActionListener(new Frame2_jButton1_actionAdapter(this));
jTextField7.setBounds(new Rectangle(242, 101, 117, 28));
jButton2.setBackground(UIManager.getColor("window"));
jButton2.setBounds(new Rectangle(22, 398, 72, 29));
jButton2.setFont(new java.awt.Font("Dialog", 0, 12));
jButton2.setText("修改");
jButton2.addActionListener(new Frame2_jButton2_actionAdapter(this));
jButton3.setBackground(UIManager.getColor("window"));
jButton3.setBounds(new Rectangle(112, 398, 72, 28));
jButton3.setFont(new java.awt.Font("Dialog", 0, 12));
jButton3.setText("删除");
jButton3.addActionListener(new Frame2_jButton3_actionAdapter(this));
jPanel1.setBackground(new Color(157, 185, 235));
jPanel1.setBounds(new Rectangle(218, 135, 389, 274));
jPanel1.setLayout(xYLayout1);
database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor(
"jdbc:odbc:account", "", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
dBDisposeMonitor1.setDataAwareComponentContainer(this);
queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
database1, "SELECT * FROM student", null, true, Load.ALL));
jdbStatusLabel1.setBackground(new Color(157, 185, 235));
jdbStatusLabel1.setText("jdbStatusLabel1");
jdbStatusLabel1.setDataSet(queryDataSet1);
tableScrollPane1.getViewport().setBackground(SystemColor.text);
tableScrollPane1.setEnabled(false); tableScrollPane1.setAutoscrolls(false);
jButton4.setBackground(UIManager.getColor("window"));
jButton4.setBounds(new Rectangle(486, 412, 64, 22));
jButton4.setFont(new java.awt.Font("Dialog", 0, 12));
jButton4.setText("返回");
jButton4.addActionListener(new Frame2_jButton4_actionAdapter(this));
jdbTable1.setFont(new java.awt.Font("Dialog", 0, 12)); jdbTable1.setVisible(false);
jdbTable1.setAutoResizeMode(JTable.AUTO_RESIZE_NEXT_COLUMN);
jdbTable1.setDataSet(queryDataSet1);
jdbTable1.setEditable(false);
contentPane.setBackground(UIManager.getColor("InternalFrame.inactiveTitleGradient"));
panel1.add(jTextField2, null);
panel1.add(jTextField3, null);
panel1.add(jTextField4, null);
panel1.add(jTextField5, null);
panel1.add(jTextField6, null);
panel1.add(jLabel6, null);
panel1.add(jLabel7, null);
panel1.add(jLabel5, null);
panel1.add(jLabel2, null);
panel1.add(jLabel3, null);
panel1.add(jTextField1, null);
panel1.add(jLabel4, null);
contentPane.add(jLabel1, null);
contentPane.add(jButton4, null);
contentPane.add(jButton2, null);
contentPane.add(jLabel8, null);
contentPane.add(jTextField7, null);
contentPane.add(jButton1, null);
contentPane.add(jPanel1, null);
jPanel1.add(jdbStatusLabel1, new XYConstraints(22, 249, 133, 22));
jPanel1.add(tableScrollPane1, new XYConstraints(23, 9, 358, 239));
tableScrollPane1.getViewport().add(jdbTable1, null);
contentPane.add(jButton3, null);
contentPane.add(panel1, null);
}
//Overridden so we can exit when window is closed
protected void processWindowEvent(WindowEvent e) {
super.processWindowEvent(e);
if (e.getID() == WindowEvent.WINDOW_CLOSING) {
System.exit(0);
}
}
void jButton1_actionPerformed(ActionEvent e) {
queryDataSet1.refresh();
try {
String url = "jdbc:odbc:account";
String user = "";
String password = "";
String sql;
sql = "select * from student where StudentNo='" + jTextField7.getText() +
"'";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(url, user, password);
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stmt.executeQuery(sql);
if (rs.next()) {
flag = true;
if (flag == true) {
rs.beforeFirst();
while (rs.next()) {
jTextField1.setText(rs.getString("StudentNo"));
jTextField2.setText(rs.getString("StudentName"));
jTextField3.setText(rs.getString("Grade"));
jTextField4.setText(rs.getString("Class"));
jTextField5.setText(rs.getString("Year"));
jTextField6.setText(rs.getString("Yjf"));
jdbTable1.show();
}
}
}
else {
jOptionPane1.showMessageDialog(null, "没有此学生");
jTextField1.setText("");
jTextField2.setText("");
jTextField3.setText("");
jTextField4.setText("");
jTextField5.setText("");
jTextField6.setText("");
}
}
catch (SQLException sqle) {
sqle.printStackTrace();
}
catch (Exception sq) {
System.out.println(2 + sq.toString());
}
}
void jButton2_actionPerformed(ActionEvent e) {
try {
String url = "jdbc:odbc:account";
String user = "";
String password = "";
String sql_2;
sql_2 = "update student set StudentName='" + jTextField2.getText() +
"',Grade='" + jTextField3.getText() + "',Class='" +
jTextField4.getText() +
"',Year='" + jTextField5.getText() + "',Yjf='" + jTextField6.getText() +
"' where StudentNo='" + jTextField1.getText() + "'";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(url, user, password);
Statement stmt = con.createStatement();
stmt.executeUpdate(sql_2);
queryDataSet1.refresh();
jdbTable1.show();
}
catch (SQLException sqle) {
sqle.printStackTrace();
}
catch (Exception sq) {
System.out.println(2 + sq.toString());
}
}
void jButton3_actionPerformed(ActionEvent e) {
try {
String url = "jdbc:odbc:account";
String user = "";
String password = "";
String sql_1;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(url, user, password);
Statement stmt = con.createStatement();
sql_1="delete * from student where StudentNo='"+jTextField1.getText()+"'";
stmt.executeUpdate(sql_1);
queryDataSet1.refresh();
jdbTable1.show();
}
catch (SQLException sqle) {
sqle.printStackTrace();
}
catch (Exception sq) {
System.out.println(2 + sq.toString());
}
}
void jButton4_actionPerformed(ActionEvent e) {
new Application4();
this.hide();
}
}
class Frame2_jButton1_actionAdapter implements java.awt.event.ActionListener {
Frame2 adaptee;
Frame2_jButton1_actionAdapter(Frame2 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton1_actionPerformed(e);
}
}
class Frame2_jButton2_actionAdapter implements java.awt.event.ActionListener {
Frame2 adaptee;
Frame2_jButton2_actionAdapter(Frame2 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton2_actionPerformed(e);
}
}
class Frame2_jButton3_actionAdapter implements java.awt.event.ActionListener {
Frame2 adaptee;
Frame2_jButton3_actionAdapter(Frame2 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton3_actionPerformed(e);
}
}
class Frame2_jButton4_actionAdapter implements java.awt.event.ActionListener {
Frame2 adaptee;
Frame2_jButton4_actionAdapter(Frame2 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton4_actionPerformed(e);
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -