JSP Mysql INSERT, UPDATE, DELETE 소스

기본소스이다.

여기서 응용해서 사용하면됨.

String query = "insert into user values('admin','admin)";

이 쿼리에 UPDATE, DELETE, INSERT, DROP, CREATE 사용 가능

<%@ page import="java.sql.*" %>
<%@ page contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
 
    <%
        Connection conn = null;
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        
        String driver = "com.mysql.jdbc.Driver";
        String url = "jdbc:mysql://localhost:3306/bbs";
        String uid = "root";
        String upw = "wjstks";
        
        try{
            Class.forName(driver);
            conn = DriverManager.getConnection(url, uid, upw);

            String query = "insert into user values('admin','admin)";

            pstmt = conn.prepareStatement(query);
            updatecount = pstmt.executeUpdate();
            // update, delete, insert는 executrUpdate
        }

//여기부터는 노터치
        }catch(Exception e){
            e.printStackTrace();
        }finally{ //모든 자원 해제
            try{
                if(rs != null) rs.close();
                if(pstmt != null) pstmt.close();
                if(conn != null) conn.close();
            }catch(Exception e2){
                e2.printStackTrace();
            }
        }
    %>