java学生成绩管理系统代码.docx
- 文档编号:15829741
- 上传时间:2023-07-08
- 格式:DOCX
- 页数:27
- 大小:18.09KB
java学生成绩管理系统代码.docx
《java学生成绩管理系统代码.docx》由会员分享,可在线阅读,更多相关《java学生成绩管理系统代码.docx(27页珍藏版)》请在冰点文库上搜索。
java学生成绩管理系统代码
JAVA学生成绩管理系统代码
importjavax.swing.*;
importjava.awt.*;
importjava.awt.event.*;
importjava.sql.*;
importjavax.swing.*;
importjava.awt.*;importjava.awt.event.*;importjava.awt.event.*;
importjavax.swing.*;
importjava.awt.*;
importjava.awt.event.*;
importjava.sql.*;
importjavax.swing.table.JTableHeader;importjavax.swing.*;
importjava.awt.*;
importjava.awt.event.*;
importjava.sql.*;
importjavax.swing.*;
importjava.awt.*;
importjava.awt.event.*;
importjava.sql.*;
importjavax.swing.*;
importjava.awt.*;
importjava.awt.event.*;
importjava.sql.*;
importjavax.swing.*;
importjava.awt.*;
importjava.awt.event.*;
importjava.sql.*;
importjavax.swing.table.DefaultTableModel;importjavax.swing.table.JTableHeader;importjavax.swing.*;
importjava.awt.*;
importjava.awt.event.*;
importjava.sql.*;
classAddFormextendsJFrameimplementsActionListener{
JLabellabName=newJLabel("学号:
");
JLabellabDate=newJLabel("出生日期:
");
JLabellabScore=newJLabel("成绩:
");
JTextFieldtxtName=newJTextField(20);
JTextFieldtxtDate=newJTextField(18);
JTextFieldtxtScore=newJTextField(20);
JButtonbtnOk=newJButton("确定");
JButtonbtnClear=newJButton("清空");
JPanelpan=newJPanel();
JPanelpan1=newJPanel();
JPanelpan2=newJPanel();
JPanelpan3=newJPanel();
JPanelpan4=newJPanel();
Connectioncnn;
Statementstm;
ResultSetrs;
AddForm(){
super("添加数据");
setSize(400,300);
setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
pan.setBorder(BorderFactory.createEtchedBorder());
pan1.add(labName);
pan1.add(txtName);
pan2.add(labDate);
pan2.add(txtDate);
pan3.add(labScore);
pan3.add(txtScore);
pan4.add(btnOk);
pan4.add(btnClear);
pan.setLayout(newGridLayout(3,1));
pan.add(pan1);
pan.add(pan2);
pan.add(pan3);
getContentPane().add(pan,"Center");
getContentPane().add(pan4,"South");
btnOk.addActionListener(this);
btnClear.addActionListener(this);
setVisible(true);
txtName.requestFocus();
}
publicvoidactionPerformed(ActionEventae){
if(ae.getSource()==btnClear){
txtName.setText("");
txtDate.setText("");
txtScore.setText("");
txtName.requestFocus();
}elseif(ae.getSource()==btnOk){
StringstrName=txtName.getText();
StringstrDate=txtDate.getText();
StringstrScore=txtScore.getText();
if(strName.equals(""))
JOptionPane.showMessageDialog(this,"学号不能为空~","警告",JOptionPane.ERROR_MESSAGE);
elseif(strDate.equals(""))
JOptionPane.showMessageDialog(this,"出生日期不能为空~","警告",JOptionPane.ERROR_MESSAGE);
elsJOptionPane.showMessageDialog(this,"成绩不能为空~","警告",JOptionPane.ERROR_MESSAGE);
else{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundExceptionex){
ex.printStackTrace();
}
try{
cnn=DriverManager.getConnection("Jdbc:
Odbc:
MyDB");
stm=cnn.createStatement();
}catch(SQLExceptionex){
ex.printStackTrace();
}
try{
rs=stm.executeQuery("select*from成绩表where学号='"+strName+"'");
if(rs.next()){
JOptionPane.showMessageDialog(this,"对不起,该成绩信息已存在~");
}else//否则插入记录
{
//System.out.println("insertinto成绩表values('"+strName+"',#"+strDate+"#,"+strScore+")");
stm.executeUpdate("insertinto成绩表values('"+strName+"','"+strDate+"',"+strScore+")");
JOptionPane.showMessageDialog(null,"记录已经成功添加~");
}
//断开连接
stm.close();
cnn.close();
}catch(SQLExceptionex){
System.out.println("SQLException:
"+ex.getMessage());
}
}
}
}
publicstaticvoidmain(String[]args){
newAddForm();
}
}
classBrowseFormextendsJFrame{
String[]str={"学号","出生日期","成绩"};
Object[][]data;
JTabletable;
JTableHeaderhead;
JScrollPanejsp;
Connectionconn;
Statementstmt;
ResultSetrs;
BrowseForm(){
super("浏览数据");
setSize(400,300);
inti=0,j=0;
introw;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection("jdbc:
odbc:
MyDB","","");
stmt=conn.createStatement();
rs=stmt.executeQuery("selectCOUNT(*)asafrom成绩表");
rs.next();
row=rs.getInt("a");
rs.close();
data=newObject[row][3];
rs=stmt.executeQuery("select*from成绩表");
while(rs.next()){
data[i][j++]=rs.getString("学号");
data[i][j++]=rs.getDate("出生日期");
data[i][j]=newInteger(rs.getInt("成绩"));
i++;j=0;
}
table=newJTable(data,str);
head=table.getTableHeader();
jsp=newJScrollPane(table);
getContentPane().add(head,"North");
getContentPane().add(jsp,"Center");
rs.close();
stmt.close();
}catch(Exceptione){
e.printStackTrace();
}
setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
setVisible(true);
}
publicstaticvoidmain(String[]args){
newBrowseForm();
}
}
classDeleteFormextendsJFrameimplementsActionListener{
JLabellabName=newJLabel("学号:
");
JLabellabDate=newJLabel("出生日期:
");
JLabellabScore=newJLabel("成绩:
");
JTextFieldtxtName=newJTextField(20);
JTextFieldtxtDate=newJTextField(18);
JTextFieldtxtScore=newJTextField(20);
JButtonbtnDel=newJButton("删除");
JButtonbtnCancel=newJButton("取消");
JButtonbtnQuery=newJButton("查询");
JPanelpan=newJPanel();
JPanelpan1=newJPanel();
JPanelpan2=newJPanel();
JPanelpan3=newJPanel();
JPanelpan4=newJPanel();
Connectioncnn;
Statementstm;
ResultSetrs;
DeleteForm(){
super("删除数据");
setSize(400,300);
setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
pan.setBorder(BorderFactory.createEtchedBorder());
pan1.add(labName);
pan1.add(txtName);
pan2.add(labDate);
pan2.add(txtDate);
pan3.add(labScore);
pan3.add(txtScore);
pan4.add(btnQuery);
pan4.add(btnDel);
pan4.add(btnCancel);
pan.setLayout(newGridLayout(3,1));
pan.add(pan1);
pan.add(pan2);
pan.add(pan3);
getContentPane().add(pan,"Center");
getContentPane().add(pan4,"South");
btnQuery.addActionListener(this);
btnDel.addActionListener(this);
btnCancel.addActionListener(this);
btnDel.setEnabled(false);
txtDate.setEditable(false);
txtScore.setEditable(false);
setVisible(true);
txtName.requestFocus();
}
publicvoidactionPerformed(ActionEventae){
/*if(ae.getSource()==btnCancel){
try{
if(stm!
=null)
stm.close();
if(cnn!
=null)
cnn.close();
}catch(SQLExceptionex){
ex.printStackTrace();
}
this.dispose();
}elseif(ae.getSource()==btnQuery){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
cnn=DriverManager.getConnection("jdbc:
odbc:
MyDB","","");
stm=cnn.createStatement();
rs=stm.executeQuery("select*from成绩表where学号
='"+txtName.getText()+"'");
if(rs.next()){
txtName.setText(rs.getString("学号"));
txtDate.setText(rs.getDate("出生日期").toString());
txtScore.setText(newInteger(rs.getInt("成绩")).toString());
btnDel.setEnabled(true);
}else{
JOptionbtnDel.setEnabled(false);
txtName.setText("");
txtScore.setText("");
txtDate.setText("");
}
}catch(Exceptione){
e.printStackTrace();
}
}elseif(ae.getSource()==btnDel){
try{
if(JOptionPane.YES_OPTION==JOptionPane.showConfirmDialog
(this,"确定要删除该记录,","信息",JOptionPane.YES_NO_OPTION)){
stm.executeUpdate("deletefrom成绩表where学号='"+txtName.getText()+"'");
btnDel.setEnabled(false);
txtName.setText("");
txtScore.setText("");
txtDate.setText("");
}
}
catch(SQLExceptionex){
ex.printStackTrace();
}
}*/
}
publicstaticvoidmain(String[]args){
newDeleteForm();
}
}
classLoginFormextendsJFrameimplementsActionListener{
JLabellabName=newJLabel("姓名");
JLabellabPwd=newJLabel("密码");
JTextFieldtxtName=newJTextField(20);
JPasswordFieldtxtPwd=newJPasswordField(20);
JButtonbtnOk=newJButton("确定");
JButtonbtnCancel=newJButton("取消");
JPanelpan=newJPanel();
JPanelpan1=newJPanel();
JPanelpan2=newJPanel();
JPanelpan3=newJPanel();
JPanelpan4=newJPanel();
Connectioncnn;
Statementstm;
ResultSetrs;
LoginForm(){
super("用户登录");
setSize(300,200);
setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
pan.setBorder(BorderFactory.createTitledBorder("登录"));
pan.setLayout(newGridLayout(2,1));
pan1.add(labName);
pan1.add(txtName);
pan2.add(labPwd);
pan2.add(txtPwd);
pan.add(pan1);
pan.add(pan2);
pan3.add(btnOk);
pan3.add(btnCancel);
pan4.add(pan);
getContentPane().add(pan4,"Center");
getContentPane().add(pan3,"South");
txtName.addActionListener(this);
txtPwd.addActionListener(this);
btnOk.addActionListener(this);
btnCancel.addActionListener(this);
setVisible(true);
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundExceptionex){
ex.printStackTrace();
}
try{
cnn=DriverManager.getConnection("Jdbc:
Odbc:
MyDB");
stm=cnn.createStatement();
}catch(SQLExceptionex){
ex.printStackTrace();
}
txtName.requestFocus();
}
publicvoidactionPerformed(ActionEventae){
if(ae.getSource()==txtName)
txtPwd.requestFocus();
elseif(ae.getSource()==txtPwd)
btnOk.requestFocus();
elstxtName.setText("");
txtPwd.setText("");
txtName.requestFocus();
}elseif(ae.getSource()==btnOk){
Stringstr="select*from用户表where用户名='"+txtName.getText()+"'and密码='"+newString(txtPwd.getPassword())+"'";
try{
rs=stm.executeQuery(str);
}catch(SQLExceptionex){
ex.printStackTrace();
}
try{
if(rs.next()){
JOptionPane.showMessageDialog(this,"验证通过!
","信息",JOptionPane.INFORMATION_MESSAGE);
rs.close();
stm.close();
cnn.close();
newMainForm().setVisible(true);
this.dispose();
}else{
JOptionPane.showMessageDialog(this,"用户名或密码不正确!
","信息",JOptionPane.INFORMATION_MESSAGE);
}
}catch(SQLExceptionex){
ex.printStackTrace();
}
}
}
publicstaticvoidmain(String[]args){
newLoginForm();
}
}
classModifyFormextendsJFrameimplementsActionListener{
JLabellabName=newJLabel("学号:
");
JLabellabDate=newJLabel("出生日期:
");
JLabellabScore=newJLabel("成绩:
");
JTextFieldtxtName=newJTextField(20);
JTextFieldtxtDate=newJTextField(18);
JTex
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- java 学生 成绩管理系统 代码