下载一个JSP网站的源代码,使用的是mysql数据库,想把它改成sql server2000。它是使用的DAO模式,并且使用了proxool连接池。我已经把所有表都成功转到sql server里。但是不知道代码里边该咋改才能让它连上。
private static String proxool = "org.logicalcobwebs.proxool.ProxoolDriver";
private static String poolname = "proxool.mingri";
Class.forName(proxool);
con = DriverManager.getConnection(poolname);
jdbc-0.proxool.alias=mingri
jdbc-0.proxool.driver-class=com.mysql.jdbc.Driver
jdbc-0.proxool.driver-url=jdbc:mysql://127.0.0.1:3306/mingri?user=admin&password=admin&useUnicode=true
jdbc-0.proxool.maximum-connection-count=10
jdbc-0.proxool.prototype-count=4
jdbc-0.proxool.house-keeping-test-sql=SELECT CURRENT_DATE
jdbc-0.proxool.verbose=true
jdbc-0.proxool.statistics=10s,1m,1d
jdbc-0.proxool.statistics-log-level=DEBUG
jdbc-0.proxool.house-keeping-sleep-time=30000
jdbc-0.proxool.maximum-connection-lifetime=60000
jdbc-0.proxool.simultaneous-build-throttle=1
jdbc-0.proxool.overload-without-refusal-lifetime=10000
jdbc-0.proxool.maximum-active-time=50000
jdbc-0.proxool.trace=true
jdbc-0.proxool.fatal-sql-exception=ORA-1234
jdbc-0.proxool.prototype-count=2 这是里面一些连数据库的代码。
(我下的是明日科技《JSP数据库编程》里的企业网站代码)
private static String proxool = "org.logicalcobwebs.proxool.ProxoolDriver";
private static String poolname = "proxool.mingri";
Class.forName(proxool);
con = DriverManager.getConnection(poolname);
jdbc-0.proxool.alias=mingri
jdbc-0.proxool.driver-class=com.mysql.jdbc.Driver
jdbc-0.proxool.driver-url=jdbc:mysql://127.0.0.1:3306/mingri?user=admin&password=admin&useUnicode=true
jdbc-0.proxool.maximum-connection-count=10
jdbc-0.proxool.prototype-count=4
jdbc-0.proxool.house-keeping-test-sql=SELECT CURRENT_DATE
jdbc-0.proxool.verbose=true
jdbc-0.proxool.statistics=10s,1m,1d
jdbc-0.proxool.statistics-log-level=DEBUG
jdbc-0.proxool.house-keeping-sleep-time=30000
jdbc-0.proxool.maximum-connection-lifetime=60000
jdbc-0.proxool.simultaneous-build-throttle=1
jdbc-0.proxool.overload-without-refusal-lifetime=10000
jdbc-0.proxool.maximum-active-time=50000
jdbc-0.proxool.trace=true
jdbc-0.proxool.fatal-sql-exception=ORA-1234
jdbc-0.proxool.prototype-count=2 这是里面一些连数据库的代码。
(我下的是明日科技《JSP数据库编程》里的企业网站代码)
jdbc-0.proxool.driver-url=jdbc:mysql://127.0.0.1:3306/mingri?user=admin&password=admin&useUnicode=true驱动,url之类的肯定要改的
jdbc-0.proxool.alias=BBSWRH
jdbc-0.proxool.driver-class=com.microsoft.jdbc.sqlserver.SQLServerDriver
jdbc-0.proxool.driver-url=jdbc:microsoft:sqlserver://127.0.0.1;DatabaseName=pubs
jdbc-0.proxool.maximum-connection-count=100
jdbc-0.proxool.prototype-count=4
jdbc-0.proxool.house-keeping-test-sql=select CURRENT_DATE
jdbc-0.proxool.verbose=true
<servlet>
<servlet-name>ServletConfigurator</servlet-name>
<servlet-class>
org.logicalcobwebs.proxool.configuration.ServletConfigurator
</servlet-class>
<init-param>
<param-name>propertyFile</param-name>
<param-value>/WEB-INF/classes/Proxool.properties</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet>
<servlet-name>Admin</servlet-name>
<servlet-class>org.logicalcobwebs.proxool.admin.servlet.AdminServlet</servlet-class>
</servlet>
<servlet>
<servlet-name>ServletConfigurator</servlet-name>
<servlet-class>org.logicalcobwebs.proxool.configuration.ServletConfigurator</servlet-class>
<init-param>
<param-name>propertyFile</param-name>
<param-value>WEB-INF/classes/Proxool.properties</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>Admin</servlet-name>
<url-pattern>/Admin</url-pattern>
</servlet-mapping>
</web-app>这些你看哪些地方要改