修改conf目录下的Tomcat\context.xml�/p>
Xml代ç
- <?xml version='1.0' encoding='utf-8'?>
- <Context reloadable="true">
- <WatchedResource>WEB-INF/web.xml</WatchedResource>
- <Resource name="jdbc/al" auth="Container" type="javax.sql.DataSource"
- maxActive="100" maxIdle="30" maxWait="10000"
- username="root" password="xxxxxx" driverClassName="com.mysql.jdbc.Driver"
- url="jdbc:mysql://192.168.0.9:3306/al"/>
- </Context>
注æ„讄¡½®mysql用户æƒé™åQŒéœ€è¦è¿œ½E‹è®¿é—®æƒé™ã€?/p>
å¯èƒ½éœ€è¦è®¾¾|®æˆtomcat所在主机ip能访问的æƒé™ã€?/p>
Java下获å–æ•°æ®æº
Java代ç
- Context ctx = new InitialContext();
- DataSource ds = (DataSource) ctx.lookup("java:comp/env/jdbc/al");
- conn = ds.getConnection();
]]>