连接数据库java类
连接数据库java类
package com.org;
import java.sql.Connection;
import java.sql.DriverManager;
public class ConnectJDBC {
public String driver = "oracle.jdbc.driver.OracleDriver";
public String url = "jdbc:oracle:thin:@localhost:1521:orcl";
public String userName = "ecmp";
public String passWord ="ecmp";
Connection conn;
public Connection getConnection(){
try {
Class.forName(driver);
conn = DriverManager.getConnection(url,userName,passWord);
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
}
使用时:
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();
}
}
}
}
}