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

最新推荐文章于 2021-10-14 08:30:00 发布

gogo_yueyue

最新推荐文章于 2021-10-14 08:30:00 发布

阅读量485

点赞数

分类专栏：数据库文章标签： Servlet PostgreSQL DAO XML Web

数据库专栏收录该内容

42 篇文章 0 订阅

订阅专栏


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>