è¿æ¥å
建ç«ä¸äºè¿æ¥ï¼å¹¶ä¸è¿äºè¿æ¥å
许å
±äº«ï¼å æ¤è¿æ ·å°±èçäºæ¯æ¬¡è¿æ¥çæ¶é´å¼éãMysqlæ°æ®åºä¸ºä¾ï¼è¿æ¥æ± å¨Tomcatä¸çé
ç½®ä¸ä½¿ç¨ã
1ãå建æ°æ®åºStudent,表student
2ãé
ç½®server.xmlæ件ãTomcatå®è£
ç®å½ä¸confä¸server.xmlæ件ã
<GlobalNamingResources>
<Resource
name="jdbc/DBPool"
type="javax.sql.DataSource"
password=""
driverClassName="com.mysql.jdbc.Driver"
maxIdle="2"
maxWait="5000"
username="root"
url="jdbc:mysql://localhost:3306/student"
maxActive="3"
/>
</GlobalNamingResources>
name:æå®è¿æ¥æ± çå称
type:æå®è¿æ¥æ± çç±»ï¼ä»è´è´£è¿æ¥æ± çäºå¡å¤ç
url:æå®è¦è¿æ¥çæ°æ®åº
driverClassName:æå®è¿æ¥æ°æ®åºä½¿ç¨ç驱å¨ç¨åº
username:æ°æ®åºç¨æ·å
password:æ°æ®åºå¯ç
maxWait:æå®æ大建ç«è¿æ¥çå¾
æ¶é´ï¼å¦æè¶
è¿æ¤æ¶é´å°æ¥å°å¼å¸¸
maxIdle:æå®è¿æ¥æ± ä¸è¿æ¥çæ大空é²æ°
maxActive:æå®è¿æ¥æ± æ大è¿æ¥æ°
3ãé
ç½®web.xmlæ件ã
<web-app>
<resource-ref>
<description>mysqlæ°æ®åºè¿æ¥æ± é
ç½®</description>
<res-ref-name>jdbc/DBPool</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
<res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>
</web-app>
4ãé
ç½®context.xmlæ件
ä¸server.xmlæ件æå¨çä½ç½®ç¸åã
<Context>
<ResourceLink
name="jdbc/DBPool"
type="javax.sql.DataSource"
global="jdbc/DBPool"
/>
</Context>
5ãæµè¯
DataSource pool = null;
Context env = null;
Connection conn = null;
Statement st = null;
ResultSet rs = null;
try{
env = (Context)new InitialContext().lookup("java:comp/env");
//æ£ç´¢æå®ç对象ï¼è¿åæ¤ä¸ä¸æçä¸ä¸ªæ°å®ä¾
pool = (DataSource)env.lookup("jdbc/DBPool");
//è·å¾æ°æ®åºè¿æ¥æ±
if(pool==null){out.printl("æ¾ä¸å°æå®çè¿æ¥æ± ï¼");}
con = pool.getConnection();
st = con.createStatement();
rs = st.executeQuery("select * from student");
}catch(Exception ex){out.printl(ne.toString());}
温馨提示:内容为网友见解,仅供参考