JDBC连接数据库、拦截器

最新推荐文章于 2024-07-11 14:29:34 发布

x9879628

最新推荐文章于 2024-07-11 14:29:34 发布

阅读量1.5k

点赞数

分类专栏： JDBC 文章标签： JDBC Oracle Java Servlet SQL

本文链接：https://blog.csdn.net/x9879628/article/details/83921922

版权

JDBC 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

===JDBC===


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;


/**
 * @author Administrator
 *
 */
public class DBUtils {
	private static final  String  CONN_URL="jdbc:oracle:thin:@127.0.0.1:1521:orcl";
	private static final  String  USERNAME="user";
	private static final  String  PASSWORD="pwd";
	private static final  String  DRIVERCLASS="oracle.jdbc.driver.OracleDriver";

	/*
	private static final  String  CONN_URL="jdbc:jtds:sqlserver://127.0.0.1:1433/testdb2";
	private static final  String  USERNAME="sa";
	private static final  String  PASSWORD="123456";
	private static final  String  DRIVERCLASS="net.sourceforge.jtds.jdbc.Driver";*/


	private static final  DBUtils INSTANCE=new DBUtils();

	private DBUtils() {
		super();
	}

	public static DBUtils getInstance()
	{
		return INSTANCE;
	}

	/*
	 * 获得连接
	 */
	public Connection getConnection()
	{
		Connection con=null;
		try {

			//con = DriverManager.getConnection("proxool.account-ds");//获取连接池的

			Class.forName(DRIVERCLASS);
			con=DriverManager.getConnection(CONN_URL, USERNAME, PASSWORD);
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return con;

	}

	/**
	 * 释放资源
	 * @param con
	 * @param pstmt
	 * @param rset
	 */
	public void releaseRes(Connection con,PreparedStatement pstmt,ResultSet rset)
	{
		try{		
		   if(rset!=null)	rset.close();
		   if(pstmt!=null)  pstmt.close();
		   if(con!=null)    con.close();

		}catch(SQLException e)
		{
			e.printStackTrace();
		}
	}

}

====web.xml===


<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://java.sun.com/xml/ns/javaee 
	http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">

	<servlet>
		<servlet-name>ServletConfigurator</servlet-name>
		<servlet-class>
			org.logicalcobwebs.proxool.configuration.ServletConfigurator
		</servlet-class>
		<init-param>
			<param-name>xmlFile</param-name>
			<param-value>WEB-INF/proxool.xml</param-value>
		</init-param>
		<load-on-startup>1</load-on-startup>
	</servlet>


    <filter>
    <filter-name>RightFilter</filter-name>
    <filter-class>com.RightFilter</filter-class>
    </filter>

  <filter-mapping>
    <filter-name>RightFilter</filter-name>
    <url-pattern>/action/*</url-pattern>
  </filter-mapping>

  <!--访问权限-->
	<security-constraint>
		<web-resource-collection>
			<web-resource-name>jsps</web-resource-name>
			<url-pattern>/jsps/*</url-pattern>
		</web-resource-collection>
		<auth-constraint />
	</security-constraint>

	<login-config>
		<auth-method>BASIC</auth-method>
	</login-config>

	<welcome-file-list>
		<welcome-file>index.jsp</welcome-file>
	</welcome-file-list>

</web-app>

===proxool.xml===


<?xml version="1.0" encoding="utf-8"?>
<!-- the proxool configuration can be embedded within your own application's.
Anything outside the "proxool" tag is ignored. -->
<something-else-entirely>
  <proxool>
    <alias>account-ds</alias>
    <driver-url>jdbc:oracle:thin:@127.0.0.1:1521:orcl</driver-url>
    <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
    <driver-properties>
      <property name="user" value="user"/>
      <property name="password" value="pwd"/>
    </driver-properties>
    <maximum-connection-count>10</maximum-connection-count>
    <house-keeping-test-sql>select * from dual</house-keeping-test-sql>
  </proxool>
</something-else-entirely>

===RightFilter.java==


import java.io.IOException;
import javax.servlet.Filter;
import javax.servlet.FilterChain;
import javax.servlet.FilterConfig;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.account.web.controller.ControllerUtils;

public class RightFilter implements Filter {

	public void destroy() {
		// TODO Auto-generated method stub

	}

	public void doFilter(ServletRequest request, ServletResponse response,
			FilterChain chain) throws IOException, ServletException {

		HttpServletRequest req = (HttpServletRequest)request;
		Object user = req.getSession().getAttribute("loginedUser");

		//如果用户为空，返回登录界面
		if(user==null)
		{
			((HttpServletResponse)response).sendRedirect(ControllerUtils.getBasePath(req) + "security?act=login");
		}
		else
		{
			chain.doFilter(request, response);
		}
	}

	public void init(FilterConfig arg0) throws ServletException {
		// TODO Auto-generated method stub

	}

}