19_jsp만_insert처리_jsp
2022. 2. 2. 11:54ㆍksmart_jsp/05_jsp_mysql
728x90
| 프로젝트명 | mysqljsp |
| 회원가입화면 | m_insert_form |
| 회원가입처리 | m_insert_action |
mysql-connector-java-5.1.22-bin.jar
0.79MB
1. 회원가입화면 구현
<%@ page language="java" contentType="text/html; charset=EUC-KR"
pageEncoding="EUC-KR"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=EUC-KR">
<title>Insert title here</title>
</head>
<body>
<form action="<%=request.getContextPath()%>/minsert/m_insert_action.jsp" method="post">
<table border="1">
<tr>
<td>아이디</td>
<td><input type="text" name="m_id" size="20"></td>
<tr>
<tr>
<td>암호</td>
<td><input type="text" name="m_pw" size="20"></td>
<tr>
<tr>
<td>권한</td>
<td><input type="text" name="m_level" size="20"></td>
<tr>
<tr>
<td>이름</td>
<td><input type="text" name="m_name" size="20"></td>
<tr>
<tr>
<td>이메일</td>
<td><input type="text" name="m_email" size="20"></td>
<tr>
<tr>
<td colspan="4"><input type="submit" value="회원가입버튼"></td>
</tr>
</table>
</form>
</body>
</html>2.회원가입처리
1. 드라이버 로딩
Class.forName("com.mysql.jdbc.Driver");2. Connection객체로 DB연결
String jdbcDriver = "jdbc:mysql://localhost:3306/dev42db?" + "useUnicode=true&characterEncoding=euckr";
String dbUser = "dev42id";
String dbPass = "dev42pw";
Connection conn = null;
conn = DriverManager.getConnection(jdbcDriver, dbUser, dbPass);3. Query실행을 위한 준비 - select, insert, update, delete 쿼리에 입력
PreparedStatement pstmt=null;
pstmt=conn.prepareStatement("INSERT INTO tb_member VALUES(?,?,?,?,?)");입력값 준비
String m_id=request.getParameter("m_id");
String m_pw=request.getParameter("m_pw");
String m_level=request.getParameter("m_level");
String m_name=request.getParameter("m_name");
String m_email=request.getParameter("m_email");
pstmt.setString(1,m_id);
pstmt.setString(2,m_pw);
pstmt.setString(3,m_level);
pstmt.setString(4,m_level);
pstmt.setString(5,m_email);4. Query 실행
int result=pstmt.executeUpdate();5. 닫기
pstmt.close();
conn.close();
728x90
'ksmart_jsp > 05_jsp_mysql' 카테고리의 다른 글
| 22_jsp만_delete처리_jsp (0) | 2022.02.02 |
|---|---|
| 21_02_jsp만_ update처리_jsp (0) | 2022.02.02 |
| 21_01_jsp만_ update화면_jsp (0) | 2022.02.02 |
| 20_jsp만_list처리_jsp (0) | 2022.02.02 |
| JDBC 프로그램 순서 (0) | 2022.02.02 |