📄 frame3.java
字号:
package 学生简易注册管理系统;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
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 Frame3 extends JFrame {
JPanel contentPane;
JPanel jPanel1 = new JPanel();
JTextField jTextField1 = new JTextField();
JTextField jTextField2 = new JTextField();
JLabel jLabel1 = new JLabel();
JLabel jLabel2 = new JLabel();
JLabel jLabel3 = new JLabel();
JTextField jTextField3 = new JTextField();
JLabel jLabel4 = new JLabel();
JLabel jLabel5 = new JLabel();
JLabel jLabel6 = new JLabel();
JTextField jTextField4 = new JTextField();
JTextField jTextField5 = new JTextField();
JTextField jTextField6 = new JTextField();
JLabel jLabel7 = new JLabel();
JPanel jPanel2 = new JPanel();
TableScrollPane tableScrollPane1 = new TableScrollPane();
Database database1 = new Database();
QueryDataSet queryDataSet1 = new QueryDataSet();
DBDisposeMonitor dBDisposeMonitor1 = new DBDisposeMonitor();
JdbTable jdbTable1 = new JdbTable();
JButton jButton1 = new JButton();
JButton jButton2 = new JButton();
JOptionPane jOptionPane1=new JOptionPane();
//Construct the frame
public Frame3() {
enableEvents(AWTEvent.WINDOW_EVENT_MASK);
try {
jbInit();
}
catch (Exception e) {
e.printStackTrace();
}
}
//Component initialization
private void jbInit() throws Exception {
contentPane = (JPanel)this.getContentPane();
contentPane.setLayout(null);
this.setSize(new Dimension(607, 479));
this.setTitle("Frame Title");
jPanel1.setBackground(new Color(122, 150, 223)); jPanel1.setFont(new java.awt.Font("Dialog", 0, 12));
jPanel1.setToolTipText("学生信息");
jPanel1.setBounds(new Rectangle(9, 72, 186, 324));
jPanel1.setLayout(null);
jTextField1.setFont(new java.awt.Font("Dialog", 0, 12)); jTextField1.setText("");
jTextField1.setBounds(new Rectangle(95, 45, 77, 24));
jTextField2.setFont(new java.awt.Font("Dialog", 0, 12)); jTextField2.setText("");
jTextField2.setBounds(new Rectangle(95, 92, 76, 25));
jLabel1.setFont(new java.awt.Font("Dialog", 0, 12));
jLabel1.setText("学生编号");
jLabel1.setBounds(new Rectangle(10, 47, 56, 23));
jLabel2.setFont(new java.awt.Font("Dialog", 0, 12));
jLabel2.setText("姓名");
jLabel2.setBounds(new Rectangle(14, 93, 59, 24));
jLabel3.setFont(new java.awt.Font("Dialog", 0, 12));
jLabel3.setText("年级");
jLabel3.setBounds(new Rectangle(17, 142, 46, 17));
jTextField3.setFont(new java.awt.Font("Dialog", 0, 12)); jTextField3.setText("");
jTextField3.setBounds(new Rectangle(96, 138, 77, 25));
jLabel4.setFont(new java.awt.Font("Dialog", 0, 12));
jLabel4.setText("班级");
jLabel4.setBounds(new Rectangle(14, 187, 36, 24));
jLabel5.setFont(new java.awt.Font("Dialog", 0, 12));
jLabel5.setText("年度");
jLabel5.setBounds(new Rectangle(14, 233, 37, 30));
jLabel6.setFont(new java.awt.Font("Dialog", 0, 12));
jLabel6.setText("应缴费用");
jLabel6.setBounds(new Rectangle(11, 282, 50, 24));
jTextField4.setFont(new java.awt.Font("Dialog", 0, 12)); jTextField4.setText("");
jTextField4.setBounds(new Rectangle(97, 186, 77, 28));
jTextField4.addActionListener(new Frame3_jTextField4_actionAdapter(this));
jTextField5.setFont(new java.awt.Font("Dialog", 0, 12)); jTextField5.setBounds(new Rectangle(97, 237, 77, 25));
jTextField6.setFont(new java.awt.Font("Dialog", 0, 12)); jTextField6.setBounds(new Rectangle(98, 283, 78, 25));
jLabel7.setFont(new java.awt.Font("Monospaced", 2, 30)); jLabel7.setForeground(new Color(80, 70, 170));
jLabel7.setText("添加学生记录");
jLabel7.setBounds(new Rectangle(194, 14, 211, 53));
jPanel2.setBackground(new Color(157, 185, 235)); jPanel2.setBounds(new Rectangle(218, 100, 369, 286));
jPanel2.setLayout(null);
tableScrollPane1.getViewport().setBackground(SystemColor.text); tableScrollPane1.setBounds(new Rectangle(12, 6, 346, 274));
database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor(
"jdbc:odbc:account", "", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
database1.setTransactionIsolation(java.sql.Connection.
TRANSACTION_READ_COMMITTED);
database1.setUseCaseSensitiveId(true);
database1.setDatabaseName("");
queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
database1, "SELECT * FROM student", null, true, Load.ALL));
dBDisposeMonitor1.setDataAwareComponentContainer(this);
jdbTable1.setEnabled(true); jdbTable1.setFont(new java.awt.Font("Dialog", 0, 12));
jdbTable1.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
jdbTable1.setDataSet(queryDataSet1);
jdbTable1.setEditable(false);
jButton1.setBackground(UIManager.getColor("window")); jButton1.setBounds(new Rectangle(136, 404, 80, 27));
jButton1.setFont(new java.awt.Font("Dialog", 0, 12));
jButton1.setText("添加");
jButton1.addActionListener(new Frame3_jButton1_actionAdapter(this));
jButton2.setBackground(UIManager.getColor("window")); jButton2.setBounds(new Rectangle(454, 404, 71, 28));
jButton2.setFont(new java.awt.Font("Dialog", 0, 12));
jButton2.setText("返回");
jButton2.addActionListener(new Frame3_jButton2_actionAdapter(this));
contentPane.setBackground(new Color(157, 185, 235));
jPanel1.add(jTextField2, null);
jPanel1.add(jTextField3, null);
jPanel1.add(jTextField4, null);
jPanel1.add(jTextField5, null);
jPanel1.add(jLabel6, null);
jPanel1.add(jLabel5, null);
jPanel1.add(jLabel4, null);
jPanel1.add(jTextField1, null);
jPanel1.add(jTextField6, null);
jPanel1.add(jLabel2, null);
jPanel1.add(jLabel1, null);
jPanel1.add(jLabel3, null); contentPane.add(jButton2, null);
contentPane.add(jPanel2, null);
jPanel2.add(tableScrollPane1, null);
tableScrollPane1.getViewport().add(jdbTable1, null);
contentPane.add(jLabel7, null);
contentPane.add(jButton1, null); contentPane.add(jPanel1, 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) {
try {
String url = "jdbc:odbc:account";
String user = "";
String password = "";
String sql_1;
String sql_2;
sql_2="select StudentNo from student";
sql_1="insert into student"+
"(StudentNo,StudentName,Grade,Class,Year,Yjf)"+
"values('"+jTextField1.getText()+"',"+"'"+jTextField2.getText()+"',"+
"'"+jTextField3.getText()+"',"+"'"+jTextField4.getText()+"',"+
"'"+jTextField5.getText()+"',"+"'"+jTextField6.getText()+"'"+")";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(url, user, password);
Statement stmt = con.createStatement();
ResultSet rs=stmt.executeQuery(sql_2);
stmt.executeUpdate(sql_1);
queryDataSet1.refresh();
}
catch (SQLException sqle) {
sqle.printStackTrace();
}
catch (Exception sqle) {
System.out.println(2 + sqle.toString());
}
}
void jTextField4_actionPerformed(ActionEvent e) {
}
void jButton2_actionPerformed(ActionEvent e) {
new Application4();
this.hide();
}
}
class Frame3_jButton1_actionAdapter implements java.awt.event.ActionListener {
Frame3 adaptee;
Frame3_jButton1_actionAdapter(Frame3 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton1_actionPerformed(e);
}
}
class Frame3_jTextField4_actionAdapter implements java.awt.event.ActionListener {
Frame3 adaptee;
Frame3_jTextField4_actionAdapter(Frame3 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jTextField4_actionPerformed(e);
}
}
class Frame3_jButton2_actionAdapter implements java.awt.event.ActionListener {
Frame3 adaptee;
Frame3_jButton2_actionAdapter(Frame3 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton2_actionPerformed(e);
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -