java--实验四

北京联合大学实验报告课程（项目）名称：图形用户界面设计学院：自动化专业：自动化班级： 0810******* 学号： 2008100322517 姓名：范中涛成绩：2010年 6 月 7 日一、实验目的1、掌握java面向对象技术的基础知识2、掌握java图形用户界面设计（布局管理器的使用）3、掌握java事件处理的使用方法4、掌握JDBC操作数据库的方法5、实现数据库的查询、显示二、实验内容1、使用Access或SQL 2000数据库建立一个至少包括10条或以上记录的数据库，每条记录至少包括数据项：学号、姓名、性别、成绩。

2、使用AWT（或Swing）编制系统功能界面。

主界面：查询信息界面：添加信息界面：3、设置Access数据源，进行前台、后台的连接。

查询全部数据。

对数据库进行动态的查询。

按学号查询：按姓名查询：按性别查询：按成绩查询：实现数据添加。

`添加前，全部数据为：添加操作：添加成功后查询所有：三、实验代码主界面package student;/**** @author fancy*/import java.awt.*;import java.applet.Applet;import java.awt.event.*;import javax.swing.*;/*public interface ActionListener extends EventListener{public viod actionPerformed(ActionEvent e);}*/public class zhujiemian implements ActionListener{JButton button1,button2,button3;public void actionPerformed(ActionEvent e){if(e.getActionCommand().equals("查询成绩")){select obj=new select();obj.select();}if(e.getActionCommand().equals("添加信息")){add obj=new add();obj.add();}if(e.getActionCommand().equals("退出系统")){System.exit(0);}}/*** @param args the command line arguments*/public static void main(String[] args) {// TODO code application logic herezhujiemian obj=new zhujiemian();obj.zhujiemian();}public void zhujiemian(){JFrame frame=new subJFrame("主界面");Container contentPane=frame.getContentPane();contentPane.setLayout(new GridLayout(5,1));contentPane.add(new JLabel("学生成绩管理系统",JLabel.CENTER));button1=new JButton("查询成绩");button2=new JButton("添加信息");button3=new JButton("退出系统");contentPane.add(button1);contentPane.add(button2);contentPane.add(button3);button1.addActionListener(this);button2.addActionListener(this);button3.addActionListener(this);frame.setSize(400,400);frame.show();}}查询界面package student;/**** @author fancy*/import java.awt.*;import java.awt.event.*;import javax.swing.*;public class select implements ActionListener{String str[]={"id","name", "sex","age","jg","all"};JButton button1,button2;JComboBox box1;JTextField field1;String a,b;int i;JTextArea ta=new JTextArea(40,100);JScrollPane pane=new JScrollPane(ta);DbTest1 obj2=new DbTest1();public void actionPerformed(ActionEvent e){if(e.getActionCommand().equals("确定")){if(a.equals("all")){obj2.selectall();}else{obj2.selects(a,b);}ta.append("学号: 姓名: 性别：年龄：java成绩：\n");ta.setLineWrap(true);ta.append(obj2.s1);}if(e.getActionCommand().equals("返回")){zhujiemian obj=new zhujiemian();obj.zhujiemian();}}private class fieldEventHandler implements ActionListener{public void actionPerformed(ActionEvent e){String str1="";if(e.getSource()==field1){b=e.getActionCommand();}}}public void select(){JFrame frame=new subJFrame("查询");Container contentPane=frame.getContentPane();contentPane.setLayout(new GridLayout(12,8));contentPane.add(new JLabel(" 查询条件",JLabel.CENTER)); box1=new JComboBox(str);button1=new JButton("确定");button2=new JButton("返回");field1=new JTextField(10);contentPane.add(new JLabel("字段",JLabel.LEFT));contentPane.add(box1);box1.addItemListener(new ItemListener(){public void itemStateChanged(ItemEvent e){if(e.getStateChange()==ItemEvent.SELECTED){i=box1.getSelectedIndex();a=str[i];}}});contentPane.add(new JLabel("值",JLabel.LEFT));contentPane.add(field1);contentPane.add(button1);contentPane.add(new JLabel("查询结果",JLabel.LEFT)); contentPane.add(pane);contentPane.add(button2);button1.addActionListener(this);button2.addActionListener(this);fieldEventHandler handler=new fieldEventHandler();field1.addActionListener(handler);frame.setSize(400,600);frame.show();}}添加界面package student;/**** @author fancy*/import java.awt.*;import java.awt.event.*;import javax.swing.*;public class add implements ActionListener{String id,name, sex,age,jg;JButton button1,button2;JTextField field1,field2,field3,field4,field5;DbTest1 obj1=new DbTest1();public void actionPerformed(ActionEvent e){if(e.getActionCommand().equals("确定")){obj1.insert(id,name,sex,age,jg);System.out.println(id+name+sex+age+jg);addok obj=new addok();obj.addok();}if(e.getActionCommand().equals("返回")){zhujiemian obj=new zhujiemian();obj.zhujiemian();}}private class fieldEventHandler implements ActionListener{public void actionPerformed(ActionEvent e){String str1="";if(e.getSource()==field1){id=e.getActionCommand();}else if(e.getSource()==field2){name=e.getActionCommand();}else if(e.getSource()==field3){sex=e.getActionCommand();}else if(e.getSource()==field4){age=e.getActionCommand();}else if(e.getSource()==field5){jg=e.getActionCommand();}}}public void add(){JFrame frame=new subJFrame("添加");Container contentPane=frame.getContentPane();contentPane.setLayout(new GridLayout(12,2));field1=new JTextField(10);field2=new JTextField(10);field3=new JTextField(10);field4=new JTextField(10);field5=new JTextField(10);contentPane.add(new JLabel(" 添加",JLabel.RIGHT));contentPane.add(new JLabel("",JLabel.LEFT));contentPane.add(new JLabel("id",JLabel.LEFT));contentPane.add(field1);contentPane.add(new JLabel("name",JLabel.LEFT));contentPane.add(field2);contentPane.add(new JLabel("sex",JLabel.LEFT));contentPane.add(field3);contentPane.add(new JLabel("age",JLabel.LEFT));contentPane.add(field4);contentPane.add(new JLabel("jp",JLabel.LEFT));contentPane.add(field5);button1=new JButton("确定");button2=new JButton("返回");contentPane.add(button1);contentPane.add(button2);button1.addActionListener(this);button2.addActionListener(this);fieldEventHandler handler=new fieldEventHandler();field1.addActionListener(handler);field2.addActionListener(handler);field3.addActionListener(handler);field4.addActionListener(handler);field5.addActionListener(handler);frame.setSize(400,400);frame.show();}}添加成功界面package student;/*** @author fancy*/import java.awt.*;import java.awt.event.*;import javax.swing.*;public class addok implements ActionListener{JButton button1;JFrame frame=new subJFrame("添加成功");public void actionPerformed(ActionEvent e){if(e.getActionCommand().equals("确定")){frame.setVisible(false);}}public void addok(){Container contentPane=frame.getContentPane();contentPane.setLayout(new GridLayout(2,1));contentPane.add(new JLabel("恭喜你，添加成功！",JLabel.CENTER));button1=new JButton("确定");contentPane.add(button1);button1.addActionListener(this);frame.setSize(200,100);frame.show();}}数据库操作界面package student;/*** @author fancy*/import java.sql.*;public class DbTest1 {public static String s1="";public void selectall(){String id,name, sex,age,jg;Connection conn = null;Statement stmt = null;ResultSet rs = null;s1="";try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}catch(ClassNotFoundException e){}try{conn=DriverManager.getConnection("jdbc:odbc:student");stmt=conn.createStatement();String sql="SELECT * FROM student order by id";rs=stmt.executeQuery(sql);while(rs.next()){id=rs.getString("id");name=rs.getString("name");sex=rs.getString("sex");age=rs.getString("age");jg=rs.getString("jg");System.out.println("学号: "+" 姓名: "+" 性别："+"年龄："+"java成绩：");System.out.println(" "+id+" "+name+" "+sex+" "+age+" "+jg);s1=s1.concat(" "+id+" "+name+" "+sex+" "+age+" "+jg +"\n");System.out.println();}conn.close();}catch(SQLException e){System.out.println(e.getMessage());}}public void selects(String str1,String str2){String id,name, sex,age,jg;Connection conn = null;Statement stmt = null;ResultSet rs = null;s1="";try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}catch(ClassNotFoundException e){}try{conn=DriverManager.getConnection("jdbc:odbc:student");stmt=conn.createStatement();String sql="SELECT * FROM student WHERE " +str1+ " ='" + str2 + "'";rs=stmt.executeQuery(sql);while(rs.next()){id=rs.getString("id");name=rs.getString("name");sex=rs.getString("sex");age=rs.getString("age");jg=rs.getString("jg");System.out.println("学号: "+" 姓名: "+" 性别："+"年龄："+"java成绩：");System.out.println(" "+id+" "+name+" "+sex+" "+age+" "+jg);s1=s1.concat(" "+id+" "+name+" "+sex+" "+age+" "+jg +"\n");System.out.println();}conn.close();}catch(SQLException e){System.out.println(e.getMessage());}}public void insert(String str1,String str2,String str3,String str4,String str5){String id,name, sex,age,jg;Connection conn = null;Statement stmt = null;ResultSet rs = null;s1="";try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}catch(ClassNotFoundException e){}try{conn=DriverManager.getConnection("jdbc:odbc:student");stmt=conn.createStatement();String sql="INSERT INTO student(id,name,sex,age,jg) V ALUES (' " +str1+ " ', '" +str2+ "' ,'" +str3+ "' ,' " +str4+ "' ,'" +str5+ "' )";stmt.executeUpdate(sql);conn.close();}catch(SQLException e){System.out.println(e.getMessage());}}}标题框架package student;import java.awt.*;import java.applet.Applet;import javax.swing.*;public class subJFrame extends JFrame{public subJFrame() {}public subJFrame(String title){super(title);}protected void frameInit(){super.frameInit();setDefaultCloseOperation(EXIT_ON_CLOSE);}}四、实验心得经过这次图形界面实验，系统的学习了，图形界面的的设计。