java 数据库连接类_连接数据库java类

package com.org;

import java.io.IOException;

import java.io.PrintWriter;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.List;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

/**

* Servlet implementation class ConnectionTest

*/

public class ConnectionTest extends HttpServlet {

private static final long serialVersionUID = 1L;

Connection conn;

PreparedStatement ps;

ResultSet rs;

List userList = new ArrayList();

public ConnectionTest() {

super();

}

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

this.doPost(request, response);

}

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

conn = new ConnectJDBC().getConnection();

try {

ps = conn.prepareStatement("select id,name from tbl_unit_info");

rs = ps.executeQuery();

while(rs.next()){

User user = new User();

user.setId(rs.getString("id"));

user.setName(rs.getString("name"));

userList.add(user);

System.out.println("编码：" rs.getString("id"));

System.out.println("名字：" rs.getString("name"));

request.setAttribute("user", userList);

// PrintWriter pw = response.getWriter();

// pw.write(userList.toString());

}

} catch (SQLException e) {

e.printStackTrace();

}finally{

if(null != rs){

try {

rs.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

if(null != ps){

try {

ps.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

if(null != conn){

try {

conn.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

}

}