Servlet初始化参数演示例子[源代码]

package com.accp.servlet; import java.io.IOException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; public class TestServlet extends HttpServlet { private static final long serialVersionUID = -2075359929978642725L; public void init() throws ServletException { // Put your code here } public void destroy() { super.destroy(); // Just puts "destroy" string in log // Put your code here } public void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html"); // = "sun.jdbc.odbc.JdbcOdbcDriver"; String strClassName = this.getInitParameter("a"); // = "jdbc:odbc:test"; String strConnection = this.getInitParameter("b"); // = "sa"; String strDbaName = this.getInitParameter("c"); // = ""; String strDbaPass = this.getInitParameter("d"); try { Class.forName(strClassName); Connection con = DriverManager.getConnection(strConnection, strDbaName, strDbaPass); Statement stat = con.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); ResultSet rs = stat.executeQuery("select * from userinfo"); while (rs.next()) { for (int i = 1; i <= rs.getMetaData().getColumnCount(); i++) { System.out.print(rs.getString(i) + "\t"); } System.out.println(); } rs.close(); stat.close(); con.close(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } } }