개발 참고자료

select.jsp


==================================


<?xml version="1.0" encoding="UTF-8" ?>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.util.*, java.sql.*" %>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Insert title here</title>
</head>
<body>

<%
String DB_URL = "jdbc:mysql://localhost:3306/guess_ch?characterEncoding=utf-8";
String DB_USER = "guess_ch";
String DB_PASSWORD= "mnp0!234";
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;


try{
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWORD);


String selectQuery="select sysdate() as Date from dual"; //Select 쿼리
String updateQuery="update MEMBER set NAME = '오라클' where NAME like '이%%'"; //Update 쿼리


stmt = conn.createStatement();//Statement 생성
rs=stmt.executeQuery(selectQuery); //Select문 실행
//stmt.executeUpdate(updateQuery); //Update문 실행


while(rs.next()){
out.println(rs.getString("Date"));
}
}
catch (Exception ex){
out.println(ex.getMessage());
ex.printStackTrace();
}
finally{
if(rs!=null)try{rs.close();}catch(SQLException ex){}
if(stmt!=null)try{stmt.close();}catch(SQLException ex){}
if(conn!=null)try{conn.close();}catch(SQLException ex){}
}


//반환은 rs, stmt, conn 순서대로



%>

</body>
</html>