sevlet显示mysql数据_Servlet中连接数据库并显示

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("

out.print("

名字主人年龄出生日期");

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("

");//从pet中获取value

out.println("

"+ rs.getString("name") + "");

out.println("

"+ rs.getString("owner") + "");

out.println("

"+ rs.getString("age") + "");

out.println("

"+ rs.getString("birth") + "");

out.println("

");

}

out.println("

");

}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();

}

}

}

}