|
1、在WL建立一个Connection Pools，可以测试的
2、再建立一个DataSource，其Pool Name指向刚才配置的Connection Pools，给这个DataSource的JNDI名指定为“MysqlPool“
3、建立客户端测试程序
package com.catmiw.testmysql;
import javax.naming.*;
import javax.sql.DataSource;
import java.sql.*;
import java.util.Properties;
public class MysqlPool {
private static Context getInitialContext() throws Exception {
String url = "t3://localhost:7001";
String user = null;
String password = null;
Properties properties = null;
try {
properties = new Properties();
properties.put(Context.INITIAL_CONTEXT_FACTORY,
"weblogic.jndi.WLInitialContextFactory");
properties.put(Context.PROVIDER_URL, url);
if (user != null) {
properties.put(Context.SECURITY_PRINCIPAL, user);
properties.put(Context.SECURITY_CREDENTIALS,
password == null ? "" : password);
}
return new InitialContext(properties);
}
catch (Exception e) {
System.out.println("Unable to connect to WebLogic server at " + url);
System.out.println("Please make sure that the server is running.");
throw e;
}
}
public static void main(String args[]) throws Exception {
Context ctx = getInitialContext(); //得到初始化上下文
Object obj = ctx.lookup("MysqlPool");//查找连接池
DataSource ds = (DataSource) obj;//转换成DataSource
try {
Connection connect = ds.getConnection();//从连接池中得到一个连接
System.out.println("Success connect Mysql Connection Pool!");
Statement stmt = connect.createStatement();
ResultSet rs = stmt.executeQuery("select * from pet");
while (rs.next()) {
System.out.println(rs.getString("name"));
}
}
catch (Exception e) {
System.out.print("get data error!");
e.printStackTrace();
}
}
}
运行结果：
Success connect Mysql Connection Pool!
[MySql]PHP存取 Mysql 数据乱码终极解决方案 [MySql]解决Table xxx is marked as crashed and should …
[MySql][MySQL]快速解决"is marked as crashed and shoul… [MySql]MySQL DELETE语法用法详解
[MySql]mysql中时间日期格式化 [MySql]修改mysql导入文件大小限制
[其他]MySql常用命令大全 [Web开发]把ACCESS的数据导入到Mysql中的方法详解
[MySql]解决mysql 1040错误Too many connections的方法 [系统软件]利用crontab系统每天定时备份MySQL数据库
| 
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
