1、 配置服务器(tomcat6.0),
配置的路径D:/Program Files/Apache Software Foundation/Tomcat 6.0
2、 将4个驱动包放入
D:/Program Files/Apache Software Foundation/Tomcat 6.0/lib
3、 配置Context.xml
<!-- The contents of this file will be loaded for each web application --> <Context>
<!-- Default set of monitored resources --> <WatchedResource>WEB-INF/web.xml</WatchedResource>
<Resource name="jdbc/sqlserver" type="javax.sql.DataSource" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" maxIdle="2" maxWait="5000" username="sa" password="" url="jdbc:sqlserver://localhost:1433;databaseName=zf" maxActive="4"/> </Context> |
Web.xml
<resource-ref> <res-ref-name>jdbc/sqlserver</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> |
4、 关闭sqlserver2000,启动sqlserver2005
都占用1433端口
5、开发前导入数据库
附加数据
6、正常开发
数据访问代码
protected Connection getConn(){ Connection connect=null; try { System.out.println("打开连接"); Context initCtx = new InitialContext(); Context envCtx = (Context) initCtx.lookup("java:comp/env"); DataSource ds = (DataSource)envCtx.lookup("jdbc/sqlserver"); //取得数据库连接 connect= ds.getConnection(); } catch (Exception e) { System.out.println("数据库连接错误"+e); } return connect; } |