如题所述
JAVA Webå¼åä¸ä¸æ°æ®åºçè¿æ¥æä½ï¼é
ç½®ï¼
1ãæ°å»ºæ°æ®åºã
æ°å»ºç»å½è§è²ï¼å¨æ°å»ºæ°æ®åºçæ¶åææ°æ®åºçæææ交ç»ä½ æ°å»ºçè§è²ãç¨ç¨æ·åå¯ç æ§å¶æ°æ®åºãä¿è¯æ°æ®åºçå®å ¨ã
2ãç¼åcontext.xmlæ件 Xmlæ件çç®çæ¯å°è£ ç¨æ·åå¯ç ï¼ä¹æ¯å°è£ çä¸ç§ï¼æ¹ä¾¿æä½ã
以ä¸ä¸ºcontext.xmlæä»¶æ ·ä¾ï¼
<?xml version="1.0" encoding="utf-8"?>
<Context reloadable = "true">
<Resource
name="jdbc/sampleHS"
type="javax.sql.DataSource"
maxActive="14"
maxIdle="10"
username="hstaoshu"
maxWait="5000"
driverClassName="org.postgresql.Driver"
password="hstaoshu"
url="jdbc:postgresql://localhost:5432/hstaoshu"/>
</Context>
详ç»è¯´æï¼
name="jdbc/sampleHS"éé¢çssampHSæ¯å¯æ¹å称ï¼å»ºè®®æ ¹æ®éè¦èªå·±å½åï¼
username="hstaoshu"
password="hstaoshu"æ¤ä¸¤é¡¹ä¸ºä½ æ°å»ºçæ°æ®åºç»å½è§è²ç¨æ·ååå¯ç ä¿¡æ¯ï¼åªæå¹é äºæè½è®¿é®ãè¿éç®å为äºè¡¨ç¤ºï¼æç¨æ·ååå¯ç å¼æäºè·æ°æ®åºååä¸æ ·ãå ¶å®è¿æ¯å¾ä¸å®å ¨çã
url="jdbc:postgresql://localhost:5432/hstaoshu"/>
è¿æ¯è¿æ¥æ°æ®åºçURl,å°±å访é®ç½ç«çå°åä¸æ ·ã没æè¿ä¸ªæ¯æ æ³è®¿é®æ°æ®åºçãlocalhost:5432表示æ¬å°ç«¯å£ãä¸è¬ä¸éè¦æ¹å¨ï¼å¦æä½ å¨é ç½®æ°æ®åºçæ¶åæ¹å¨è¿ç«¯å£ï¼é£ä¹ä½ éè¦æå®æ¹åæ¥ã/hstaoshuæ¯ä½ çæ°æ®åºå称ã
å ¶ä»é项请å¿æ èªæ¹å¨ã
3ãç¼åDAOç±»ã
DAOç±»çä½ç¨æ¯ä¸æ°æ®è¿æ¥åï¼å¯¹æ°æ®åºçä¸äºæä½çå°è£ ãå°è£ çä½ç¨ã为äºæ´å¥½çæ°æ®ç®¡çã
DAOæ¯çæ£å¦ä½ä½¿ç¨æ°æ®åºçå ³é®æ¥éª¤ï¼å两æ¥åªæ¯é¨ç½²åé ç½®ã
private static InitialContext context = null;
private DataSource dataSource = null;
//ä¸è¬æè·æ°æ®åºçè¿æ¥æ¾å¨DAOç±»çæé å½æ°éï¼åªè¦è¢«å®ä¾åï¼å°±è½åæ°æ®åºè¿æ¥ã
public BookDAO() {
try {
if (context == null) {
context = new InitialContext();
}
dataSource = (DataSource) context.lookup("java:comp/env/jdbc/sampleHS");
// è¿æ¥æ°æ®åºï¼åé¢å¨context.xmlæ件é ç½®éçURl
} catch (NamingException e2) {
e2.printStackTrace();
}
}
public Connection getConnection() {
Connection conn = null;
try {
conn = dataSource.getConnection();// è·å¾æ°æ®æºçè¿æ¥å¯¹è±¡
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
åå®ä¸é¢çä¸æ¥æä½ï¼å¼åç¯å¢å·²ç»å®å ¨åæ°æ®åºè¿æ¥OK,å¯ä»¥å¼å§æ°æ®åºçæä½äºãä¸è¬æ¥è¯´ï¼å¯¹æ°æ®åºçæä½è¯å¥é½æ¯æåå°è£ 好çãè¿æ ·ä¿®æ¹èµ·æ¥ä¼å¯¹ä¸é¢ç代ç å½±åéå°æå°ã
å¦ä¸ï¼
// ------------------æ°æ®åºæä½è¯å¥ä»£ç å°è£ ------------------
/* æ¥çææå¾ä¹¦ */
private static final String SELECT_ALL_SQL = "SELECT * FROM book";
é£ä¹å¨ä½¿ç¨çæ¶ååªè¦ç´æ¥è°ç¨ï¼
pstmt = conn.prepareStatement(SELECT_ALL_SQL);
1ãæ°å»ºæ°æ®åºã
æ°å»ºç»å½è§è²ï¼å¨æ°å»ºæ°æ®åºçæ¶åææ°æ®åºçæææ交ç»ä½ æ°å»ºçè§è²ãç¨ç¨æ·åå¯ç æ§å¶æ°æ®åºãä¿è¯æ°æ®åºçå®å ¨ã
2ãç¼åcontext.xmlæ件 Xmlæ件çç®çæ¯å°è£ ç¨æ·åå¯ç ï¼ä¹æ¯å°è£ çä¸ç§ï¼æ¹ä¾¿æä½ã
以ä¸ä¸ºcontext.xmlæä»¶æ ·ä¾ï¼
<?xml version="1.0" encoding="utf-8"?>
<Context reloadable = "true">
<Resource
name="jdbc/sampleHS"
type="javax.sql.DataSource"
maxActive="14"
maxIdle="10"
username="hstaoshu"
maxWait="5000"
driverClassName="org.postgresql.Driver"
password="hstaoshu"
url="jdbc:postgresql://localhost:5432/hstaoshu"/>
</Context>
详ç»è¯´æï¼
name="jdbc/sampleHS"éé¢çssampHSæ¯å¯æ¹å称ï¼å»ºè®®æ ¹æ®éè¦èªå·±å½åï¼
username="hstaoshu"
password="hstaoshu"æ¤ä¸¤é¡¹ä¸ºä½ æ°å»ºçæ°æ®åºç»å½è§è²ç¨æ·ååå¯ç ä¿¡æ¯ï¼åªæå¹é äºæè½è®¿é®ãè¿éç®å为äºè¡¨ç¤ºï¼æç¨æ·ååå¯ç å¼æäºè·æ°æ®åºååä¸æ ·ãå ¶å®è¿æ¯å¾ä¸å®å ¨çã
url="jdbc:postgresql://localhost:5432/hstaoshu"/>
è¿æ¯è¿æ¥æ°æ®åºçURl,å°±å访é®ç½ç«çå°åä¸æ ·ã没æè¿ä¸ªæ¯æ æ³è®¿é®æ°æ®åºçãlocalhost:5432表示æ¬å°ç«¯å£ãä¸è¬ä¸éè¦æ¹å¨ï¼å¦æä½ å¨é ç½®æ°æ®åºçæ¶åæ¹å¨è¿ç«¯å£ï¼é£ä¹ä½ éè¦æå®æ¹åæ¥ã/hstaoshuæ¯ä½ çæ°æ®åºå称ã
å ¶ä»é项请å¿æ èªæ¹å¨ã
3ãç¼åDAOç±»ã
DAOç±»çä½ç¨æ¯ä¸æ°æ®è¿æ¥åï¼å¯¹æ°æ®åºçä¸äºæä½çå°è£ ãå°è£ çä½ç¨ã为äºæ´å¥½çæ°æ®ç®¡çã
DAOæ¯çæ£å¦ä½ä½¿ç¨æ°æ®åºçå ³é®æ¥éª¤ï¼å两æ¥åªæ¯é¨ç½²åé ç½®ã
private static InitialContext context = null;
private DataSource dataSource = null;
//ä¸è¬æè·æ°æ®åºçè¿æ¥æ¾å¨DAOç±»çæé å½æ°éï¼åªè¦è¢«å®ä¾åï¼å°±è½åæ°æ®åºè¿æ¥ã
public BookDAO() {
try {
if (context == null) {
context = new InitialContext();
}
dataSource = (DataSource) context.lookup("java:comp/env/jdbc/sampleHS");
// è¿æ¥æ°æ®åºï¼åé¢å¨context.xmlæ件é ç½®éçURl
} catch (NamingException e2) {
e2.printStackTrace();
}
}
public Connection getConnection() {
Connection conn = null;
try {
conn = dataSource.getConnection();// è·å¾æ°æ®æºçè¿æ¥å¯¹è±¡
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
åå®ä¸é¢çä¸æ¥æä½ï¼å¼åç¯å¢å·²ç»å®å ¨åæ°æ®åºè¿æ¥OK,å¯ä»¥å¼å§æ°æ®åºçæä½äºãä¸è¬æ¥è¯´ï¼å¯¹æ°æ®åºçæä½è¯å¥é½æ¯æåå°è£ 好çãè¿æ ·ä¿®æ¹èµ·æ¥ä¼å¯¹ä¸é¢ç代ç å½±åéå°æå°ã
å¦ä¸ï¼
// ------------------æ°æ®åºæä½è¯å¥ä»£ç å°è£ ------------------
/* æ¥çææå¾ä¹¦ */
private static final String SELECT_ALL_SQL = "SELECT * FROM book";
é£ä¹å¨ä½¿ç¨çæ¶ååªè¦ç´æ¥è°ç¨ï¼
pstmt = conn.prepareStatement(SELECT_ALL_SQL);
温馨提示:答案为网友推荐,仅供参考