Servlet中连接数据库并显示
将jar包复制到项目lib目录下
mysql-connector-java-5.1.6-bin下载地址:
http://115.com/file/dp521sz8
mysql-connector-java-5.1.6-bin下载地址:
http://115.com/file/dp521sz8
package testConn; import java.io.IOException; import java.io.PrintWriter; 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 ShowConn extends HttpServlet { @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { Connection conn = null; Statement stmt = null; ResultSet rs = null; resp.setContentType("text/html"); resp.setCharacterEncoding("Gb2312"); PrintWriter out = resp.getWriter(); //输出流 out.println("<table border=1>"); //打印出表格 out.print("<tr><td>名字</td><td>主人</td><td>年龄</td><td>出生日期</td></tr>"); try{ Class.forName("com.mysql.jdbc.Driver"); conn = DriverManager.getConnection("jdbc:mysql://localhost/test01?user=root&password="); //test01数据库 stmt = conn.createStatement(); rs = stmt.executeQuery("select * from pet;"); //查询语句 while(rs.next()){ //每当有一条记录就输出一行 out.print("<tr>");//从pet中获取value out.println("<td>"+ rs.getString("name") + "</td>"); out.println("<td>"+ rs.getString("owner") + "</td>"); out.println("<td>"+ rs.getString("age") + "</td>"); out.println("<td>"+ rs.getString("birth") + "</td>"); out.println("</tr>"); } out.println("</table>"); }catch(ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } finally { try { if(rs != null) { rs.close(); rs = null; } if(stmt != null) { stmt.close(); stmt = null; } if(conn != null){ conn.close(); conn = null; } } catch (SQLException e) { e.printStackTrace(); } } } }