postgreSQL 连接池04

1，需要修改

图片" src="http://b99.photo.store.qq.com/psb?/10c0ddec-acfa-423e-bfa8-a420ed0f2099/EaL4MgG.Meor4o1FJCAqD.QMaPGoorH2DccdWkKxYpw!/b/YY*4Dzt6LQAAYsTUCTt6LgAA">

中的context.xml文件：

添加：

 
 
  
  <@H_404_14@Resource@H_404_14@@H_404_14@driverClassName@H_404_14@=@H_404_14@"org.postgresql.Driver"@H_404_14@@H_404_14@maxActive@H_404_14@=@H_404_14@"4"@H_404_14@@H_404_14@maxIdle@H_404_14@=@H_404_14@"2"@H_404_14@@H_404_14@maxWait@H_404_14@=@H_404_14@"50"@H_404_14@@H_404_14@@H_404_14@
  
  auth@H_404_14@=@H_404_14@"Container"@H_404_14@@H_404_14@@H_404_14@
  
  name@H_404_14@=@H_404_14@"jdbc/postg"@H_404_14@@H_404_14@password@H_404_14@=@H_404_14@"root"@H_404_14@@H_404_14@type@H_404_14@=@H_404_14@"javax.sql.DataSource"@H_404_14@@H_404_14@@H_404_14@
  
  url@H_404_14@=@H_404_14@"jdbc:postgresql://192.168.2.150:5432/postgres"@H_404_14@@H_404_14@username@H_404_14@=@H_404_14@"postgres"@H_404_14@/>@H_404_14@@H_404_14@@H_404_14@
  
  @H_404_14@

工具类：ConnUtil

 
 
  
  package@H_404_14@com.hw.util;@H_404_14@@H_404_14@
  
  @H_404_14@
  
  import@H_404_14@java.sql.Connection;@H_404_14@@H_404_14@
  
  import@H_404_14@java.sql.DriverManager;@H_404_14@@H_404_14@
  
  import@H_404_14@java.sql.sqlException;@H_404_14@@H_404_14@
  
  @H_404_14@
  
  import@H_404_14@javax.naming.Context;@H_404_14@@H_404_14@
  
  import@H_404_14@javax.naming.InitialContext;@H_404_14@@H_404_14@
  
  import@H_404_14@javax.naming.NamingException;@H_404_14@@H_404_14@
  
  import@H_404_14@javax.sql.DataSource;@H_404_14@@H_404_14@
  
  @H_404_14@
  
  public@H_404_14@@H_404_14@class@H_404_14@ConnUtil@H_404_14@@H_404_14@
  
  {@H_404_14@
  
  public@H_404_14@@H_404_14@static@H_404_14@ConnectiongetConn()@H_404_14@@H_404_14@
  
  {@H_404_14@
  
  Connectionconn=null@H_404_14@;@H_404_14@@H_404_14@
  
  try@H_404_14@@H_404_14@@H_404_14@
  
  {@H_404_14@
  
  Class.forName("org.postgresql.Driver"@H_404_14@);@H_404_14@@H_404_14@
  
  Stringurl="jdbc:postgresql://192.168.2.150:5432/postgres"@H_404_14@;@H_404_14@@H_404_14@
  
  try@H_404_14@@H_404_14@@H_404_14@
  
  {@H_404_14@
  
  conn=DriverManager.getConnection(url,"postgres"@H_404_14@,@H_404_14@"postgres"@H_404_14@);@H_404_14@@H_404_14@
  
  }@H_404_14@
  
  catch@H_404_14@(sqlExceptione)@H_404_14@@H_404_14@
  
  {@H_404_14@
  
  e.printStackTrace();@H_404_14@
  
  }@H_404_14@
  
  }@H_404_14@
  
  catch@H_404_14@(ClassNotFoundExceptione)@H_404_14@@H_404_14@
  
  {@H_404_14@
  
  e.printStackTrace();@H_404_14@
  
  }@H_404_14@
  
  @H_404_14@
  
  return@H_404_14@conn;@H_404_14@@H_404_14@
  
  }@H_404_14@
  
  public@H_404_14@@H_404_14@static@H_404_14@ConnectiongetJNDIConn(){@H_404_14@@H_404_14@
  
  Contextctx=null@H_404_14@;@H_404_14@@H_404_14@
  
  try@H_404_14@@H_404_14@@H_404_14@
  
  {@H_404_14@
  
  ctx=new@H_404_14@InitialContext();@H_404_14@@H_404_14@
  
  }@H_404_14@
  
  catch@H_404_14@(NamingExceptione1)@H_404_14@@H_404_14@
  
  {@H_404_14@
  
  e1.printStackTrace();@H_404_14@
  
  }@H_404_14@
  
  Connectionconn=null@H_404_14@;@H_404_14@@H_404_14@
  
  DataSourceds=null@H_404_14@;;@H_404_14@@H_404_14@
  
  try@H_404_14@@H_404_14@@H_404_14@
  
  {@H_404_14@
  
  ds=(DataSource)ctx.lookup("java:comp/env/jdbc/postg"@H_404_14@);@H_404_14@@H_404_14@
  
  }@H_404_14@
  
  catch@H_404_14@(NamingExceptione)@H_404_14@@H_404_14@
  
  {@H_404_14@
  
  e.printStackTrace();@H_404_14@
  
  }@H_404_14@
  
  try@H_404_14@@H_404_14@@H_404_14@
  
  {@H_404_14@
  
  conn=ds.getConnection();@H_404_14@
  
  }@H_404_14@
  
  catch@H_404_14@(sqlExceptione)@H_404_14@@H_404_14@
  
  {@H_404_14@
  
  e.printStackTrace();@H_404_14@
  
  }@H_404_14@
  
  return@H_404_14@conn;@H_404_14@@H_404_14@
  
  }@H_404_14@
  
  @H_404_14@
  
  }@H_404_14@

