JSP(제이에스피) mysql(마이에스큐엘) connect(접속)

12년 1월 기준.

 

<%

String DB_URL = "localhost";

String DB_USER = "user";

String DB_PWD = "pwd";

String url="jdbc:mysql://"+DB_URL;

//String url="jdbc:mysql://"+DB_URL+"/mysql?useUnicode=true&characterEncoding=utf-8";

Connection conn = null;

Statement stmt = null;

ResultSet rs = null;

try

{

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

conn = DriverManager.getConnection(DB_URL, DB_USER, DB_PWD);

stmt = conn.createStatement();

String query = "select * from db";

rs = stmt.executeQuery(SQL);

while (rs.next()) {

out.println(rs.getString(1));

}

rs.close();

conn.close();

stmt.close();

} catch(Exception e)

{

out.println(e.getMessage());

}

%>