databaseservletbase.java

《j2ee应用开发祥解》一书的源代码

package com.j2ee14.ch8;

import javax.servlet.http.*;
import javax.servlet.*;
import java.io.*;
import java.sql.*;
/**
 *一个基本的Servlet，其它的需要进行数据库操作的servlet继承它
 */
public class DatabaseServletBase extends HttpServlet
{
	Connection con;
	/**
	 *Servlet初始化，获得一个数据库连接
	 */
	public void init() throws ServletException	
	{
        try
        {
        	Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
		    con=java.sql.DriverManager.getConnection("jdbc:oracle:oci8:@hellking","j2ee14","j2ee14");
		}
		catch(java.lang.IllegalAccessException e0){e0.printStackTrace();}
		catch(java.lang.ClassNotFoundException e){e.printStackTrace();}
		catch(java.lang.InstantiationException e2){e2.printStackTrace();}
		catch(java.sql.SQLException e3){ e3.printStackTrace();}		
	}
		/**
	 *销毁Servlet
	 */
	public void destroy()
	{
		if(con!=null)
		try
		{
			con.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
}