<Resource removeAbandonedOnBorrow="true" removeAbandonedTimeout="10" logAbandoned="true"
name="jdbc/mysql"
auth="Container"
type="javax.sql.DataSource"
url="jdbc:mysql://127.0.0.1:4040/데이터베이스명"
driverClassName="com.mysql.jdbc.Driver"
username="데이터베이스사용자명"
password="비밀번호"
loginTimeout="10"
maxActive="100"
maxIdle="30"
maxWait="10000"
testOnBorrow="true" />
2. 클래스 생성, DB Connection을 위한 클래스
import java.sql.Connection;
import java.sql.SQLException;
import javax.sql.DataSource;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
public class DBConnection {
public static Connection getConnection() throws ClassNotFoundException, SQLException, NamingException {
Context context = new InitialContext();
DataSource ds = (DataSource) context.lookup("java:comp/env/jdbc/mysql");
Connection dbConn = ds.getConnection();
return dbConn;
}
}
3. 클래스 사용, DB Connection Class 를 이용한 실제 쿼리문 작성
Connection conn = DBConnection.getConnection();
PreparedStatement pstm = null;
ResultSet rs = null;
StringBuffer query = new StringBuffer();
query.append("쿼리문");
pstm = conn.prepareStatement(query.toString());
rs = pstm.executeQuery();
'WEB > JSP' 카테고리의 다른 글
| JSP 를 이용한 법화사 홈페이지 구축 (0) | 2019.03.27 |
|---|---|
| request.getRemoteAddr() - ipv6 (0) | 2017.08.29 |
| log4j 옵션 (0) | 2014.03.18 |