Struts 数据库项目开发宝典 11

关于本系统数据库配置 本系统数据库的连接配置类，位于光盘： chapter 11\project\WEB-INF\src\org\helpsoft\helplog\jdbc\ResourceManager.java 内容如下： package org.helpsoft.helplog.jdbc; import java.sql.*; public class ResourceManager { private static String JDBC_DRIVER = "sun.jdbc.odbc.JdbcOdbcDriver"; private static String JDBC_URL = "jdbc:odbc:helplog"; private static String JDBC_USER = "sa"; private static String JDBC_PASSWORD = "password"; private static Driver driver = null; public static synchronized Connection getConnection() throws SQLException { if (driver == null) { try { Class jdbcDriverClass = Class.forName( JDBC_DRIVER ); driver = (Driver) jdbcDriverClass.newInstance(); DriverManager.registerDriver( driver ); } catch (Exception e) { System.out.println( "Failed to initialise JDBC driver" ); e.printStackTrace(); } } return DriverManager.getConnection( JDBC_URL, JDBC_USER, JDBC_PASSWORD ); } public static void close(Connection conn) { try { if (conn != null) conn.close(); } catch (SQLException sqle) { sqle.printStackTrace(); } } public static void close(PreparedStatement stmt) { try { if (stmt != null) stmt.close(); } catch (SQLException sqle) { sqle.printStackTrace(); } } public static void close(ResultSet rs) { try { if (rs != null) rs.close(); } catch (SQLException sqle) { sqle.printStackTrace(); } } } 本类的核心配置如下： private static String JDBC_DRIVER = "sun.jdbc.odbc.JdbcOdbcDriver"; private static String JDBC_URL = "jdbc:odbc:helplog"; private static String JDBC_USER = "sa"; private static String JDBC_PASSWORD = "password";