[原创]weblogic配置连接池并显示数据_Tomcat, WebLogic及J2EE讨论区_Weblogic技术|Tuxedo技术|中间件技术|Oracle论坛|JAVA论坛|Linux/Unix技术|hadoop论坛

总帖数

每页帖数

1/1页

返回列表

发起投票

查看: 1876 | 回复: 0

主题： [原创]weblogic配置连接池并显示数据

huan.xiong

注册用户

等级：上尉
经验：508
发帖：18
精华：0
注册：1970-1-1
状态：离线
发送短消息息给huan.xiong

加好友发送短消息息给huan.xiong

发消息

发表于：

2015-7-13 11:11:43 | [全部帖] [楼主帖]

楼主

weblogic配置连接池并显示数据：
1、创建web项目：

######################################################################################################
Index.jsp
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ page import="com.landingbj.bean.*"%>
<%@ page import="com.landingbj.db.*" %>
<%@ page import="com.landingbj.dao.*" %>
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'index.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">

</head>
<body>weblogic 数据库连接池测试<br>
<tableborder="1"cellpadding="2"cellspacing="2">
<tr><td>id</td><td>name</td><td>password</td></tr>
<%
ArrayList<Student> stus=new StudentDao().getAll();
Iterator it=stus.iterator();
System.out.println("id\t\t name\t\t password");
while(it.hasNext())
{
      Student stu=(Student)it.next();
      out.print("<tr><td>"+stu.getId()+"</td><td>"+stu.getName()+"</td><td>"+stu.getPassword()+"</td><tr>");
}
%>
</body>
</html>
#################################################################
Student.java
package com.landingbj.bean;
publicclass Student {
      privateint id;
      private String name;
      private String password;
      public Student()
      {
            super();
      }
      public Student(int id,String name,String password)
      {
            this.id=id;
            this.name=name;
            this.password=password;
      }
      publicint getId()
      {
            return id;
      }
      public String getName()
      {
            return name;
      }
      public String getPassword()
      {
            return password;
      }
}
#############################################################################################################
StudentDao.java
package com.landingbj.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import com.landingbj.bean.Student;
import com.landingbj.db.DBconnect;
import com.sun.org.apache.xml.internal.resolver.Catalog;
public class StudentDao {
      private Connection conn=null;
      private PreparedStatement ps=null;
      private ResultSet rs=null;
      private Student stu=null;
      private ArrayList<Student> stus=null;
      public ArrayList<Student> getAll()
      {
            conn=DBconnect.getConn();
            stus=new ArrayList<Student>();
            try
            {
                  ps=conn.prepareStatement("select * from tb1");
                  rs=ps.executeQuery();
                  while(rs.next())
                  {
                        stu=new Student(rs.getInt(1),rs.getString(2),rs.getString(3));
                        stus.add(stu);
                  }
            }
            catch (Exception e) {
                  // TODO: handle exception
            }finally
            {
                  try
                  {
                        if(null!=rs)
                        {
                              rs.close();
                        }
                        if(null!=ps)
                        {
                              ps.close();
                        }
                        if(null!=conn)
                        {
                              conn.close();
                        }
                  }catch (Exception e) {
                  // TODO: handle exception
            }
      }
      return stus;
}
}
###################################################################################################
DBconnect.java
package com.landingbj.db;
import java.sql.Connection;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
publicclass DBconnect {
      privatestatic Connection conn;
      /**

* 连接数据库

     */
      publicstatic Connection getConn()
      {
            try
            {
                  Context ctx=new InitialContext();
                  //???是weblogic 的数据源名称
                  DataSource ds=(DataSource) ctx.lookup("pool2");
                  conn=ds.getConnection();
            }catch (Exception e)
            {
                  e.printStackTrace();
            }
            returnconn;
      }
}
#########################################################################################