jsp - jdbc update문 이용하기

<목차로 돌아가기>

 <%@ page contentType="text/html; charset=euc-kr"%>
<%@ page import = "java.sql.*" %>

<%

// 드라이버 로딩
Class.forName("com.mysql.jdbc.Driver");

Connection conn = null;
Statement stmt = null;
ResultSet rs = null;

try{
  String jdbcDriver= "jdbc:mysql://localhost:3306/데이터베이스이름?useUnicode=true&characterEncoding=euckr";
  String dbuser = "계정아이디";
  String dbpass = "계정비번";

  String query;
  query="update user set 필드명1=내용1, 필드명2=내용2, 필드명n=내용3 ";

  conn = DriverManager.getConnection(jdbcDriver, dbuser, dbpass);

  stmt = conn.createStatement();

  stmt.executeUpdate(query);

}
finally
{
 if (stmt != null) try {stmt.close();} catch(SQLException ex){}
 if (conn != null) try {conn.close();} catch(SQLException ex){}
}
%>