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

i_am_birdman

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>