DBCP 설정하기 JSP+MySql+Tomcat9.0

<목차로 돌아가기>

DBCP 전혀! 어렵지 않아요( 6시간동안 삽질했음...ㅡ_ㅡ...)

아래 파일을 tomcat 9.0\lib에 넣어줍니다.

commons-collections4-4.1.jar

commons-dbcp2-2.1.1.jar

commons-pool2-2.4.2.jar

mysql-connector-java-5.1.38-bin.jar

tomcat 9.0\webapps\ROOT\WEB-INF\web.xml 소스입니다.

web.xml

<web-app xmlns="http://java.sun.com/xml/ns/j2ee"

    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

    xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee

http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"

    version="2.4">

  <description>MySQL Test App</description>

  <resource-ref>

<res-ref-name>jdbc/ylhome</res-ref-name>

<res-type>javax.sql.DataSource</res-type>

<res-auth>Container</res-auth>

  </resource-ref>

</web-app>

tomcat 9.0\conf\context.xml 소스입니다.

context.xml

  <Resource name="jdbc/ylhome" auth="Container" type="javax.sql.DataSource"

driverClassName="com.mysql.jdbc.Driver"

loginTimeout="10" maxWait="5000"

username="계정이름을 적으세요" password="계정비번적으세요"

url="jdbc:mysql://localhost:3306/db이름을 적으세요"/>

</Context>

tomcat 9.0\webapps\ROOT\exam.jsp 소스입니다.

exam.jsp

<%@ page language="java" contentType="text/html" pageEncoding="EUC-KR" %>

<%@ page import="java.sql.*" %>

<%@ page import="javax.sql.*,java.sql.*,javax.naming.*" %>

<%

Connection myconn=null;

Statement st=null;

ResultSet rs=null;

try{

Context fcontext=new InitialContext();

//Context envcontext=(context)fcontext.lookup("java:/comp/env");

//Datasource ds=(Datasource)envcontext.lookup("jdbc/db이름");

DataSource ds=(DataSource)fcontext.lookup("java:/comp/env/jdbc/db이름");

myconn=ds.getConnection();

String q1="select * from member";

st=myconn.createStatement();

st.executeQuery(q1);

rs=st.executeQuery(q1);

rs.first();

// while(rs.next());

// {

String g_name=rs.getString("name");

String g_id=rs.getString("id");

String g_pw=rs.getString("pw");

%>

<%=g_name%>

<%=g_id%>

<%=g_pw%>

<%

// }

}

finally{

if(rs !=null) try{rs.close();} catch(SQLException err){}

if(st !=null) try{st.close();} catch(SQLException err){}

if(myconn !=null) try{myconn.close();} catch(SQLException err){}

}

%>

끝! 겁나쉽죠? ㅠ_ㅠ... 아 눙물