62,621
社区成员
发帖
与我相关
我的任务
分享

import java.awt.BorderLayout;
import java.awt.CardLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.Box;
import javax.swing.JButton;
import javax.swing.JDialog;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.SwingUtilities;
public class InsertRecord extends JDialog implements ActionListener { // 负责插入记录的类
private JPanel p1, p2, p3;
private Box baseBox, baseBox1, baseBox2;
private JLabel x, y, z;
private Object[] name = { "学号", "姓名", "性别", "年龄" };
private Object[] Name = { "课程号", "课程名", "学分" };
private Object[] NAme = { "学号", "课程名", "成绩" };
private Object[][] a = new Object[1][4];
private Object[][] b = new Object[1][3];
private Object[][] c = new Object[1][3];
private JTable table1, table2, table3;
private JButton r, m, t, button1, button2, button3;
private JPanel buttonPanel;
private JPanel tablePanel;
private CardLayout layout = new CardLayout();
/*
* Connection con; Statement sql; ResultSet rs;
*/
String num;
InsertRecord(String s) {
setTitle(s);
button1 = new JButton("学生信息插入");
button2 = new JButton("课程信息插入");
button3 = new JButton("选课信息插入");
buttonPanel = new JPanel();
p1 = new JPanel();
p2 = new JPanel();
p3 = new JPanel();
buttonPanel.add(button1);
buttonPanel.add(button2);
buttonPanel.add(button3);
add(buttonPanel, BorderLayout.NORTH);
// add(p,BorderLayout.CENTER);
x = new JLabel("输入新记录1:");
y = new JLabel("输入新记录2:");
z = new JLabel("输入新记录3:");
table1 = new JTable(a, name);
table2 = new JTable(b, Name);
table3 = new JTable(c, NAme);
r = new JButton("插入新记录1");
m = new JButton("插入新记录2");
t = new JButton("插入新记录3");
p1.setLayout(null);
baseBox = Box.createHorizontalBox();
baseBox.add(x);
baseBox.add(new JScrollPane(table1));
baseBox.add(r);
baseBox.setBounds(35, 40, 600, 38);
p1.add(baseBox);
p2.setLayout(null);
baseBox1 = Box.createHorizontalBox();
baseBox1.add(y);
baseBox1.add(new JScrollPane(table2));
baseBox1.add(m);
baseBox1.setBounds(35, 40, 600, 38);
p2.add(baseBox1);
p3.setLayout(null);
baseBox2 = Box.createHorizontalBox();
baseBox2.add(z);
baseBox2.add(new JScrollPane(table3));
baseBox2.add(t);
baseBox2.setBounds(35, 40, 600, 38);
p3.add(baseBox2);
// p.add(baseBox);
button1.addActionListener(this);
button2.addActionListener(this);
button3.addActionListener(this);
r.addActionListener(this);
tablePanel = new JPanel(layout);
tablePanel.add(p1, "students");
tablePanel.add(p2, "courses");
tablePanel.add(p3, "elective");
add(tablePanel, BorderLayout.CENTER);
setBounds(120, 160, 700, 200);
// validate();
}
public void actionPerformed(ActionEvent e) {
if (e.getSource() == button1) {
layout.show(tablePanel, "students");
}
if (e.getSource() == button2) {
layout.show(tablePanel, "courses");
}
if (e.getSource() == button3) {
layout.show(tablePanel, "elective");
}
/*
* if (e.getSource() == r) { try { con = DriverManager.getConnection("jdbc:odbc:jec", Dljm.a, Dljm.b); sql =
* con.createStatement(); table1.getCellEditor(0, 3).stopCellEditing();// int k =
* sql.executeUpdate("INSERT INTO s VALUES('" + a[0][0] + "','" + a[0][1] + "','" + a[0][2] + "','" + a[0][3] +
* "')"); if (k == 1) JOptionPane.showMessageDialog(this, "插入记录成功", "成功", JOptionPane.PLAIN_MESSAGE); table1 =
* new JTable(a, name); con.close(); } catch (SQLException ee) { JOptionPane.showMessageDialog(this, "插入记录失败" +
* ee, "失败", JOptionPane.ERROR_MESSAGE); } }
*/
}
public static void main(final String[] args) {
SwingUtilities.invokeLater(new Runnable() {
public void run() {
JDialog dialog = new InsertRecord("Hello");
dialog.setDefaultCloseOperation(DISPOSE_ON_CLOSE);
dialog.setVisible(true);
}
});
}
}