servlet：

 
 
  
  package@H_404_14@com.hw.servlet;@H_404_14@@H_404_14@
  
  @H_404_14@
  
  import@H_404_14@java.io.IOException;@H_404_14@@H_404_14@
  
  import@H_404_14@java.io.PrintWriter;@H_404_14@@H_404_14@
  
  import@H_404_14@java.sql.Connection;@H_404_14@@H_404_14@
  
  import@H_404_14@java.sql.ResultSet;@H_404_14@@H_404_14@
  
  import@H_404_14@java.sql.sqlException;@H_404_14@@H_404_14@
  
  import@H_404_14@java.sql.Statement;@H_404_14@@H_404_14@
  
  @H_404_14@
  
  import@H_404_14@javax.servlet.ServletException;@H_404_14@@H_404_14@
  
  import@H_404_14@javax.servlet.http.HttpServlet;@H_404_14@@H_404_14@
  
  import@H_404_14@javax.servlet.http.HttpServletRequest;@H_404_14@@H_404_14@
  
  import@H_404_14@javax.servlet.http.HttpServletResponse;@H_404_14@@H_404_14@
  
  @H_404_14@
  
  import@H_404_14@com.hw.util.ConnUtil;@H_404_14@@H_404_14@
  
  @H_404_14@
  
  /**@H_404_14@@H_404_14@
  
  *ServletimplementationclassPostgreServlet@H_404_14@@H_404_14@
  
  */@H_404_14@@H_404_14@@H_404_14@
  
  public@H_404_14@@H_404_14@class@H_404_14@PostgreServlet@H_404_14@extends@H_404_14@HttpServlet{@H_404_14@@H_404_14@
  
  private@H_404_14@@H_404_14@static@H_404_14@@H_404_14@final@H_404_14@@H_404_14@long@H_404_14@serialVersionUID=1L;@H_404_14@@H_404_14@
  
  @H_404_14@
  
  /**@H_404_14@@H_404_14@
  
  *@seeHttpServlet#HttpServlet()@H_404_14@@H_404_14@
  
  */@H_404_14@@H_404_14@@H_404_14@
  
  public@H_404_14@PostgreServlet(){@H_404_14@@H_404_14@
  
  super@H_404_14@();@H_404_14@@H_404_14@
  
  }@H_404_14@
  
  @H_404_14@
  
  /**@H_404_14@@H_404_14@
  
  *@seeHttpServlet#doGet(HttpServletRequestrequest,HttpServletResponseresponse)@H_404_14@@H_404_14@
  
  */@H_404_14@@H_404_14@@H_404_14@
  
  protected@H_404_14@@H_404_14@void@H_404_14@doGet(HttpServletRequestrequest,HttpServletResponseresponse)@H_404_14@throws@H_404_14@ServletException,IOException{@H_404_14@@H_404_14@
  
  Connectionconn=ConnUtil.getJNDIConn();@H_404_14@
  
  Stringsql="select*fromstudent"@H_404_14@;@H_404_14@@H_404_14@
  
  Statementstmt=null@H_404_14@;@H_404_14@@H_404_14@
  
  ResultSetrs=null@H_404_14@;@H_404_14@@H_404_14@
  
  PrintWriterout=response.getWriter();@H_404_14@
  
  try@H_404_14@@H_404_14@@H_404_14@
  
  {@H_404_14@
  
  stmt=conn.createStatement();@H_404_14@
  
  rs=stmt.executeQuery(sql);@H_404_14@
  
  while@H_404_14@(rs.next()){@H_404_14@@H_404_14@
  
  out.println(rs.getInt(1@H_404_14@));@H_404_14@@H_404_14@
  
  }@H_404_14@
  
  }@H_404_14@
  
  catch@H_404_14@(sqlExceptione)@H_404_14@@H_404_14@
  
  {@H_404_14@
  
  e.printStackTrace();@H_404_14@
  
  }@H_404_14@
  
  }@H_404_14@
  
  @H_404_14@
  
  /**@H_404_14@@H_404_14@
  
  *@seeHttpServlet#doPost(HttpServletRequestrequest,HttpServletResponseresponse)@H_404_14@@H_404_14@
  
  */@H_404_14@@H_404_14@@H_404_14@
  
  protected@H_404_14@@H_404_14@void@H_404_14@doPost(HttpServletRequestrequest,IOException{@H_404_14@@H_404_14@
  
  doGet(request,response);@H_404_14@
  
  }@H_404_14@
  
  @H_404_14@
  
  }@H_404_14@

项目结构如下：

postgreSQL 连接池04

猜你在找的Postgre SQL相关文章