1、首先在weblogic中建立數(shù)據(jù)源jdbc/test
2、編寫訪問jdbc/test的java代碼
package com.hunau.liuyong;
import java.sql.Connection;
import java.sql.SQLException;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
public class Conn {
private Connection conn;
private DataSource ds;
public Conn() {
try {
Context initCtx = new InitialContext();
if (initCtx == null) {
throw new Exception("上下文加載失敗");
}
//獲取在weblogic中配置的“jdbc/test”數(shù)據(jù)源
ds = (DataSource) initCtx.lookup("jdbc/test");
} catch (Exception ex) {
ex.printStackTrace();
}
}
public Connection getConn() {
try {
conn = ds.getConnection();
} catch (SQLException ex) {
ex.printStackTrace();
}
return conn;
}
public void closeConn(Connection conn) {
try {
if (conn != null) {
conn.close();
conn = null;
}
} catch (SQLException ex) {
ex.printStackTrace();
}
}
}
3、action，servlet，jsp中通過Conn去獲得連接訪問數(shù)據(jù)庫的連接，其余步驟和普通jdbc操作一樣