[jsp] jdbc- INSERT하기

<%

String id=request.getParameter("id");

String passwd = request.getParameter("password");

String name = request.getParameter("name");

Timestamp register = new Timestamp(System.currentTimeMillis());

Connection conn=null;

PreparedStatement pstmt=null;

String str="";

try{

 String jdbcURL = "jdbc:mysql://localhost:3306/test";

 String dbId="root";

 String dbPass="pass";

 

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

 conn=DriverManager.getConnection(jdbcURL,dbId,dbPass);

 

 String sql="INSERT INTO member VALUES(?,?,?,?)";

 pstmt=conn.prepareStatement(sql);

 pstmt.setString(1,id);

 pstmt.setString(2,passwd);

 pstmt.setString(3,name);

 pstmt.setTimestamp(4,register);

 pstmt.executeUpdate();

 str = "member테이블에 새로운 레코드를 추가하였습니다!";

} catch(Exception e){

 e.printStackTrace();

 str="실패했음";

} finally {

 if(pstmt != null) try{pstmt.close();}catch(SQLException sqle){}

 if(conn !=null) try{conn.close();} catch(SQLException sqle){}

}

%>