一.配置weblogic服務器
start menu->program->BEA Weblogic Platfrom 8.1->Configuration Wizard->Create a new Weblogic->next->next->next->(user password)next->(select jdk)next->(datasource)create
二.數據庫驅動配置
copy mysql-connector-java-3.1.11-bin.jar to %WL_HOME%\
在d:\SoftWare\BEA\user_projects\domains\datasource\startWebLogic.cmd的set CLASSPATH=部分加入%WL_HOME%\mysql-connector-java-3.1.11-bin.jar
三.配置數據庫連接池
1.start menu->program->BEA Weblogic Platfrom 8.1->User Projects->datasource->Start Server
2.打開http://127.0.0.1:7001/console weblogic 12345678
3.datasource->服務->JDBC->連接緩沖池(Connections Pools)->(配置新的JDBC連接緩沖池)configure a new JDBC Connection Pools
4.Database Type 選擇mysql驅動為org.gjt.mm.mysql.Driver
5.Continue
名稱:MyJDBC Connection Pool
數據庫名稱:datasource
主機名:127.0.0.1
端口:3306
數據庫用戶名:
密碼:
確認密碼:
5.Continue->Test Driver Configuration
6.Create and deploy
四.配置數據源
1.datasource->服務->JDBC->數據源(Data Source)->configure a new JDBC Data Source
2.
名稱:MyData Source
JNDI名稱:MyData Source
3.Continue->Continue->Create
------------測試代碼DSTest.java------------------------
import java.sql.*;
import javax.naming.*;
import javax.sql.*;
import java.util.Properties;
import javax.rmi.PortableRemoteObject;
public class DSTest{
?private static Context getInitialContext(){
??String URL="t3://127.0.0.1:7001";
??String user="weblogic";
??String password="12345678";
??Properties prop=null;
??Context context=null;
??
??try{
???prop = new Properties();
???prop.put(Context.INITIAL_CONTEXT_FACTORY,"weblogic.jndi.WLInitialContextFactory");
???prop.put(Context.PROVIDER_URL,URL);
???prop.put(Context.SECURITY_PRINCIPAL,user);
???prop.put(Context.SECURITY_CREDENTIALS,password);
???context = new InitialContext(prop);
??}
??catch(Exception e)
??{
???e.printStackTrace();
??}
??return context;
??}
?
?public static void main(String[] args){
??DSTest dstest = new DSTest();
??
??DataSource ds=null;
??Context ctx=null;
??Connection conn=null;
??
??try{
???ctx = getInitialContext();
???ds = (DataSource)ctx.lookup("MyData Source");
??}
??catch(Exception e){
???e.printStackTrace();
??}
??
??Statement stmt=null;
??ResultSet rs=null;
??
??try{
???conn = ds.getConnection();
???stmt = conn.createStatement();
???String sql = "select * from user";
???rs = stmt.executeQuery(sql);
???
???while(rs.next()){
????System.out.println("username : " + rs.getString("username"));
????System.out.println("password : " + rs.getString("password"));
????}
??}
??catch(SQLException e){
???e.printStackTrace();
???}
??finally{
???try{
???if(stmt != null) { stmt.close();}
???if (conn != null) { conn.close();}
???}
???catch(SQLException e){
????e.printStackTrace();
????}
??}
??}
}
--------------------------------------------------------------------------------------------
set CLASSPATH=%CLASSPATH%;weblogic.jar
javac DSTest.java
java DSTest
pause