preparedStatementTest.jsp > MODEL

• 목록

<%@ page language="java" contentType="text/html; charset=UTF-8"%>

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

<%

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

String url="jdbc:mysql://localhost:3306/test?serverTimezone=UTC";

String user="root";

String password="1111";

Connection conn = null; 

PreparedStatement pstmt = null;

String sql="INSERT INTO student (num,name) VALUES (?,'홍길동')";

try {

conn=DriverManager.getConnection(url, user, password);

   pstmt=conn.prepareStatement(sql);

   for(int i=8;i<=11;i++){

   pstmt.setInt(1,i);

   if(pstmt.executeUpdate()!=0){

   out.println("<h3>"+i+"번 레코드를 등록하였습니다.</h3>");

   }

   }

}catch(Exception e){

out.println("<h3>레코드 등록에 실패하였습니다.</h3>");

e.printStackTrace();

  }

finally{

try{

pstmt.close();

conn.close();

}

catch(Exception e){

e.printStackTrace();

}

}

%>