Java进阶 实验五

《Java语言进阶》实验报告（5）JDBC Programming (JDBC数据库编程)学院：计算机与信息学院专业：计算机科学与技术学号：姓名：指导老师：一、实验目的：掌握应用JDBC技术访问数据库的方法。

二、实验内容：(Accessing and updating a Staff table) Write a Java application that views, inserts, and updates staff information stored in a database, as shown in Figure 1.The View button displays a record with a specified ID. The Staff table is created as follows:create table Staff (id char(9) not null,lastName varchar(15),firstName varchar(15),mi char(1),address varchar(20),city varchar(20),state char(2),telephone char(10),email varchar(40),primary key (id));三、实验要求：1、认真执行每一个步骤的，并作好记录。

2、实验报告中给出配置的详细步骤和重要的截图。

四、实验步骤：创建表：正常界面：插入数据数据库结果显示数据：更新数据：结果：五、总结：1，使用mysql2，需要用到参数化的sql语句。

3，用到eclipse的窗口builer创建界面。

源代码：package db_connect;import java.awt.EventQueue;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.*;import javax.swing.*;public class mysql_five {private JFrame frmStaffInformation;private JTextField textField_id;private JTextField textField_last;private JTextField textField_first;private JTextField textField_mi;private JTextField textField_address;private JTextField textField_city;private JTextField textField_state;private JTextField textField_tele;private String id;private String last;private String first;private String mi;private String address;private String city;private String state;private String tele;/*** Launch the application.*/public static void main(String[] args) { EventQueue.invokeLater(new Runnable() {public void run() {try {mysql_five window = new mysql_five();window.frmStaffInformation.setVisible(true);} catch (Exception e) {e.printStackTrace();}}});}/*** Create the application.*/public mysql_five() {initialize();}/*** Initialize the contents of the frame.*/private void initialize() {frmStaffInformation = new JFrame();frmStaffInformation.setTitle("staff information");frmStaffInformation.setBounds(100, 100, 450, 300);frmStaffInformation.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE );frmStaffInformation.getContentPane().setLayout(null);JLabel lblId = new JLabel("ID :");lblId.setBounds(0, 0, 65, 28);frmStaffInformation.getContentPane().add(lblId);textField_id = new JTextField();textField_id.setBounds(22, 4, 91, 21);frmStaffInformation.getContentPane().add(textField_id);textField_id.setColumns(10);JLabel lblLastName = new JLabel("last name");lblLastName.setBounds(0, 38, 91, 39);frmStaffInformation.getContentPane().add(lblLastName);textField_last = new JTextField();textField_last.setBounds(62, 47, 81, 21);frmStaffInformation.getContentPane().add(textField_last); textField_last.setColumns(10);JLabel lblFirstName = new JLabel("first name");lblFirstName.setBounds(153, 50, 81, 21);frmStaffInformation.getContentPane().add(lblFirstName);textField_first = new JTextField();textField_first.setBounds(218, 47, 71, 21); frmStaffInformation.getContentPane().add(textField_first); textField_first.setColumns(10);JLabel lblMi = new JLabel("mi");lblMi.setBounds(299, 50, 37, 15);frmStaffInformation.getContentPane().add(lblMi);textField_mi = new JTextField();textField_mi.setBounds(322, 47, 46, 21);frmStaffInformation.getContentPane().add(textField_mi); textField_mi.setColumns(10);JLabel lblAddress = new JLabel("address");lblAddress.setBounds(0, 87, 59, 28);frmStaffInformation.getContentPane().add(lblAddress);textField_address = new JTextField();textField_address.setBounds(47, 91, 187, 24); frmStaffInformation.getContentPane().add(textField_address); textField_address.setColumns(10);JLabel lblCity = new JLabel("city");lblCity.setBounds(0, 135, 59, 28);frmStaffInformation.getContentPane().add(lblCity);textField_city = new JTextField();textField_city.setBounds(35, 139, 108, 21); frmStaffInformation.getContentPane().add(textField_city); textField_city.setColumns(10);JLabel lblState = new JLabel("state");lblState.setBounds(169, 142, 54, 21);frmStaffInformation.getContentPane().add(lblState);textField_state = new JTextField();textField_state.setBounds(218, 139, 108, 21);frmStaffInformation.getContentPane().add(textField_state);textField_state.setColumns(10);JLabel lblTelephone = new JLabel("telephone");lblTelephone.setBounds(0, 173, 71, 21);frmStaffInformation.getContentPane().add(lblTelephone);textField_tele = new JTextField();textField_tele.setBounds(62, 170, 171, 21);frmStaffInformation.getContentPane().add(textField_tele);textField_tele.setColumns(10);JButton btnView = new JButton("view");btnView.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent e) {id=textField_id.getText();//找出该id并且显示出来；//load the jdbs drivertry {Class.forName("com.mysql.jdbc.Driver");} catch (ClassNotFoundException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}System.out.println("Driver loaded");//Establish a connectionConnection connection = null;Statement statement = null;ResultSet resultSet = null;PreparedStatement preparedStatement =null;String sta=null;try {connection = DriverManager.getConnection("jdbc:mysql://localhost/first_schema","root","a6590048");System.out.println("database connected");//create a statement//参数化sta="select * from Staff where id=?;";preparedStatement =connection.prepareStatement(sta);preparedStatement.setString(1, id);ResultSet rset=preparedStatement.executeQuery();/*statement = connection.createStatement();//execute a statementresultSet = statement.executeQuery("select * from Staff where id=?");//中文不可以//iterate through the result and print the student names* */while(rset.next()){textField_id.setText(rset.getString(1));textField_last.setText(rset.getString(2));textField_first.setText(rset.getString(3));textField_mi.setText(rset.getString(4));textField_address.setText(rset.getString(5));textField_city.setText(rset.getString(6));textField_state.setText(rset.getString(7));textField_tele.setText(rset.getString(8));}//close the connectionconnection.close();} catch (SQLException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}}});btnView.setBounds(-2, 233, 93, 23);frmStaffInformation.getContentPane().add(btnView);JButton btnInsert = new JButton("insert");btnInsert.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent arg0) {id=textField_id.getText();last=textField_last.getText();first=textField_first.getText();mi=textField_mi.getText();address=textField_address.getText();city=textField_city.getText();state=textField_state.getText();tele=textField_tele.getText();//load the jdbs drivertry {Class.forName("com.mysql.jdbc.Driver");} catch (ClassNotFoundException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}System.out.println("Driver loaded");//Establish a connectionConnection connection = null;Statement statement = null;ResultSet resultSet = null;PreparedStatement preparedStatement =null;String sta=null;try {connection = DriverManager.getConnection ("jdbc:mysql://localhost/first_schema","root","a6590048");System.out.println("database connected");//create a statement//参数化sta="INSERT INTO `first_schema`.`staff` (`id`,`lastName`, `firstName`,"+ " `mi`, `address`, `city`, `state`, `telephone`)"+ " VALUES (?, ?, ?, ?, ?, ?, ?,?);";preparedStatement =connection.prepareStatement(sta);preparedStatement.setString(1, id);preparedStatement.setString(2, last);preparedStatement.setString(3, first);preparedStatement.setString(4, mi);preparedStatement.setString(5, address);preparedStatement.setString(6, city);preparedStatement.setString(7, state);preparedStatement.setString(8, tele);System.out.print( preparedStatement.executeUpdate());/*statement = connection.createStatement();//execute a statementresultSet = statement.executeQuery("select * from Staff where id=?");//中文不可以//iterate through the result and print the student names* *///close the connectionconnection.close();} catch (SQLException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}}});btnInsert.setBounds(90, 233, 93, 23);frmStaffInformation.getContentPane().add(btnInsert);JButton btnUpdate = new JButton("update");btnUpdate.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent e) {id=textField_id.getText();last=textField_last.getText();first=textField_first.getText();mi=textField_mi.getText();address=textField_address.getText();city=textField_city.getText();state=textField_state.getText();tele=textField_tele.getText();id=textField_id.getText();//找出该id并且显示出来；//load the jdbs drivertry {Class.forName("com.mysql.jdbc.Driver");} catch (ClassNotFoundException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}System.out.println("Driver loaded");//Establish a connectionConnection connection = null;Statement statement = null;ResultSet resultSet = null;PreparedStatement preparedStatement =null;String sta=null;try {connection = DriverManager.getConnection ("jdbc:mysql://localhost/first_schema","root","a6590048");System.out.println("database connected");//create a statement//参数化sta="UPDATE `first_schema`.`staff`"+ " SET lastName=?, firstName=?,mi=? ,address=?,city=?,state=? ,telephone=? "+ "WHERE id=?;";preparedStatement =connection.prepareStatement(sta);preparedStatement.setString(1, last);preparedStatement.setString(2, first);preparedStatement.setString(3, mi);preparedStatement.setString(4, address);preparedStatement.setString(5, city);preparedStatement.setString(6, state);preparedStatement.setString(7, tele);preparedStatement.setString(8, id);System.out.print( preparedStatement.executeUpdate());/*statement = connection.createStatement();//execute a statementresultSet = statement.executeQuery("select * from Staff where id=?");//中文不可以//iterate through the result and print the student names* *///close the connectionconnection.close();} catch (SQLException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}}});btnUpdate.setBounds(181, 233, 93, 23);frmStaffInformation.getContentPane().add(btnUpdate);JButton btnClear = new JButton("clear");btnClear.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) {//清空格信息。