IT ProjectTeamB

package driverdb;    //package명 미정 추후 수정함.

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

public class driverdbconn {

public Connection driverDbcon() throws ClassNotFoundException{

System.out.println("★ driverDbcon() : driverloading, dbconnection 성공 in driverDbcon()");

Connection conninmethod = null;

Class.forName("com.mysql.jdbc.Driver");

String jdbcDriver = "jdbc:mysql://umj64-003.cafe24.com:3306/xkgunjh?" +

"useUnicode=true&characterEncoding=utf-8";

String dbUser = "xkgunjh";

String dbPass = "********";      //패스워드 비공개

try {

conninmethod = DriverManager.getConnection(jdbcDriver, dbUser, dbPass);

}catch(SQLException e) {

e.printStackTrace();

}

return conninmethod;

}

}

//DriverManager import

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

//Connection import

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

<%

//request Encoding 타입 정하기

request.setCharacterEncoding("euc-kr");

//oracle Driver로딩

Class.forName("oracle.jdbc.OracleDriver");

//Connection Type의 conn변수 선언 및 초기화 NULL

Connection conn = null;

//02단계 :DB연결(Connection)시작

  String jdbcDriver = "jdbc:oracle:thin:@localhost:1521:XE";

// 오라클 db사용자 아이디

String dbUser = "dev11id";

// 오라클 db사용자 패스워드

String dbPass = "dev11pw";

//conn변수에 Driverloading 정보와 connection 정보 담기

conn = DriverManager.getConnection(jdbcDriver, dbUser, dbPass);

%>

// sendRedirect 붉은색 폴더명 및 파일 명 변경하여 원하는 페이지로 이동

response.sendRedirect(request.getContextPath()+"/oracle_list/list.jsp");

<%@ page import = "home.work.java.driveranddb" %>

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

<%

driveranddb dridb = new driveranddb();

Connection conn = dridb.dridbconn();

%>