servlet初始化配置PGPoolingDataSource(PostgreSql学习笔记5）

bco

import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import org.postgresql.ds.PGPoolingDataSource;
import com.sun.xml.internal.bind.CycleRecoverable.Context;
public class syscfgServlet extends HttpServlet {
public static PGPoolingDataSource pgpool = null;
public void destroy() {
super.destroy();
}
public void init() throws ServletException {
if(pgpool == null){
String DataSourceName=this.getInitParameter("DataSourceName");
String ServerName=this.getInitParameter("serverName");
String User=this.getInitParameter("User");
String Password=this.getInitParameter("password");
int MaxConnections=Integer.parseInt(this.getInitParameter("MaxConnections"));
String dbInstance=this.getInitParameter("dbInstance");
System.out.println(User);
System.out.println(Password);
pgpool = new PGPoolingDataSource();
pgpool.setDataSourceName(DataSourceName);
pgpool.setServerName(ServerName);
pgpool.setDatabaseName(dbInstance);
pgpool.setUser(User);
pgpool.setPassword(Password);
pgpool.setMaxConnections(MaxConnections);
}
}
}

web.xml配置

<servlet>
<servlet-name>syscfgServlet</servlet-name>
<servlet-class>DAO.syscfgServlet</servlet-class>
<init-param>
<param-name>DataSourceName</param-name>
<param-value>First Source</param-value>
</init-param>
<init-param>
<param-name>MaxConnections</param-name>
<param-value>10</param-value>
</init-param>
<init-param>
<param-name>serverName</param-name>
<param-value>localhost</param-value>
</init-param>
<init-param>
<param-name>dbInstance</param-name>
<param-value>mydb_1</param-value>
</init-param>
<init-param>
<param-name>password</param-name>
<param-value>1234</param-value>
</init-param>
<init-param>
<param-name>User</param-name>
<param-value>postgres</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>syscfgServlet</servlet-name>
<url-pattern>/servlet/syscfg</url-pattern>
</servlet-mapping>