member/insert.jsp > JSP2

• 목록

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

<%@ include file="/include/header.jsp" %>

<%

request.setCharacterEncoding("utf-8"); //한글 깨짐 방지

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

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

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

String email = request.getParameter("mb_email");

String sql = "insert into member (m_id,m_pass,m_name,m_email) values ('"+id+"','"+passwd+"','"+name+"','"+email+"') ";

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

Statement stmt = conn.createStatement();

stmt.executeUpdate(sql);

stmt.close();

conn.close();

%>

<script>

location.href="/";

</script>