?? gengxinchengji.java
字號:
package don;
import java.awt.CheckboxGroup;
import java.awt.HeadlessException;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.swing.ButtonGroup;
import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JCheckBox;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JRadioButton;
import javax.swing.JTextField;
public class gengxinchengji extends JFrame
{
static ImageIcon icon=new ImageIcon("FOX.jpg");
JLabel tupian;
JLabel xuanze;
JLabel xiugai;
JLabel shanchu;
JLabel tianjia;
JRadioButton tianjia0;
JRadioButton xiugai0;
JRadioButton shanchu0;
ButtonGroup xuanze0;
JButton tuichu;
JLabel xuehao;
JTextField xuehao0;
JLabel yuwen;
JLabel shuxue;
JLabel yingyu;
JTextField yuwen0;
JTextField shuxue0;
JTextField yingyu0;
JButton tijiao;
JButton guanbi;
JLabel kemu;
JComboBox kemu1;
JLabel xueqi;
JComboBox xueqi1;
gengxinchengji()
{
super("更新成績");
xuanze=new JLabel("選擇您要執(zhí)行的操作:");
tupian=new JLabel();
ImageIcon ligong=new ImageIcon("ligong.jpg");
tupian=new JLabel(ligong);
tianjia=new JLabel("添加成績");
xiugai=new JLabel("修改成績");
shanchu=new JLabel("刪除成績");
tianjia0=new JRadioButton();//添加的按鈕
xiugai0=new JRadioButton();//修改的按按鈕
shanchu0=new JRadioButton();
xuanze0=new ButtonGroup();
xuehao=new JLabel("輸入學號:");
xuehao0=new JTextField(10);
yuwen=new JLabel("語文成績:");
shuxue=new JLabel("數(shù)學成績:");
yingyu=new JLabel("英語成績:");
yuwen0=new JTextField(10);
shuxue0=new JTextField(10);
yingyu0=new JTextField(10);
tijiao=new JButton("提交");
guanbi=new JButton("退出");
kemu=new JLabel("科目:");
kemu1=new JComboBox();
kemu1.addItem("語文");
kemu1.addItem("數(shù)學");
kemu1.addItem("英語");
xueqi=new JLabel("學期");
xueqi1=new JComboBox();
xueqi1.addItem("第一學期");
xueqi1.addItem("第二學期");
setBounds(200,120,650,480);//設置窗口顯示的坐標及位置
setIconImage(icon.getImage());//設置圖標
add(tupian);
add(xuanze);
xuanze0.add(tianjia0);
xuanze0.add(xiugai0);
xuanze0.add(shanchu0);
add(tianjia0);
add(xiugai0);
add(shanchu0);
add(tianjia);
add(xiugai);
add(shanchu);
add(xuehao);
add(xuehao0);
add(yuwen);
add(yuwen0);
add(shuxue);
add(shuxue0);
add(yingyu);
add(yingyu0);
add(tijiao);
add(guanbi);
add(kemu);
add(kemu1);
add(xueqi);
add(xueqi1);
tianjia0.setSelected(false);
tupian.setBounds(0,0,650,130);
xuanze.setBounds(90,145,160,20);
tianjia.setBounds(240, 145, 80, 20);
xiugai.setBounds(340, 145, 80, 20);
shanchu.setBounds(440, 145, 80, 20);
tianjia0.setBounds(220,147,16,16);
xiugai0.setBounds(320,147,16,16);
shanchu0.setBounds(420,147,16,16);
xuehao.setBounds(155,190,80,20);
xuehao0.setBounds(225,190,80,25);
yuwen.setBounds(155,240,80,20);
yuwen0.setBounds(225,240,80,25);
shuxue.setBounds(155,290,80,20);
shuxue0.setBounds(225,290,80,25);
yingyu.setBounds(155,340,80,20);
yingyu0.setBounds(225,340,80,25);
tijiao.setBounds(350,335,65,30);
kemu.setBounds(335,190,80,20);
kemu1.setBounds(375,190,80,20);
xueqi.setBounds(335, 240, 80, 20);
xueqi1.setBounds(375, 240, 80, 20);
guanbi.setBounds(430,335,65,30);
tianjia0.addActionListener(new MyListener());
xiugai0.addActionListener(new MyListener());
shanchu0.addActionListener(new MyListener());
tijiao.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
String tt;
DBSource db=new DBSource();
if(tianjia0.isSelected())
{
if(xueqi1.getSelectedItem().equals("第一學期"))
{
tt="term1";
}
else
{
tt="term2";
}
String s1="select * from geren where sno='" + xuehao0.getText() + "'";
ResultSet rs1=db.executeQuery(s1);//有關此學號的紀錄已經(jīng)存在！
//System.out.println("ljlj");
try
{
if(rs1.next())
{
if(tt=="term1")
{
//System.out.println("ljlj");
//DBsource db1=new DBsource();
String ss2="update term1 set schinese='"+yuwen0.getText().trim() + "',senglish='"+yingyu0.getText().trim()+"',smath='"+shuxue0.getText().trim()+"'where sno='" + xuehao0.getText().trim() + "'" ;
System.out.println(ss2);
boolean ba=db.execute(ss2);
if(ba)
{
JOptionPane.showMessageDialog(null,"添加成績成功！！！");
}
}
else
{
DBSource db2=new DBSource();
String ss2="update term2 set schinese='"+yuwen0.getText().trim() + "',senglish='"+yingyu0.getText().trim()+"',smath='"+shuxue0.getText().trim()+"'where sno='" + xuehao0.getText().trim() + "'" ;
System.out.println(ss2);
boolean ba=db2.execute(ss2);
if(ba)
{
JOptionPane.showMessageDialog(null,"添加成績成功！！！");
}
}
}
else
{
JOptionPane.showMessageDialog(null,"此學號不存在！！！");
}
}
catch (HeadlessException e1)
{
e1.printStackTrace();
}
catch (SQLException e1)
{
e1.printStackTrace();
}
}
if(xiugai0.isSelected())
{
if(xueqi1.getSelectedItem().equals("第一學期"))
{
tt="term1";
}
else
{
tt="term2";
}
String ss3="select * from geren where sno='" + xuehao0.getText() + "'";
ResultSet rs2=db.executeQuery(ss3);//有關此學號的紀錄已經(jīng)存在！
//System.out.println("ljlj");
try
{
if(rs2.next())
{
if(tt=="term1")
{
if(kemu1.getSelectedItem().equals("語文"))
{
String ss5="update term1 set schinese='"+yuwen0.getText().trim() + "' where sno='" + xuehao0.getText().trim() + "'" ;
System.out.println(ss5);
boolean ba=db.execute(ss5);
if(ba)
{
JOptionPane.showMessageDialog(null,"修改語文成績成功！！！");
}
}
else if(kemu1.getSelectedItem().equals("數(shù)學"))
{
String ss6="update term1 set smath='"+shuxue0.getText().trim() + "' where sno='" + xuehao0.getText().trim() + "'" ;
System.out.println(ss6);
boolean ba=db.execute(ss6);
if(ba)
{
JOptionPane.showMessageDialog(null,"修改數(shù)學成績成功！！！");
}
}
else if(kemu1.getSelectedItem().equals("英語"))
{
String ss7="update term1 set senglish='"+yingyu0.getText().trim() + "' where sno='" + xuehao0.getText().trim() + "'" ;
System.out.println(ss7);
boolean ba=db.execute(ss7);
if(ba)
{
JOptionPane.showMessageDialog(null,"修改英語成績成功！！！");
}
}
}
if(tt=="term2")
{
if(kemu1.getSelectedItem().equals("語文"))
{
String ss8="update term2 set schinese='"+yuwen0.getText().trim() + "' where sno='" + xuehao0.getText().trim() + "'" ;
System.out.println(ss8);
boolean ba=db.execute(ss8);
if(ba)
{
JOptionPane.showMessageDialog(null,"修改語文成績成功！！！");
}
}
else if(kemu1.getSelectedItem().equals("數(shù)學"))
{
DBSource db7=new DBSource();
String ty="update term2 set smath='"+shuxue0.getText().trim() + "' where sno='" + xuehao0.getText().trim() + "'" ;
System.out.println(ty);
boolean ba=db7.execute(ty);
if(ba)
{
JOptionPane.showMessageDialog(null,"修改數(shù)學成績成功！！！");
}
}
else if(kemu1.getSelectedItem().equals("英語"))
{
String ss9="update term2 set senglish='"+yingyu0.getText().trim() + "' where sno='" + xuehao0.getText().trim() + "'" ;
System.out.println(ss9);
boolean ba=db.execute(ss9);
if(ba)
{
JOptionPane.showMessageDialog(null,"修改英語成績成功！！！");
}
}
}
}
else
{
JOptionPane.showMessageDialog(null,"此學號不存在！！！");
}
}
catch (HeadlessException e1)
{
e1.printStackTrace();
}
catch (SQLException e1)
{
e1.printStackTrace();
}
}
if(shanchu0.isSelected())
{
if(xueqi1.getSelectedItem().equals("第一學期"))
{
tt="term1";
}
else
{
tt="term2";
}
String ss10="select * from geren where sno='" + xuehao0.getText() + "'";
ResultSet rs3=db.executeQuery(ss10);//有關此學號的紀錄已經(jīng)存在！
//System.out.println("ljlj");
try
{
if(rs3.next())
{
if(tt=="term1")
{
if(kemu1.getSelectedItem().equals("語文"))
{
String ss11="update term1 set schinese='"+null+"' where sno='" + xuehao0.getText().trim() + "'" ;
System.out.println(ss11);
boolean ba=db.execute(ss11);
if(ba)
{
JOptionPane.showMessageDialog(null,"刪除語文成績成功！！！");
}
}
else if(kemu1.getSelectedItem().equals("數(shù)學"))
{
String ss12="update term1 set smath='"+null+"' where sno='" + xuehao0.getText().trim() + "'" ;
System.out.println(ss12);
boolean ba=db.execute(ss12);
if(ba)
{
JOptionPane.showMessageDialog(null,"刪除數(shù)學成績成功！！！");
}
}
else if(kemu1.getSelectedItem().equals("英語"))
{
String ss13="update term1 set senglish='"+null+ "' where sno='" + xuehao0.getText().trim() + "'" ;
System.out.println(ss13);
boolean ba=db.execute(ss13);
if(ba)
{
JOptionPane.showMessageDialog(null,"刪除英語成績成功！！！");
}
}
}
else
{
if(kemu1.getSelectedItem().equals("語文"))
{
String ss14="update term2 set schinese='"+null+ "' where sno='" + xuehao0.getText().trim() + "'" ;
System.out.println(ss14);
boolean ba=db.execute(ss14);
if(ba)
{
JOptionPane.showMessageDialog(null,"刪除語文成績成功！！！");
}
}
else if(kemu1.getSelectedItem().equals("數(shù)學"))
{
String ss15="update term2 set smath='"+null+ "' where sno='" + xuehao0.getText().trim() + "'" ;
System.out.println(ss15);
boolean ba=db.execute(ss15);
if(ba)
{
JOptionPane.showMessageDialog(null,"刪除數(shù)學成績成功！！！");
}
}
else if(kemu1.getSelectedItem().equals("英語"))
{
String ss16="update term2 set senglish='"+null+ "' where sno='" + xuehao0.getText().trim() + "'" ;
System.out.println(ss16);
boolean ba=db.execute(ss16);
if(ba)
{
JOptionPane.showMessageDialog(null,"刪除英語成績成功！！！");
}
}
}
}
else
{
JOptionPane.showMessageDialog(null,"此學號不存在！！！");
}
}
catch (HeadlessException e1)
{
e1.printStackTrace();
}
catch (SQLException e1)
{
e1.printStackTrace();
}
}
}
});
guanbi.addActionListener//關閉按鈕的監(jiān)聽
(
new ActionListener()
{
public void actionPerformed(ActionEvent evt)
{
System.exit(0);
}
}
);
setResizable(false);//設置窗口的尺寸不可改變
setLayout(null);
setState(JFrame.NORMAL);//設置窗口為標準狀態(tài)，也可fra.setState(Frame.NORMAL);
setVisible(true);//繼承Window類的方法，在屏幕上顯示窗口也可用fra.setVisible(true);
addWindowListener(new WindowAdapter()
{
public void windowClosing(WindowEvent e)
{
System.exit(0);
}
});
}
class MyListener implements ActionListener//設置事件處理；
{
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==tianjia0)
{
xuehao0.setEditable(true);
yuwen0.setEditable(true);
shuxue0.setEditable(true);
yingyu0.setEditable(true);
kemu1.setEnabled(false);
}
else if(e.getSource()==xiugai0)
{
xuehao0.setEditable(true);
yuwen0.setEditable(true);
shuxue0.setEditable(true);
yingyu0.setEditable(true);
kemu1.setEnabled(true);
}
else if(e.getSource()==shanchu0)
{
xuehao0.setEditable(true);
yuwen0.setEditable(false);
shuxue0.setEditable(false);
yingyu0.setEditable(false);
kemu1.setEnabled(true);
}
}
}
public static void main(String[] args)
{
new gengxinchengji();
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -