MyEclipse+WebLogic8.x+MySQL数据源的配置图解

小fish

　　

//本人参考这个鸟人写的.http://developer.iyunv.com/art/200907/136113.htm
//代码差不多的..只是在他基础上进行分层修改。。。
package com.pool.org.dao.impl;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import com.pool.org.dao.UserDao;
import com.pool.org.entity.Users;
import com.pool.org.util.DataSourceUtil;
/***
*作          者:jilongliang
*创建时间:2011-12-8
*Project:weblogic_pool
*类         名:UserDao.java
* csdn博客截图文章：[size=1em]http://blog.csdn.net/l_ji_l/article/details/7095934
*/
public class UserDaoImpl implements UserDao {
Connection conn=null;
public List getUserList() throws Exception {
conn = DataSourceUtil.getConnection();
String sql = "select * from user";
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
List list = new ArrayList();
while (rs.next()) {
Users user = new Users();
user.setId(rs.getInt("id"));
user.setPassword(rs.getString("password"));
user.setUsername(rs.getString("username"));
list.add(user);
}
return list;
}
}
package com.pool.org.util;

import java.sql.Connection;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;

/***
*作          者:龙叔
*创建时间:2011-12-22
*Project:weblogic_pool
*类         名:DataSourceUtil.java
*/
public class DataSourceUtil {
Connection conn =null;
public static Connection getConnection()throws Exception{
Context ctx = new InitialContext();
DataSource ds = (DataSource) ctx.lookup("jdbc/mysql"); //JNDI名称..
return ds.getConnection();
}

 
用Weblogic8.x（weblogic8.1以上的）web.xml配置要注意的：

http://hi.baidu.com/jilongliang/blog/item/da26c82db7844433d52af186.html


请看截图