public chengjixinxi2() { try {
Class.forName( \ ); cn=
super();
setTitle(\); getContentPane().setLayout(null); setBounds(100, 100, 500, 375);
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); String su,sp; su=\; sp=\;
DriverManager.getConnection( \eName=学生成绩管理系统\ , su, sp);
} catch (ClassNotFoundException e1) { }
final JLabel label = new JLabel(); // TODO Auto-generated catch block e1.printStackTrace();
// TODO Auto-generated catch block e.printStackTrace();
} catch (SQLException e) {
label.setText(\学号\);
label.setBounds(82, 38, 66, 18); getContentPane().add(label);
final JLabel label_1 = new JLabel(); label_1.setText(\英语成绩\);
label_1.setBounds(82, 81, 66, 18); getContentPane().add(label_1); final JLabel label_2 = new JLabel(); label_2.setText(\成绩\);
label_2.setBounds(82, 125, 66, 18); getContentPane().add(label_2); final JLabel label_3 = new JLabel(); label_3.setText(\成绩\);
label_3.setBounds(82, 165, 66, 18); getContentPane().add(label_3); final JLabel label_4 = new JLabel(); label_4.setText(\成绩\);
label_4.setBounds(82, 204, 66, 18); getContentPane().add(label_4); t1 = new JTextField();
t1.setBounds(180, 36, 87, 22); getContentPane().add(t1); t2 = new JTextField();
t2.setBounds(180, 79, 87, 22); getContentPane().add(t2); t3 = new JTextField();
t3.setBounds(180, 123, 87, 22); getContentPane().add(t3); t4 = new JTextField();
t4.setBounds(180, 163, 87, 22); getContentPane().add(t4); t5 = new JTextField();
t5.setBounds(180, 202, 87, 22); getContentPane().add(t5);
final JButton button_1 = new JButton();
button_1.addActionListener(new ActionListener() {
public void actionPerformed(final ActionEvent e) {
String sql=\成绩信息
values('\+t1.getText()+\+t2.getText()+\+t3.getText()+\+t4.getText()+\+t5.getText()+\;
final JButton button = new JButton();
button.addActionListener(new ActionListener() {
public void actionPerformed(final ActionEvent e) { } });
chengjixinxi c=new chengjixinxi(); c.setVisible(true); dispose();
}
try { }
sa=cn.createStatement();
s=sa.executeUpdate(sql); if(s==1) { } else {
JOptionPane.showMessageDialog(null, \修改失败\); }
// TODO Auto-generated catch block e1.printStackTrace();
JOptionPane.showMessageDialog(null, \修改成功\);
} catch (SQLException e1) {
});
button_1.setText(\修改\);
button_1.setBounds(105, 258, 106, 28); getContentPane().add(button_1);
public xueqixinxi() { try {
Class.forName( \ ); cn=
super();
setTitle(\); getContentPane().setLayout(null); setBounds(100, 100, 500, 375);
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
String su,sp; su=\; sp=\;
DriverManager.getConnection( \eName=学生成绩管理系统\ , su, sp);
} catch (ClassNotFoundException e1) { }
// TODO Auto-generated catch block e1.printStackTrace();
// TODO Auto-generated catch block e.printStackTrace();
} catch (SQLException e) {
final JButton button = new JButton();
button.addActionListener(new ActionListener() {
public void actionPerformed(final ActionEvent e) {
t1 = new JTextField();
t1.setBounds(95, 28, 87, 22); getContentPane().add(t1);
final JLabel label = new JLabel(); label.setText(\学号\);
label.setBounds(23, 30, 66, 18); getContentPane().add(label);
String sql=\学期信息 where 学号='\+t1.getText()+\;
try {
sa=cn.createStatement(); re=sa.executeQuery(sql); if(re.next()) {
oo.setText(\学号:\+re.getString(1)+\学期:\+re.getString(2));
final JButton button_1 = new JButton();
button_1.addActionListener(new ActionListener() {
}
}
} else {
JOptionPane.showMessageDialog(null, \失败\); }
// TODO Auto-generated catch block e1.printStackTrace();
} catch (SQLException e1) {
});
button.setText(\查询\);
button.setBounds(188, 25, 66, 28); getContentPane().add(button);