eclipse servlet 连接mysql

来源：互联网发布：淘宝网四件套100元之内编辑：程序博客网时间：2024/05/21 08:44

网上方法五花八门的，我只讲一种，适用于入门的同学

servlet类+web.xml+驱动类

SelectDictionary类

package cn.servlet.beta;import java.io.IOException;import java.io.PrintWriter;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;import javax.servlet.ServletConfig;import javax.servlet.ServletException;import javax.servlet.annotation.WebServlet;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;/** * Servlet implementation class SelectDictionary */@WebServlet("/SelectDictionary")public class SelectDictionary extends HttpServlet {private static final long serialVersionUID = 1L;ServletConfig config = null;private String driverName = "";private String userName = "";private String password = "";private String dbName = "";private Connection conn;private Statement stmt;ResultSet rs = null;/** * @see HttpServlet#HttpServlet() */public SelectDictionary() {super();// TODO Auto-generated constructor stub}@Overridepublic void init(ServletConfig config) throws ServletException {// TODO Auto-generated method stubsuper.init(config);this.config = config;driverName = config.getInitParameter("driverName");userName = config.getInitParameter("userName");password = config.getInitParameter("password");dbName = config.getInitParameter("dbName");}/** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse *      response) */protected void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {// TODO Auto-generated method stubresponse.setContentType("text/html;charset=utf-8");PrintWriter out = response.getWriter();out.println("<!DOCTYPE html>"); // 实现生成静态Htmlout.println("<head>");out.println("<meta charset=\"utf-8\">");out.println("<title>DataBase Connection</title>");out.println("</head>");out.println("<body bgcolor=\"white\">");out.println("<center>");String url = "jdbc:mysql://127.0.0.1:3306/webdb";try {Class.forName("com.mysql.jdbc.Driver");conn = DriverManager.getConnection(url, userName, password);stmt = conn.createStatement();String sql = "select * from t_dictionary";rs = stmt.executeQuery(sql);out.println("Servlet访问数据库成功");out.println("<table border=1 bordercolorlight=#000000>");out.println("<tr><td width=40>english</td>");out.println("<td>chinese</td></tr>");while (rs.next()) {out.println("<tr><td>" + rs.getString(1) + "</td>");out.println("<td>" + rs.getString(2) + "</td>");out.println("</tr>");}out.println("</table>");rs.close();stmt.close();conn.close();} catch (Exception e) {e.printStackTrace();out.println(e.toString());}out.println("</center>");out.println("</body>");out.println("</html>");}/** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse *      response) */protected void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {// TODO Auto-generated method stubdoGet(request, response);}public void destory() {config = null;driverName = null;userName = null;password = null;dbName = null;conn = null;stmt = null;rs = null;}}

web.xml

<?xml version="1.0" encoding="UTF-8"?><web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1">  <display-name>servlettest</display-name>  <welcome-file-list>    <welcome-file>index.html</welcome-file>    <welcome-file>index.htm</welcome-file>    <welcome-file>index.jsp</welcome-file>    <welcome-file>default.html</welcome-file>    <welcome-file>default.htm</welcome-file>    <welcome-file>default.jsp</welcome-file>  </welcome-file-list>  <servlet>    <description>This is the description of my J2EE component</description>    <display-name>This is the display name of my J2EE component</display-name>    <servlet-name>DictionaryServlet</servlet-name>    <servlet-class>cn.servlet.beta.SelectDictionary</servlet-class>    <init-param>            <param-name>driverName</param-name>            <param-value>com.mysql.jdbc.Driver</param-value>        </init-param>        <init-param>        <param-name>userName</param-name>                        <param-value>root</param-value>                        </init-param>        <init-param>            <param-name>password</param-name>                    <param-value>root123</param-value>                        </init-param>        <init-param>            <param-name>dbName</param-name>                <param-value>webdb</param-value>            </init-param>  </servlet>    <servlet-mapping>     <servlet-name>DictionaryServlet</servlet-name>     <url-pattern>/DictionaryServlet</url-pattern>   </servlet-mapping>   </web-app>

亲测有效

总结

1.要打开mysql数据库

2.出现其他乱七八糟的 Exception 。(⊙o⊙)… 应该都是 SQL 语句之类的什么问题吧

3.修改web.xml里的数据库连接信息

0 0