📄 chengji.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 chengji extends JFrame implements ActionListener {
private JLabel lbl7=new JLabel("学 号：");
private JLabel lbl1=new JLabel("姓 名：");
private JLabel lbl2=new JLabel("高等数学：");
private JLabel lbl4=new JLabel("大学物理：");
private JLabel lbl3=new JLabel("大学英语：");
private JLabel lbl5=new JLabel("ＶＢ ：");
private JLabel lbl6=new JLabel("ＶＣ ：");
private JTextField stid=new JTextField(10);
private JTextField stname=new JTextField(10);
private JTextField gaoshu=new JTextField(10);
private JTextField wuli=new JTextField(10);
private JTextField yingyu=new JTextField(10);
private JTextField vb=new JTextField(10);
private JTextField vc=new JTextField(10);
private JButton btnadd=new JButton("添加");
private JButton delete=new JButton("删除");
private JButton updapt=new JButton("修改");
private JButton save=new JButton("保存");
private JButton up=new JButton("<<");
private JButton next=new JButton(">>");
Connection con;
Statement stmt;
ResultSet rs;
public chengji(){
setTitle("学生成绩");
Font f=new Font("宋体",Font.PLAIN,12);
//this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
getContentPane().setLayout(null);
lbl7.setBounds(30,30,80,25);
lbl7.setFont(f);
getContentPane().add(lbl7);
stid.setBounds(100,30,100,25);
stid.setBorder(BorderFactory.createLineBorder(Color.black));
getContentPane().add(stid);
lbl1.setBounds(30,70,80,25);
lbl1.setFont(f);
getContentPane().add(lbl1);
stname.setBounds(100,70,100,25);
stname.setBorder(BorderFactory.createLineBorder(Color.black));
getContentPane().add(stname);
lbl2.setBounds(230,30,80,25);
lbl2.setFont(f);
getContentPane().add(lbl2);
gaoshu.setBounds(300,30,100,25);
gaoshu.setBorder(BorderFactory.createLineBorder(Color.black));
getContentPane().add(gaoshu);
lbl3.setBounds(30,110,80,25);
lbl3.setFont(f);
getContentPane().add(lbl3);
wuli.setBounds(300,70,100,25);
wuli.setBorder(BorderFactory.createLineBorder(Color.black));
getContentPane().add(wuli);
lbl4.setBounds(230,70,80,25);
lbl4.setFont(f);
getContentPane().add(lbl4);
yingyu.setBounds(100,110,100,25);
yingyu.setBorder(BorderFactory.createLineBorder(Color.black));
getContentPane().add(yingyu);
lbl5.setBounds(30,150,80,25);
lbl5.setFont(f);
getContentPane().add(lbl5);
vb.setBounds(100,150,100,25);
vb.setBorder(BorderFactory.createLineBorder(Color.black));
getContentPane().add(vb);
lbl6.setBounds(230,110,80,25);
lbl6.setFont(f);
getContentPane().add(lbl6);
vc.setBounds(300,110,100,25);
vc.setBorder(BorderFactory.createLineBorder(Color.black));
getContentPane().add(vc);
//按钮
btnadd.setBounds(30,220,60,25);
btnadd.setFont(f);
btnadd.setBorder(BorderFactory.createRaisedBevelBorder());
getContentPane().add(btnadd);
delete.setBounds(110,220,60,25);
delete.setFont(f);
delete.setBorder(BorderFactory.createRaisedBevelBorder());
getContentPane().add(delete);
updapt.setBounds(190,220,60,25);
updapt.setFont(f);
updapt.setBorder(BorderFactory.createRaisedBevelBorder());
getContentPane().add(updapt);
save.setBounds(270,220,60,25);
save.setFont(f);
save.setBorder(BorderFactory.createRaisedBevelBorder());
getContentPane().add(save);
up.setBounds(350,218,60,15);
up.setBorder(BorderFactory.createRaisedBevelBorder());
getContentPane().add(up);
next.setBounds(350,232,60,15);
next.setBorder(BorderFactory.createRaisedBevelBorder());
getContentPane().add(next);
up.addActionListener(this);
next.addActionListener(this);
btnadd.addActionListener(this);
delete.addActionListener(this);
updapt.addActionListener(this);
save.addActionListener(this);
Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
setBounds((screenSize.width-403)/2, (screenSize.height-329)/2, 460,350);
//setSize(460,350);
//this.setClosable(true);
setVisible(true);
this.connection();
}
//---连接数据库----------------------------------------------------------------------------
public void connection1(){
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:studentscore");
stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE) ;
} catch (Exception ex) {
System.out.println(ex.getMessage());
}
}
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.getInt("学号"));
String xm=rs.getString("姓名");
String gs=rs.getString("高等数学");
String wl=rs.getString("大学物理");
String yy=rs.getString("大学英语");
String VB=rs.getString("vb");
String VC=rs.getString("vc");
stid.setText(xh);
stname.setText(xm);
gaoshu.setText(gs);
wuli.setText(wl);
yingyu.setText(yy);
vb.setText(VB);
vc.setText(VC);
}
catch(Exception esql){
System.out.println(esql.getMessage());
}
} catch (Exception ex) {
System.out.println(ex.getMessage());
}
}
public void actionPerformed(ActionEvent e){
if(e.getSource()==up)
{
try{
rs.previous();
String xh=(""+rs.getInt("学号"));
String xm=rs.getString("姓名");
String gs=rs.getString("高等数学");
String wl=rs.getString("大学物理");
String yy=rs.getString("大学英语");
String VB=rs.getString("vb");
String VC=rs.getString("vc");
stid.setText(xh);
stname.setText(xm);
gaoshu.setText(gs);
wuli.setText(wl);
yingyu.setText(yy);
vb.setText(VB);
vc.setText(VC);
}
catch(Exception eup){
System.out.println(eup.getMessage());
}
}
if(e.getSource()==next){
try{
rs.next();
String xh=(""+rs.getInt("学号"));
String xm=rs.getString("姓名");
String gs=rs.getString("高等数学");
String wl=rs.getString("大学物理");
String yy=rs.getString("大学英语");
String VB=rs.getString("vb");
String VC=rs.getString("vc");
stid.setText(xh);
stname.setText(xm);
gaoshu.setText(gs);
wuli.setText(wl);
yingyu.setText(yy);
vb.setText(VB);
vc.setText(VC);
}
catch(Exception enext){
System.out.println(enext.getMessage());
}
}
if(e.getSource()==btnadd){
this.connection();
save.setEnabled(true);
stid.setText("");
// stid.setEditable(false);
stname.setText("");
gaoshu.setText("");
wuli.setText("");
yingyu.setText("");
vb.setText("");
vc.setText("");
}
if(e.getSource()==save){
if(stname.getText().equals("")||gaoshu.getText().equals("")||wuli.getText().equals("")||
yingyu.getText().equals("")||vb.getText().equals("")||vc.getText().equals("")){
System.out.println("以上信息必须填写!");
}
else{
String xh=stid.getText();
String xm=stname.getText();
String gs=gaoshu.getText();
String wl=wuli.getText();
String yy=yingyu.getText();
String VB=vb.getText();
String VC=vc.getText();
//stid.setEditable(true);
try{
String Insert="insert into studentscore(学号,姓名,高等数学,大学物理,大学英语,vb,vc) values('"+xh+"','"+xm+"','"+gs+"','"+wl+"','"+yy+"','"+VB+"','"+VC+"')";
stmt.executeUpdate(Insert);
stid.setEditable(true);
save.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 gs1=rs.getString("高等数学");
String wl1=rs.getString("大学物理");
String yy1=rs.getString("大学英语");
String VB1=rs.getString("vb");
String VC1=rs.getString("vc");
stid.setText(xh1);
stname.setText(xm1);
gaoshu.setText(gs1);
wuli.setText(wl1);
yingyu.setText(yy1);
vb.setText(VB1);
vc.setText(VC1);
}
catch(Exception esave){ System.out.println(esave.getMessage());
new JOptionPane().showMessageDialog(null,"添加数据不成功！");
}
}
}
if(e.getSource()==delete)
{
try{
String sqle="delete from studentscore where 学号 ='"+stid.getText()+"'";
stmt.executeUpdate(sqle);
new JOptionPane().showMessageDialog(null,"数据删除成功！");
String sqll="select * from studentscore";
rs=stmt.executeQuery(sqll);
rs.next();
String xh1=(rs.getString("学号"));
String xm1=rs.getString("姓名");
String gs1=rs.getString("高等数学");
String wl1=rs.getString("大学物理");
String yy1=rs.getString("大学英语");
String VB1=rs.getString("vb");
String VC1=rs.getString("vc");
stid.setText(xh1);
stname.setText(xm1);
gaoshu.setText(gs1);
wuli.setText(wl1);
yingyu.setText(yy1);
vb.setText(VB1);
vc.setText(VC1);
}
catch(Exception edelete){
System.out.println(edelete.getMessage());
}
}
if(e.getSource()==updapt){
try{
String supdate="update studentscore set 学号='"+ stid.getText()+"', 姓名='"+ stname.getText()+"',高等数学='"+ gaoshu.getText() +"',大学物理='"+wuli.getText()+"',大学英语='"+yingyu.getText()+"',vb='"+vb.getText()+"',vc='"+vc.getText()+"' where 学号='"+ stid.getText()+"'";
new JOptionPane().showMessageDialog(null,"数据修改成功！");
stmt.executeUpdate(supdate);
//ResultSet rs1;
String sqll="select * from studentscore";
rs=stmt.executeQuery(sqll);
rs.next();
String xh1=(""+rs.getString("学号"));
String xm1=rs.getString("姓名");
String gs1=rs.getString("高等数学");
String wl1=rs.getString("大学物理");
String yy1=rs.getString("大学英语");
String VB1=rs.getString("vb");
String VC1=rs.getString("vc");
stid.setText(xh1);
stname.setText(xm1);
gaoshu.setText(gs1);
wuli.setText(wl1);
yingyu.setText(yy1);
vb.setText(VB1);
vc.setText(VC1);
}
catch(Exception eupdapt){
System.out.println(eupdapt.getMessage());
}
}
}///////////////////
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -