<test.jsp>
[Test.jsp]
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
저장완료
</body>
</html><db 연결 파일>
package A1101.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import A1101.conn.DBConn;
import A1101.model.T1101Vo;
public class InsertDao implements InsertDaoI {
Connection conn = null;
PreparedStatement pstmt = null;
@Override
public void insert(T1101Vo m) {
try {
conn = DBConn.getConnection();
String sql = "insert into T20191101 values(sT20191101.nextval, ?, ?, ?, ?, ?)";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, m.getId());
pstmt.setString(2, m.getName());
pstmt.setString(3, m.getPwd());
pstmt.setInt(4, m.getAge());
pstmt.setString(5, m.getEmail());
pstmt.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
} finally {
DBConn.close(pstmt, conn);
}
}
}<vo 파일>
package A1101;
public class T1101Vo {
private int idx;
private String id;
private String name;
private String pwd;
private int age;
private String email;
T1101Vo(String id,String name,String pwd,int age, String email){
this.id=id;
this.name=name;
this.pwd=pwd;
this.age=age;
this.email=email;
}
public int getIdx() {
return idx;
}
public void setIdx(int idx) {
this.idx = idx;
}
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPwd() {
return pwd;
}
public void setPwd(String pwd) {
this.pwd = pwd;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
@Override
public String toString() {
return "T1101Vo [idx=" + idx + ", id=" + id + ", name=" + name + ", pwd=" + pwd + ", age=" + age + ", email="
+ email + "]";
}
}<서블릿>
package A1101.controller;
import java.io.IOException;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import A1101.model.T1101Vo;
import A1101.service.InsertService;
import A1101.service.InsertServiceI;
/**
* Servlet implementation class InsertController
*/
@WebServlet("/InsertController")
public class InsertController extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public InsertController() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
String id =request.getParameter("id");
String name =request.getParameter("name");
String pwd = request.getParameter("pwd");
int age =Integer.parseInt(request.getParameter("age"));
String email =request.getParameter("email");
InsertServiceI s = new InsertService();
T1101Vo m = new T1101Vo(id,name,pwd,age,email);
s.insert(m);
RequestDispatcher dispatcher=request.getRequestDispatcher("/A1101/Test.jsp");
dispatcher.forward(request, response);
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doGet(request, response);
}
}<가입 폼>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<h2>회원가입 폼만들기</h2>
<form action="<%=request.getContextPath()%>/InsertController">
아 디 : <input type="text" name = id> <br>
이 름 : <input type="text" name =name><br>
암 호 : <input type="text" name =pwd><br>
나 이 : <input type="text" name =age><br>
메 일 : <input type="text" name =email><br>
<input type="submit" value="가입">
</form>
</body>
</html>
'[웹개발] > JSP 개념' 카테고리의 다른 글
| [JSP 개념] request.setCharacterEncoding("utf-8"); 한글 인코딩 (0) | 2020.01.06 |
|---|---|
| [JSP 개념] mvc 패턴에서 자료실 구성시 주의할 점 (0) | 2019.11.11 |
| [JSP 개념] JSP에서 콘솔에 print하고 싶을 경우 (0) | 2019.11.04 |
| [JSP 개념] PreparedStatement setString, setInt에 관하여 (0) | 2019.11.01 |
| [JSP 개념] db에서 데이터를 불러 올 때는 꼭 rs.next()를 진행해줘야 한다. (0) | 2019.11.01 |
