servelt2/3 config

来源：互联网发布：苹果手机频谱软件编辑：程序博客网时间：2024/06/17 11:19

今天配置servlet config把我弄惨了

一定要把数据库的驱动放在包了

如果是eclipse 可以直接放在lib

在可以找到tomcat 的lib 只是范围不同

要有init 和post（没有的话405）不知道为啥

import java.io.IOException;
import java.io.PrintStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebInitParam;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
* Servlet implementation class ServeltConfig
*/
@WebServlet(
 name="ServeltConfig",
 urlPatterns="/ServeltConfig",
 initParams=
 {
 @WebInitParam(name = "driver", value= "oracle.jdbc.driver.OracleDriver"),
 @WebInitParam(name = "url", value = "jdbc:oracle:thin:@localhost:1521:orcl"),
 @WebInitParam(name = "user", value= "scott"),
 @WebInitParam(name = "pass", value= "root")
 }
 )
public class ServeltConfig extends HttpServlet {
 private static final long serialVersionUID = 1L;

 /**
 * @see HttpServlet#HttpServlet()
 */
 public ServeltConfig() {
 super();
 // TODO Auto-generated constructor stub
 }

 /**
 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
 */
 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
 // TODO Auto-generated method stub
 }

 /**
 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
 */
 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
 // TODO Auto-generated method stub
 }
 @Override
 public void init(ServletConfig config) throws ServletException {
 // TODO Auto-generated method stub
 super.init(config);

 }

 @Override
 public void service(HttpServletRequest request, HttpServletResponse response)
 throws ServletException, IOException {
 // TODO Auto-generated method stub
 super.service(request, response);




 /* out.println(DBDRIVER+" ");
 out.println(DBURL+" ");
 out.println(DBUSER+" ");
 out.println(DBPASS+" ");
 */
 try {
 ServletConfig config=getServletConfig();

 String DBDRIVER=config.getInitParameter("driver");
 String DBURL=config.getInitParameter("url");
 String DBUSER=config.getInitParameter("user");
 String DBPASS=config.getInitParameter("pass");



 Class.forName(DBDRIVER);
 Connection conn=DriverManager.getConnection(DBURL,DBUSER,DBPASS);
 PrintStream out=new PrintStream(response.getOutputStream());
 out.print(conn+" ");
 conn.close();
 } catch (ClassNotFoundException e) {
 // TODO Auto-generated catch block
 e.printStackTrace();
 } catch (SQLException e) {
 // TODO Auto-generated catch block
 e.printStackTrace();
 }

 }

}
-------------------------------------------------------------

<servlet>

 <servlet-name>one</servlet-name>
 <servlet-class>bate.one</servlet-class>
 <init-param>
 <param-name>driver</param-name>
 <param-value>oracle.jdbc.driver.OracleDriver</param-value>
 </init-param>

 <init-param>
 <param-name>url</param-name>
 <param-value>jdbc:oracle:thin:@localhost:1521:orcl</param-value>
 </init-param>

 <init-param>
 <param-name>user</param-name>
 <param-value>scott</param-value>
 </init-param>

 <init-param>
 <param-name>pass</param-name>
 <param-value>root</param-value>
 </init-param>
</servlet>

<servlet-mapping>
 <servlet-name>one</servlet-name>
 <url-pattern>/one</url-pattern>
</servlet-mapping>

0 0