?? jiajian.java
字號:
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.util.*;
import java.sql.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.table.*;
import java.sql.ResultSet;
import java.io.*;
//添加加減分窗體
//////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////////////
class jiajian extends JFrame implements ActionListener{
JLabel lb1 = new JLabel("獎 懲 信 息");
JLabel lb2 = new JLabel("學 號：");
JLabel lb3 = new JLabel("姓 名：");
JLabel lb4 = new JLabel("加 分：");
JLabel lb5 = new JLabel("減 分：");
Connection con;
Statement stmt;
ResultSet rs;
JTextField id = new JTextField();
JTextField name = new JTextField();
JTextField jia = new JTextField();
JTextField jian = new JTextField();
JButton btright = new JButton("<<");
JButton btleft = new JButton(">>");
JButton btamend = new JButton("修改");
JButton btsave = new JButton("添加");
public jiajian(){
setTitle("獎懲分");
id.setEditable(false);
name.setEditable(false);
getContentPane().setLayout(null);
Font f = new Font("新宋體",0,14);
btleft.setFont(f);
lb1.setFont(new java.awt.Font("新宋體", 1, 18));
lb1.setForeground(new Color(0, 51, 255));
getContentPane().add(lb1);
lb1.setBounds(110, 20, 160, 30);
lb2.setFont(f);
getContentPane().add(lb2);
lb2.setBounds(40, 85, 70, 20);
lb3.setFont(f);
getContentPane().add(lb3);
lb3.setBounds(40, 125, 70, 20);
lb4.setFont(f);
getContentPane().add(lb4);
lb4.setBounds(40,165,70,20);
lb5.setFont(f);
getContentPane().add(lb5);
lb5.setBounds(40,205,70,20);
getContentPane().add(id);
id.setBounds(155,85,120,23);
getContentPane().add(name);
name.setBounds(155,125,120,23);
getContentPane().add(jia);
jia.setBounds(155,165,120,23);
getContentPane().add(jian);
jian.setBounds(155,205,120,23);
btright.setFont(f);
getContentPane().add(btright);
btright.setBounds(330, 250, 50, 20);
btright.addActionListener(this);
btleft.setFont(f);
getContentPane().add(btleft);
btleft.setBounds(330, 230, 50, 20);
btleft.addActionListener(this);
btamend.setFont(f);
getContentPane().add(btamend);
btamend.setBounds(230, 240, 70, 25);
btamend.addActionListener(this);
btsave.setFont(f);
getContentPane().add(btsave);
btsave.setBounds(100, 240, 70, 25);
btsave.addActionListener(this);
Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
setBounds((screenSize.width-403)/2, (screenSize.height-329)/2, 403, 329);
this.connection();
setVisible(true);
}
public void connection(){
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:studentscore");
stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE) ;
String sqlw="select * from studentscore";
rs=stmt.executeQuery(sqlw);
try{
rs.next();
String xh=(""+rs.getString("學號"));
String xm=rs.getString("姓名");
String jiafen=rs.getString("加分");
String jianfen=rs.getString("減分");
id.setText(xh);
name.setText(xm);
jia.setText(jiafen);
jian.setText(jianfen);
}
catch(Exception esql){
System.out.println(esql.getMessage());
}
} catch (Exception ex) {
System.out.println(ex.getMessage());
}
}
public void actionPerformed(ActionEvent e){
if(e.getSource()==btright)
{
try{
rs.previous();
String xh=(""+rs.getString("學號"));
String xm=rs.getString("姓名");
String jiafen=rs.getString("加分");
String jianfen=rs.getString("減分");
id.setText(xh);
name.setText(xm);
jia.setText(jiafen);
jian.setText(jianfen);
}
catch(Exception eup){
System.out.println(eup.getMessage());
}
}
if(e.getSource()==btleft){
try{
rs.next();
String xh=(""+rs.getString("學號"));
String xm=rs.getString("姓名");
String jiafen=rs.getString("加分");
String jianfen=rs.getString("減分");
id.setText(xh);
name.setText(xm);
jia.setText(jiafen);
jian.setText(jianfen);
}
catch(Exception enext){
System.out.println(enext.getMessage());
}
}
if(e.getSource()==btsave){
if(jia.getText().equals("")||jian.getText().equals("")){
new JOptionPane().showMessageDialog(null,"以上信息必須填寫!");
}
else{
//btsave.setEnabled(true);
String xh=id.getText();
String xm=name.getText();
String jiafen=jia.getText();
String jianfen=jian.getText();
//id.setEditable(true);
try{
String Insert="insert into studentscore(加分,減分) values('"+jiafen+"','"+jianfen+"')";
stmt.executeUpdate(Insert);
id.setEditable(true);
name.setEditable(true);
btsave.setEnabled(false);
new JOptionPane().showMessageDialog(null,"添加數據成功！");
//ResultSet rs1;
String sql="select * from studentscore";
rs=stmt.executeQuery(sql);
rs.next();
String xh1=(""+rs.getInt("學號"));
String xm1=rs.getString("姓名");
String jiafen1=rs.getString("加分");
String jianfen1=rs.getString("減分");
id.setText(xh1);
name.setText(xm1);
jia.setText(jiafen1);
jian.setText(jianfen1);
}
catch(Exception esave){ System.out.println(esave.getMessage());
new JOptionPane().showMessageDialog(null,"添加數據不成功！");
}
}
}
if(e.getSource()==btamend){
try{
String supdate="update studentscore set 加分='"+ jia.getText() +"',減分='"+jian.getText()+"' where 學號='"+ id.getText()+"'";//學號='"+ id.getText()+"', 姓名='"+ name.getText()+"',
new JOptionPane().showMessageDialog(null,"數據修改成功！");
stmt.executeUpdate(supdate);
//ResultSet rs1;
String sqll="select * from studentscore";
rs=stmt.executeQuery(sqll);
rs.next();
String xh1=(""+rs.getInt("學號"));
String xm1=rs.getString("姓名");
String jiafen1=rs.getString("加分");
String jianfen1=rs.getString("減分");
id.setText(xh1);
name.setText(xm1);
jia.setText(jiafen1);
jian.setText(jianfen1);
}
catch(Exception eupdapt){
System.out.println(eupdapt.getMessage());
}
}
}
}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -