Servlet连接MySQL

妖狐艹你老母 2022-08-18 01:56 18阅读 0赞

**Servlet连接MySQL获取数据库中student表的用户名和密码！**

**工具：myeclipse，mysql-connector-java-5.1.6-bin.jar（mysql驱动），tomcat。**

**先把mysql-connector-java-5.1.6-bin.jar粘贴在WebRoot—web—inf—lib下**

**servlet代码：**

package com;
 import java.io.IOException;
 import java.io.PrintWriter;
 import java.net.ConnectException;
 import java.sql.Connection;
 import java.sql.DriverManager;
 import java.sql.ResultSet;
 import java.sql.SQLException;
 import java.sql.Statement;
 //import java.sql.Statement;
 import javax.servlet.ServletException;
 import javax.servlet.http.HttpServlet;
 import javax.servlet.http.HttpServletRequest;
 import javax.servlet.http.HttpServletResponse;
 //import com.mysql.jdbc.Connection;
 //import com.mysql.jdbc.Statement;
 
 //import com.mysql.jdbc.Connection;
 
 public class GetStudent extends HttpServlet {
 
 	/**
 	 * Constructor of the object.
 	 */
 	public GetStudent() {
 		super();
 	}
 
 	/**
 	 * Destruction of the servlet. 
 	 */
 	public void destroy() {
 		super.destroy(); // Just puts "destroy" string in log
 		// Put your code here
 	}
 
 	/**
 	 * The doGet method of the servlet. 
 	 *
 	 * This method is called when a form has its tag value method equals to get.
 	 * 
 	 * @param request the request send by the client to the server
 	 * @param response the response send by the server to the client
 	 * @throws ServletException if an error occurred
 	 * @throws IOException if an error occurred
 	 */
 	public void doGet(HttpServletRequest request, HttpServletResponse response)
 			throws ServletException, IOException {
 		String driver="com.mysql.jdbc.Driver";
 		String url="jdbc:mysql://localhost:3306/test";
 		response.setContentType("text/html");
 		PrintWriter out = response.getWriter();
 		out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
 		out.println("<HTML>");
 		out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
 		out.println(" <BODY>");
 		try {
 			Class.forName(driver);
 			Connection conn=DriverManager.getConnection(url);
 			Statement stmt=conn.createStatement();
 			ResultSet rs=stmt.executeQuery("select *from student");
 			while(rs.next())
 			{
 				out.print("id:"+rs.getInt(1)+" ");
 				out.print("name:"+rs.getString(2)+" ");
 				out.print("password:"+rs.getString(3)+" ");
 			}
 			if(rs!=null)
 				rs.close();
 			if(stmt!=null)
 				stmt.close();
 			if(conn!=null)
 				conn.close();
 		} catch (ClassNotFoundException e) {
 			// TODO Auto-generated catch block
 			e.printStackTrace();
 		} catch (SQLException e) {
 			// TODO Auto-generated catch block
 			e.printStackTrace();
 		}		
 		out.println(" </BODY>");
 		out.println("</HTML>");
 		out.flush();
 		out.close();
 	}
 
 	/**
 	 * The doPost method of the servlet. 
 	 *
 	 * This method is called when a form has its tag value method equals to post.
 	 * 
 	 * @param request the request send by the client to the server
 	 * @param response the response send by the server to the client
 	 * @throws ServletException if an error occurred
 	 * @throws IOException if an error occurred
 	 */
 	public void doPost(HttpServletRequest request, HttpServletResponse response)
 			throws ServletException, IOException {
 			doGet(request, response);
 	}
 
 	/**
 	 * Initialization of the servlet. 
 	 *
 	 * @throws ServletException if an error occurs
 	 */
 	public void init() throws ServletException {
 		// Put your code here
 	}
 
 }