📄 frame4.java
字号:
package 桀骜学管理系统;
import java.awt.Dimension;
import javax.swing.*;
import com.borland.jbcl.layout.*;
import java.awt.*;
import com.borland.dx.sql.dataset.Database;
import com.borland.dx.sql.dataset.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
import javax.swing.JTable;
import javax.swing.table.*;
/**
* <p>Title: </p>
*
* <p>Description: </p>
*
* <p>Copyright: Copyright (c) 2006</p>
*
* <p>Company: </p>
*
* @author not attributable
* @version 1.0
*/
public class Frame4 extends JFrame {
private Connection connect;
String url;
private DefaultTableModel defaultTableModel1=new DefaultTableModel();
private DefaultTableModel defaultTableModel2=new DefaultTableModel();
private DefaultTableModel defaultTableModel3=new DefaultTableModel();
JPanel contentPane;
ImageIcon image1 = new ImageIcon(桀骜学管理系统.Frame4.class.getResource(
"openFile.png"));
ImageIcon image2 = new ImageIcon(桀骜学管理系统.Frame4.class.getResource(
"closeFile.png"));
ImageIcon image3 = new ImageIcon(桀骜学管理系统.Frame4.class.getResource(
"help.png"));
XYLayout xYLayout1 = new XYLayout();
JPanel jPanel1 = new JPanel();
JPanel jPanel2 = new JPanel();
JPanel jPanel3 = new JPanel();
XYLayout xYLayout2 = new XYLayout();
JLabel jLabel1 = new JLabel();
JLabel jLabel2 = new JLabel();
JTextField jTextField1 = new JTextField();
JLabel jLabel3 = new JLabel();
JTextField jTextField2 = new JTextField();
JLabel jLabel4 = new JLabel();
JTextField jTextField3 = new JTextField();
JButton jButton1 = new JButton();
Database database1 = new Database();
QueryDataSet queryDataSet1 = new QueryDataSet();
JScrollPane jScrollPane1 = new JScrollPane();
JLabel jLabel5 = new JLabel();
JTable jTable1 = new JTable();
JLabel jLabel6 = new JLabel();
XYLayout xYLayout3 = new XYLayout();
JLabel jLabel7 = new JLabel();
JLabel jLabel8 = new JLabel();
JLabel jLabel9 = new JLabel();
JTextField jTextField4 = new JTextField();
JTextField jTextField5 = new JTextField();
JTextField jTextField6 = new JTextField();
JButton jButton3 = new JButton();
JButton jButton4 = new JButton();
JScrollPane jScrollPane2 = new JScrollPane();
JLabel jLabel10 = new JLabel();
XYLayout xYLayout4 = new XYLayout();
JLabel jLabel11 = new JLabel();
JTextField jTextField7 = new JTextField();
JLabel jLabel12 = new JLabel();
JTextField jTextField8 = new JTextField();
JLabel jLabel13 = new JLabel();
JTextField jTextField9 = new JTextField();
JButton jButton5 = new JButton();
JButton jButton6 = new JButton();
JScrollPane jScrollPane3 = new JScrollPane();
JTable jTable2 = new JTable();
JLabel jLabel14 = new JLabel();
JLabel jLabel15 = new JLabel();
JButton jButton7 = new JButton();
JTable jTable3 = new JTable();
public Frame4() {
try {
//setDefaultCloseOperation(EXIT_ON_CLOSE);
jbInit();
} catch (Exception exception) {
exception.printStackTrace();
}
}
/**
* Component initialization.
*
* @throws java.lang.Exception
*/
private void jbInit() throws Exception {
contentPane = (JPanel) getContentPane();
contentPane.setLayout(xYLayout1);
setSize(new Dimension(800, 600));
setTitle("课程变动");
jPanel1.setLayout(xYLayout2);
jLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
jLabel1.setText("教师课程信息更新");
jLabel2.setText("课号:");
jLabel3.setText("教研室号:");
jLabel4.setText("教师号:");
jButton1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 11));
jButton1.setText("插入");
jButton1.addActionListener(new Frame4_jButton1_actionAdapter(this));
database1.setConnection(new ConnectionDescriptor("jdbc:odbc:task",
"root", "abc", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
try
{
url="jdbc:odbc:task";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
connect=DriverManager.getConnection(url,"root","abc");
}
catch (SQLException sqlex)
{
System.err.println("unable to connect");
sqlex.printStackTrace();
}
jLabel5.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
jLabel5.setText("教师插入详细信息");
jLabel6.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
jLabel6.setText("学生课程信息更新");
jPanel2.setLayout(xYLayout3);
jLabel7.setText("课号:");
jLabel8.setText("学号:");
jLabel9.setText("成绩:");
jButton3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 11));
jButton3.setText("插入");
jButton3.addActionListener(new Frame4_jButton3_actionAdapter(this));
jButton4.setFont(new java.awt.Font("Dialog", Font.PLAIN, 11));
jButton4.setText("删除");
jButton4.addActionListener(new Frame4_jButton4_actionAdapter(this));
jLabel10.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
jLabel10.setText("课程信息更新");
jPanel3.setLayout(xYLayout4);
jLabel11.setText("课 号:");
jLabel12.setText("课程名:");
jLabel13.setText("学 时:");
jTextField9.setText("");
jButton5.setFont(new java.awt.Font("Dialog", Font.PLAIN, 11));
jButton5.setText("插入");
jButton5.addActionListener(new Frame4_jButton5_actionAdapter(this));
jButton6.setFont(new java.awt.Font("Dialog", Font.PLAIN, 11));
jButton6.setText("删除");
jButton6.addActionListener(new Frame4_jButton6_actionAdapter(this));
jLabel14.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
jLabel14.setText("学生课程插入详细信息");
jLabel15.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
jLabel15.setText("课程变动");
jButton7.setText("删除");
jButton7.addActionListener(new Frame4_jButton7_actionAdapter(this));
jPanel3.add(jLabel11, new XYConstraints(18, 66, 61, 25));
jPanel3.add(jTextField7, new XYConstraints(84, 66, 116, 27));
jPanel3.add(jLabel12, new XYConstraints(18, 99, 61, 25));
jPanel3.add(jLabel13, new XYConstraints(18, 139, 61, 25));
jPanel3.add(jTextField8, new XYConstraints(84, 97, 116, 27));
jPanel3.add(jTextField9, new XYConstraints(84, 134, 116, 27));
jScrollPane3.getViewport().add(jTable2);
contentPane.add(jPanel1, new XYConstraints(2, 3, 265, 594));
jPanel1.add(jLabel1, new XYConstraints(64, 22, 155, 37));
contentPane.add(jPanel2, new XYConstraints(269, 3, 265, 593));
jPanel2.add(jLabel6, new XYConstraints(71, 20, 160, 33));
jPanel2.add(jLabel7, new XYConstraints(31, 69, 55, 24));
jPanel1.add(jLabel4, new XYConstraints(24, 153, 62, 24));
jPanel1.add(jLabel2, new XYConstraints(24, 77, 62, 24));
jPanel1.add(jLabel3, new XYConstraints(23, 115, 62, 24));
jPanel1.add(jTextField1, new XYConstraints(91, 71, 107, 30));
jPanel1.add(jTextField2, new XYConstraints(91, 110, 107, 30));
jPanel1.add(jTextField3, new XYConstraints(91, 147, 107, 30));
jPanel1.add(jLabel5, new XYConstraints(85, 289, 121, 39));
jPanel2.add(jLabel8, new XYConstraints(31, 102, 55, 24));
jPanel2.add(jLabel9, new XYConstraints(31, 139, 55, 24));
jPanel2.add(jTextField4, new XYConstraints(91, 65, 136, 28));
jPanel2.add(jTextField5, new XYConstraints(91, 98, 136, 28));
jPanel2.add(jTextField6, new XYConstraints(91, 135, 136, 28));
jPanel2.add(jLabel14, new XYConstraints(55, 288, 152, 40));
contentPane.add(jPanel3, new XYConstraints(536, 5, 261, 594));
jScrollPane1.getViewport().add(jTable1);
jPanel1.add(jScrollPane1, new XYConstraints(26, 364, 223, 151));
jPanel3.add(jScrollPane3, new XYConstraints(13, 362, 227, 153));
jPanel3.add(jLabel15, new XYConstraints(81, 288, 67, 38));
jPanel3.add(jLabel10, new XYConstraints(73, 16, 117, 31));
jPanel2.add(jScrollPane2, new XYConstraints(29, 366, 218, 150));
jScrollPane2.getViewport().add(jTable3);
jPanel1.add(jButton1, new XYConstraints(36, 225, 66, 27));
jPanel1.add(jButton7, new XYConstraints(152, 225, 66, 27));
jPanel2.add(jButton4, new XYConstraints(163, 225, 68, 26));
jPanel2.add(jButton3, new XYConstraints(58, 225, 68, 26));
jPanel3.add(jButton5, new XYConstraints(20, 222, 66, 28));
jPanel3.add(jButton6, new XYConstraints(127, 222, 66, 28));
}
void message(String t)
{
JOptionPane.showMessageDialog(null,t);
}
/*void displayTable(ResultSet rs1,String query1 )
{
statement=connect.createStatement();
rs1=statement.executeQuery(query1);
ResultSetMetaData rsmd1=rs1.getMetaData();
DefaultTableModel defaultTableModel1=new DefaultTableModel();
defaultTableModel1.setColumnCount(0);
defaultTableModel1.setRowCount(0);
for(int i=1;i<=rsmd1.getColumnCount();i++)
{
defaultTableModel1.addColumn(rsmd1.getColumnName(i));
}
int i=0;
while(rs1.next())
{
defaultTableModel1.setNumRows(i+1);
for (int j=0;j<rsmd1.getColumnCount();j++)
{
defaultTableModel1.setValueAt(rs1.getString(j+1),i,j);
}
i++;
}
rs1.close();
//jTable1.setModel((TableModel)defaultTableModel1);
}*/
public void jButton1_actionPerformed(ActionEvent e) {
try{
boolean test = true;
String kong="";
Statement statement = connect.createStatement(ResultSet.
TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String query = "insert into tclass values ('" + jTextField3.getText() +
"', '" +
jTextField2.getText() + "', '" +
jTextField1.getText() + "'" +
")";
String query1 =
" select tname,class,Troom from teacher,sclass where ssn='" +
jTextField3.getText() +
"' and Nclass='" + jTextField1.getText() + "'";
String query2 = "select ssn,Troom from tclass where Nclass='" +
jTextField1.getText() + "'";
ResultSet rs1 = statement.executeQuery(query2);
if (rs1.next()) {
while (rs1.next()) {
String TeacherNumber = rs1.getString("ssn");
if (TeacherNumber.equalsIgnoreCase(jTextField3.getText())) {
String fail = "插入信息已有，请核实后再进行操作";
message(fail);
rs1.close();
statement.close();
test = false;
break;
}
}
}
if(kong.equalsIgnoreCase(jTextField1.getText()) )
{
String empty="不能为空";
message(empty);
test=false;
}
if (test)
{
rs1 = statement.executeQuery(query1);
ResultSetMetaData rsmd1 = rs1.getMetaData();
defaultTableModel1.setColumnCount(0);
defaultTableModel1.setRowCount(0);
for (int i = 1; i <= rsmd1.getColumnCount(); i++) {
defaultTableModel1.addColumn(rsmd1.getColumnName(i));
}
int i = 0;
while (rs1.next()) {
defaultTableModel1.setNumRows(i + 1);
for (int j = 0; j < rsmd1.getColumnCount(); j++) {
defaultTableModel1.setValueAt(rs1.getString(j + 1), i,
j);
}
i++;
}
rs1.close();
jTable1.setModel((TableModel) defaultTableModel1);
int result = statement.executeUpdate(query);
if (result == 1) {
String success = "插入成功";
message(success);
statement.close();
}
}
}
catch(Exception sqlex)
{
System.out.println("unable run ***");
sqlex.printStackTrace();
}
}
public void jButton7_actionPerformed(ActionEvent e) {
try
{
Statement statement = connect.createStatement(ResultSet.
TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String query="delete from tclass where Nclass='"+jTextField1.getText()+"' and Troom='"+
jTextField2.getText()+"' and ssn='"+jTextField3.getText()+"'";
int result = statement.executeUpdate(query);
if(result==1)
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -