java学生成绩管理系统代码Word文件下载.docx
- 文档编号:14371053
- 上传时间:2022-10-22
- 格式:DOCX
- 页数:20
- 大小:19.30KB
java学生成绩管理系统代码Word文件下载.docx
《java学生成绩管理系统代码Word文件下载.docx》由会员分享,可在线阅读,更多相关《java学生成绩管理系统代码Word文件下载.docx(20页珍藏版)》请在冰豆网上搜索。
出生日期:
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("
}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("
出生日期不能为空〜"
警告"
elsJOptionPane.showMessageDialog(this,"
成绩不能为空〜"
else{
try{
Class.forName("
sun.jdbc.odbc.JdbcOdbcDriver"
}catch(ClassNotFoundExceptionex){
ex.printStackTrace();
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('
'
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;
BrowseForm(){super("
浏览数据"
inti=0,j=0;
introw;
成绩表"
conn=DriverManager.getConnection("
jdbc:
odbc:
stmt=conn.createStatement();
rs=stmt.executeQuery("
selectCOUNT(*)asafromrs.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,"
stmt.close();
}catch(Exceptione){
e.printStackTrace();
}setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
setVisible(true);
newBrowseForm();
classDeleteFormextendsJFrameimplementsActionListener{JLabellabName=newJLabel("
JButtonbtnDel=newJButton("
删除"
JButtonbtnCancel=newJButton("
取消"
JButtonbtnQuery=newJButton("
查询"
JPanelpa
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- java 学生 成绩管理系统 代码