📄 studentinfoframe.java
字号:
}
else
JOptionPane.showMessageDialog(null, "删除信息失败！");
}else
JOptionPane.showMessageDialog(null, "成绩删除信息失败！");
}
});
delete.setText("删除");
delete.setBounds(214, 314, 66, 48);
panel.add(delete);
save = new JButton();
save.setFont(new Font("", Font.PLAIN, 5));
save.setToolTipText("保存");
save.setIcon(SwingResourceManager.getIcon(StudentInfoFrame.class, "/images/5.png"));
save.addActionListener(new ActionListener() {
public void actionPerformed(final ActionEvent e) {
if(exeType.equals("add"))
{
String sql="select * from studentInfo where ID='"+id.getText()+"'";
rs=db.getResult(sql);
rs1=db.getResult(sql);
try {
if(rs.next())
{
JOptionPane.showMessageDialog(null,"学号不能重复！");
setNull();
}
else
{
sql="insert into studentInfo(ID,Name,Sex,Ethnic,Class,Birth,Home) values (";
sql=sql+"'"+id.getText()+"',";
sql=sql+"'"+name.getText()+"',";
sql=sql+"'"+sex.getText()+"',";
sql=sql+"'"+ethnic.getText()+"',";
sql=sql+"'"+cName.getText()+"',";
sql=sql+"'"+birth.getText()+"',";
sql=sql+"'"+home.getText()+"'";
sql=sql+")";
if( db.executeSql(sql) )
{
setTextAbled(false);
JOptionPane.showMessageDialog(null,"成功添加信息！");
setButton(true,true,true,false,false);
}
else
JOptionPane.showMessageDialog(null," 添加信息失败！");
}
} catch (HeadlessException e1) {
// TODO Auto-generated catch block
System.out.println("HeadlessException");
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
}
else if(exeType.equals("modify"))
{
String sql="update studentInfo set Name='"+name.getText()+"',";
sql=sql+"Sex='"+sex.getText()+"',";
sql=sql+"Ethnic='"+ethnic.getText()+"',";
sql=sql+"Class='"+cName.getText()+"',";
sql=sql+"Birth='"+birth.getText()+"',";
sql=sql+"Home='"+home.getText()+"'";
sql=sql+" where ID='"+id.getText()+"'";
if(db.executeSql(sql))
{
JOptionPane.showMessageDialog(null,"成功更新信息！");
setButton(true,true,true,false,false);
setTextAbled(false);
}else
JOptionPane.showMessageDialog(null,"更新信息失败！");
}
}
});
save.setText(" ");
save.setBounds(312, 314, 66, 48);
panel.add(save);
cancel = new JButton();
cancel.setToolTipText("取消");
cancel.setIcon(SwingResourceManager.getIcon(StudentInfoFrame.class, "/images/4.png"));
cancel.setFont(new Font("", Font.PLAIN, 5));
cancel.addActionListener(new ActionListener() {
public void actionPerformed(final ActionEvent e) {
setTextAbled(false);
if(exeType.equals("add"))
setNull();
setButton(true,true,true,false,false);
}
});
cancel.setText("取消");
cancel.setBounds(409, 314, 66, 48);
panel.add(cancel);
final JButton button_4 = new JButton();
button_4.setToolTipText("退出");
button_4.setIcon(SwingResourceManager.getIcon(StudentInfoFrame.class, "/images/6.png"));
button_4.setFont(new Font("", Font.PLAIN, 5));
button_4.addActionListener(new ActionListener() {
public void actionPerformed(final ActionEvent e) {
StudentInfoFrame.this.dispose();
}
});
button_4.setText("退出");
button_4.setBounds(500, 314, 66, 48);
panel.add(button_4); //
a = new JLabel();
a.setText("添加");
a.setBounds(20, 368, 60, 15);
panel.add(a);
m = new JLabel();
m.setText("修改");
m.setBounds(128, 368, 60, 15);
panel.add(m);
d = new JLabel();
d.setText("删除");
d.setBounds(224, 368, 60, 15);
panel.add(d);
s = new JLabel();
s.setText("保存");
s.setBounds(322, 368, 60, 15);
panel.add(s);
c = new JLabel();
c.setText("取消");
c.setBounds(419, 368, 60, 15);
panel.add(c);
e = new JLabel();
e.setText("退出");
e.setBounds(510, 368, 60, 15);
panel.add(e);
tou = new JLabel();
tou.setIcon(SwingResourceManager.getIcon(StudentInfoFrame.class, "/images/b493852dt.gif"));
panel.add(tou);
tou.setText(" ");
tou.setBounds(0, 0, 600, 96);
tou.setVisible(false);
final JLabel label_17 = new JLabel();
label_17.setIcon(SwingResourceManager.getIcon(StudentInfoFrame.class, "/image/gifbj054.gif"));
label_17.setText(" ");
label_17.setBounds(500, 149, 100, 120);
panel.add(label_17);
final JLabel label_18_1 = new JLabel();
label_18_1.setIcon(SwingResourceManager.getIcon(StudentInfoFrame.class, "/image/gifbj067[1].gif"));
label_18_1.setText(" ");
label_18_1.setBounds(104, 188, 100, 120);
panel.add(label_18_1);
final JLabel label_19_1 = new JLabel();
label_19_1.setIcon(SwingResourceManager.getIcon(StudentInfoFrame.class, "/image/gifbj155.gif"));
label_19_1.setText(" ");
label_19_1.setBounds(204,188, 100, 120);
panel.add(label_19_1);
final JLabel label_17_2 = new JLabel();
label_17_2.setIcon(SwingResourceManager.getIcon(StudentInfoFrame.class, "/image/gifbj189.gif"));
label_17_2.setText(" ");
label_17_2.setBounds(304, 188, 100, 120);
panel.add(label_17_2);
final JLabel label_18 = new JLabel();
label_18.setIcon(SwingResourceManager.getIcon(StudentInfoFrame.class, "/image/gifbj056[1].gif"));
label_18.setText(" ");
label_18.setBounds(10, 56, 100, 120);
panel.add(label_18);
final JLabel label_19 = new JLabel();
label_19.setIcon(SwingResourceManager.getIcon(StudentInfoFrame.class, "/image/gifbj031.gif"));
label_19.setText(" ");
label_19.setBounds(150, 56, 100, 120);
panel.add(label_19);
final JLabel label_20 = new JLabel();
label_20.setIcon(SwingResourceManager.getIcon(StudentInfoFrame.class, "/image/gifbj178.gif"));
label_20.setText(" ");
label_20.setBounds(250, 56, 100, 120);
panel.add(label_20);
final JLabel label_21 = new JLabel();
label_21.setIcon(SwingResourceManager.getIcon(StudentInfoFrame.class, "/image/gifbj135.gif"));
panel.add(label_21);
label_21.setText(" ");
label_21.setBounds(350, 56, 100, 120);
final JLabel label_24 = new JLabel();
panel.add(label_24);
label_24.setIcon(SwingResourceManager.getIcon(StudentInfoFrame.class, "/image/gifbj055.gif"));
label_24.setText(" ");
label_24.setBounds(510, 300, 100, 120);
final JLabel label_22 = new JLabel();
label_22.setIcon(SwingResourceManager.getIcon(StudentInfoFrame.class, "/image/gifbj150.gif"));
panel.add(label_22);
label_22.setText(" ");
label_22.setBounds(500, 27, 100, 120);
final JLabel label_23 = new JLabel();
label_23.setIcon(SwingResourceManager.getIcon(StudentInfoFrame.class, "/images/a13376344a771824c1ea53be7c3e6a9c.gif"));
panel.add(label_23);
label_23.setText(" ");
label_23.setBounds(4, 364, 500, 66);
final JLabel label_8 = new JLabel();
panel.add(label_8);
label_8.setIcon(SwingResourceManager.getIcon(StudentInfoFrame.class, "/images/are.gif"));
label_8.setText(" ");
label_8.setBounds(37, 71, 505, 25);
final JLabel label_7 = new JLabel();
panel.add(label_7);
label_7.setIcon(SwingResourceManager.getIcon(StudentInfoFrame.class, "/images/how.gif"));
label_7.setText(" ");
label_7.setBounds(4, 275, 562, 19);
label_15 = new JLabel();
panel.add(label_15);
//label_15.setIcon(SwingResourceManager.getIcon(StudentInfoFrame.class, "/images/wo.gif"));
label_15.setText(" ");
label_15.setBounds(60, 102, 484, 181);
label_16 = new JLabel();
panel.add(label_16);
label_16.setIcon(SwingResourceManager.getIcon(StudentInfoFrame.class, "/images/ee.JPG"));
label_16.setText(" ");
label_16.setBounds(0, 0, 605, 434);
}
public void setButton(boolean add1,boolean modify1,boolean delete1,boolean save1,boolean cancel1)
{
add.setEnabled(add1);
modify.setEnabled(modify1);
delete.setEnabled(delete1);
save.setEnabled(save1);
cancel.setEnabled(cancel1);
}
public void setTextAbled(boolean b) {
// TODO Auto-generated method stub
id.setEnabled(b);
ethnic.setEnabled(b);
name.setEnabled(b);
cName.setEnabled(b);
sex.setEnabled(b);
birth.setEnabled(b);
home.setEnabled(b);
}
public void setNull()
{
id.setText(null);
ethnic.setText(null);
name.setText(null);
cName.setText(null);
sex.setText(null);
birth.setText(null);
home.setText(null);
}
public void setExeType(String type)
{
exeType=type;
}
public void seeGrade( )
{
MarkSortTableFrame mstf=new MarkSortTableFrame();
mstf.showTableMarkInfo(rs1);
mstf.setVisible(true);
mstf.setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -