实验六 JDBC连接数据库.docx

课程 高级JAVA开发技术 _ 实验名称 实验六 JDBC连接数据库 教 师 审 批 签 字实验目的掌握JDBC连接数据库实验内容通过JDBC/ODBC桥接方式访问Oralce数据库6.G.1JDBC访问数据库6.G.2实验过程及结果实验源码：publicclass Constants {publicstatic String DRIVER = sun.jdbc.odbc.JdbcOdbcDriver;publicstatic String URL = jdbc:odbc:myscott;publicstatic String USERNAME = scott;publicstatic String PASSWORD = tiger;}import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;publicclass DBUtil {Connection conn = null;PreparedStatement pstmt = null;ResultSet rs = null;public Connection getConnection() throws ClassNotFoundException, SQLException, InstantiationException, IllegalAccessException {String DRIVER = Config.getValue(driver);String URL = Config.getValue(url);String USERNAME = Config.getValue(username);String PASSWORD = Config.getValue(password);System.out.println(DRIVER);try {Class.forName(DRIVER);conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);returnconn;} catch (Exception e) {thrownew SQLException(驱动错误或连接失败);}}public ResultSet executeQuery(String preparedSql, String[] param) {try {pstmt = conn.prepareStatement(preparedSql);if (param != null) {for (inti = i; i param.length; i++) {pstmt.setString(i + 1, param[i]);}}rs = pstmt.executeQuery();} catch (SQLException e) {e.printStackTrace();}returnrs;}publicint executeUpdate (String preparedSql, String[] param) {int num = 0;try {pstmt = conn.prepareStatement(preparedSql);if (param != null) {for (int i = 0; i param.length; i++) {pstmt.setString(i + 1, param[i]);}}num = pstmt.executeUpdate();} catch (SQLException e) {e.printStackTrace();}return num;}publicvoid closeAll() {if (rs != null) {try {rs.close();} catch (SQLException e) {e.printStackTrace();}}if (pstmt != null) {try {pstmt.close();} catch (SQLException e) {e.printStackTrace();}}if (conn != null) {try {conn.close();} catch (SQLException e) {e.printStackTrace();}}}}package com.haiersoft.chat.client;import javax.swing.*;import java.awt.*;import java.awt.e