https://www.apache.org/dist/commons/dbcp/binaries/
https://www.apache.org/dist/commons/pool/binaries/
https://www.apache.org/dist/commons/logging/binaries/
DBUtil.java
package util;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.Properties;
import javax.sql.DataSource;
import org.apache.commons.dbcp2.BasicDataSource;
public class DBUtil {
private static final String DB_DRIVER_CLASS="driver.classname";
private static final String DB_URL="db.url";
private static final String DB_USERNAME="db.username";
private static final String DB_PASSWORD="db.password";
private static Properties properties = null;
// org.apache.commons.dbcp2.BasicDataSource으로 사용
private static BasicDataSource dataSource;
static {
try {
//System.out.println(DBUtil.class.getResource("").getPath());
properties = new Properties();
//properties.load(new FileInputStream(DBUtil.class.getResourceAsStream("/db.properties")));
InputStream in = DBUtil.class.getResourceAsStream("/db.properties");
properties.load(in);
dataSource = new BasicDataSource();
dataSource.setDriverClassName(properties.getProperty(DB_DRIVER_CLASS));
dataSource.setUrl(properties.getProperty(DB_URL));
dataSource.setUsername(properties.getProperty(DB_USERNAME));
dataSource.setPassword(properties.getProperty(DB_PASSWORD));
dataSource.setMinIdle(100);// 최소100개
dataSource.setMaxIdle(1000); // 최대 1000개
}
catch(IOException e) {
e.printStackTrace();
}
}
public static DataSource getDataSource() {
return dataSource;
}
}
emplist.jsp
<%@ page language="java" contentType="text/html; charset=EUC-KR"
pageEncoding="EUC-KR"%>
<%@ page import="java.sql.*, util.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=EUC-KR">
<title>Insert title here</title>
</head>
<body>
<%
// java7 try with resources auto close
try(Connection connection = DBUtil.getDataSource().getConnection();
Statement st = connection.createStatement();
){
String sql = "select * from employees";
ResultSet rs = st.executeQuery(sql);
out.println("<table><tr>"+
"<th>EMPLOYEE_ID</th>"+
"<th>FIRST_NAME</th>"+
"<th>LAST_NAME</th>"+
"<th>EMAIL</th>"+
"<th>PHONE_NUMBER</th>"+
"<th>HIRE_DATE</th>"+
"<th>JOB_ID</th>"+
"<th>SALARY</th>"+
"<th>COMMISSION_PCT</th>"+
"<th>MANAGER_ID</th>"+
"<th>DEPARTMENT_ID</th>"+
"</tr>");
while(rs.next()){
int empId = rs.getInt("EMPLOYEE_ID");
String firstName= rs.getString("FIRST_NAME");
String lastName = rs.getString("LAST_NAME");
String email = rs.getString("EMAIL");
String phoneNumber = rs.getString("PHONE_NUMBER");
//String hireDate = rs.getString("HIRE_DATE");
Date hireDate = rs.getDate("HIRE_DATE");
String jobId = rs.getString("JOB_ID");
String salary = rs.getString("SALARY");
String commissonPct = rs.getString("COMMISSION_PCT");
String managerId = rs.getString("MANAGER_ID");
String departmentId = rs.getString("DEPARTMENT_ID");
out.println("<tr>"+
"<td>"+empId+"</td>"+
"<td>"+firstName+"</td>"+
"<td>"+lastName+"</td>"+
"<td>"+email+"</td>"+
"<td>"+phoneNumber+"</td>"+
"<td>"+hireDate+"</td>"+
"<td>"+jobId+"</td>"+
"<td>"+salary+"</td>"+
"<td>"+commissonPct+"</td>"+
"<td>"+managerId+"</td>"+
"<td>"+departmentId+"</td>"+
"</td></tr>");
}
out.println("</table>");
}
catch(Exception e){
e.printStackTrace();
}
%>
</body>
</html>
'개발속이야기 > Java' 카테고리의 다른 글
| JSP JSTL 예제 (0) | 2018.01.03 |
|---|---|
| JSP EL 예제 (0) | 2018.01.03 |
| JSP 몸체를 가진 커스텀태그 (0) | 2018.01.03 |
| 이클립스 (Eclipse)에서 자동 들여쓰기 (Indentation) , Import 지우기 (0) | 2018.01.02 |
| JSP TAG OlympicTag 예제 (0) | 2018.01.02 |