Java课程设计报告

《Java课程设计报告》由会员分享，可在线阅读，更多相关《Java课程设计报告（7页珍藏版）》请在装配图网上搜索。

1、Java课程设计报告班级：二班 姓名：宋丹丹 学号：200977202431、 小组成员是：宋丹丹2、 数据库功能的实现：实现了通过学生身高查询学生姓名和年龄的功能，还可以通过学生姓名进行删除学生信息。采用的数据库是： access 。其中一共有 1 库， 1张表。列名数据类型长度允许空姓名文本18否出生日期数字15否成绩数字18否 3、 实现的系统功能是：通过参阅课本中的例子实现了数据的查询和删除功能。整个系统系我一人所作。4、 代码以及运行截图：import javax.swing.*;import java.awt.*;import java.awt.event.*;class MyPa

2、nel extends JPanelpublic class SongDan extends JFrame implements ActionListener JMenu mSystem=new JMenu(操作数据库); JMenuItem mHeight=new JMenuItem(按身高查询); JMenuItem mDelete=new JMenuItem(删除信息); JMenuItem mTC=new JMenuItem(退出); JMenuBar mBar=new JMenuBar(); SongDan() super(学籍管理系统); setSize(400,300); mSy

3、stem.add(mHeight); mSystem.add(mDelete); mSystem.add(mTC); mBar.add(mSystem); mBar.add(mSystem); setJMenuBar(mBar); mTC.addActionListener(this); mDelete.addActionListener(this); mHeight.addActionListener(this); setContentPane(new MyPanel(); setVisible(true); public void actionPerformed(ActionEvent a

4、e) if(ae.getSource()=mTC) System.exit(0); else if(ae.getSource()=mDelete) new DeleteForm().setVisible(true); else if(ae.getSource()=mHeight) new HeightQueryForm().setVisible(true); public static void main(String args) new SongDan();import javax.swing.*;import java.awt.*;import java.awt.event.*;impor

5、t java.sql.*;import javax.swing.table.DefaultTableModel;import javax.swing.table.JTableHeader;public class HeightQueryForm extends JFrame implements ActionListener JLabel labHeight=new JLabel(请输入身高：); JTextField txtHeight=new JTextField(10); JButton btnQuery=new JButton(查询); JPanel pan1=new JPanel()

6、; JPanel pan2=new JPanel(); String str=姓名,年龄,身高; Object data=new Object63; JTable table=new JTable(data,str); JTableHeader head=table.getTableHeader(); JScrollPane jsp=new JScrollPane(table); Connection con; Statement sql; ResultSet rs; HeightQueryForm() super(查询); setSize(300,200); pan1.add(labHeig

7、ht); pan1.add(txtHeight); pan1.add(btnQuery); getContentPane().add(pan1,North); pan2.setLayout(new BorderLayout(); pan2.add(head,North); pan2.add(jsp,Center); getContentPane().add(pan2,Center); btnQuery.addActionListener(this); setVisible(true); public void actionPerformed(ActionEvent ae) if(ae.getS

8、ource()=btnQuery) int i,j,row; try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); catch(ClassNotFoundException e) try con=DriverManager.getConnection(jdbc:odbc:sd,); sql=con.createStatement(); rs=sql.executeQuery(select COUNT(*) as rowcount from message where 身高=+txtHeight.getText(); rs.next(); row=rs

9、.getInt(rowcount); rs.close(); data=new Objectrow3; rs=sql.executeQuery(select * from message where 身高=+txtHeight.getText(); i=0;j=0; while(rs.next() dataij+=rs.getString(姓名); dataij+=rs.getInt(年龄); dataij=new Integer(rs.getInt(身高); i+;j=0; pan2.removeAll(); getContentPane().remove(pan2); table=new

10、JTable(data,str); pan2.setLayout(new BorderLayout(); head=table.getTableHeader(); jsp=new JScrollPane(table); pan2.add(head,North); pan2.add(jsp,Center); getContentPane().add(pan2,Center); this.validate(); con.close(); catch(SQLException e) public static void main(String args) new HeightQueryForm();

11、 import javax.swing.*;import java.awt.*;import java.awt.event.*;import java.sql.*;public class DeleteForm extends JFrame implements ActionListenerJLabel labName=new JLabel(姓名：); JLabel labAge=new JLabel(年龄：); JLabel labHeight=new JLabel(身高：); JTextField txtName=new JTextField(18); JTextField txtAge=

12、new JTextField(15); JTextField txtHeight=new JTextField(18); JButton btnDelete=new JButton(删除); JButton btnCancel=new JButton(取消); JButton btnQuery=new JButton(查询); JPanel pan=new JPanel(); JPanel pan1=new JPanel(); JPanel pan2=new JPanel(); JPanel pan3=new JPanel(); JPanel pan4=new JPanel(); Connec

13、tion con; Statement sql; ResultSet rs; DeleteForm() super(删除记录); setSize(300,200); pan1.add(labName); pan1.add(txtName); pan2.add(labAge); pan2.add(txtAge); pan3.add(labHeight); pan3.add(txtHeight); pan4.add(btnQuery); pan4.add(btnDelete); pan4.add(btnCancel); pan.setLayout(new GridLayout(3,1); pan.

14、add(pan1); pan.add(pan2); pan.add(pan3); getContentPane().add(pan,Center); getContentPane().add(pan4,South); btnQuery.addActionListener(this); btnDelete.addActionListener(this); btnCancel.addActionListener(this); btnDelete.setEnabled(false); txtAge.setEditable(false); txtHeight.setEditable(false); s

15、etVisible(true); txtName.requestFocus(); public void actionPerformed(ActionEvent ae) if(ae.getSource()=btnCancel) dispose(); else if(ae.getSource()=btnQuery) try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); catch(ClassNotFoundException e) trycon=DriverManager.getConnection(jdbc:odbc:sd,); sql=con.cr

16、eateStatement(); rs=sql.executeQuery(select * from message where 姓名=+txtName.getText()+); if(rs.next() txtName.setText(rs.getString(姓名); txtHeight.setText(new Integer(rs.getInt(身高).toString(); txtAge.setText(new Integer(rs.getInt(年龄).toString(); btnDelete.setEnabled(true); txtAge.setEditable(true);

17、txtHeight.setEditable(true); else System.out.println(该记录不存在！); btnDelete.setEnabled(false); txtName.setText(); txtHeight.setText(); txtAge.setText(); txtAge.setEditable(false); txtHeight.setEditable(false); catch(SQLException e) else if(ae.getSource()=btnDelete) try System.out.println(Update message

18、 set 年龄=+txtAge.getText()+,身高=+txtHeight.getText()+ where 姓名=+txtName.getText()+); sql.executeUpdate(DELETE FROM message where 姓名=+txtName.getText()+); System.out.println(记录已删除！); btnDelete.setEnabled(false); txtName.setText(); txtHeight.setText(); txtAge.setText(); txtAge.setEditable(false); txtHeight.setEditable(false); con.close(); catch(SQLException e) public static void main(String args) new DeleteForm();