ํ‹ฐ์Šคํ† ๋ฆฌ ๋ทฐ

์นดํ…Œ๊ณ ๋ฆฌ ์—†์Œ

์˜ˆ์™ธ์ฒ˜๋ฆฌ.

๐Ÿฉท ์Šˆ ๐Ÿงก 2010. 6. 23. 20:34
728x90
SMALL

package member;
import java.sql.*;

import util.DBUtil;

public class MemberMgr {
 
 //ํšŒ์›์ •๋ณด ์ž…๋ ฅํ•˜๋Š” ๋ฉ”์†Œ๋“œ
 public void insertMember(MemberBean bean) throws SQLException {
  //jdbc ์ค€๋น„
  Connection conn = null;
  PreparedStatement pstmt = null;
 
  //jdbc 1,2
  try {
   conn = DBUtil.getConnection();
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
 
  //jdbc 3
  StringBuilder sql = new StringBuilder();
  sql.append("insert into member (");
  sql.append("idx  ,");
  sql.append("id  ,");
  sql.append("pwd  ,");
  sql.append("name ,");
  sql.append("jumin1 ,");
  sql.append("jumin2 ,");
  sql.append("email ,");  
  sql.append("zip1 ,");
  sql.append("zip2 ,");
  sql.append("addr ,");
  sql.append("joindate");
  sql.append(") values (null, ?,?,?,?,?,?,?,?,?,?)");
 
  try {
   //jdbc 4
   pstmt = conn.prepareStatement(sql.toString());

   
   //jdbc 5
   //ํŒŒ๋ผ๋ฏธํ„ฐ ์„ธํŒ…๋‹จ๊ณ„
   int i = 1;
   pstmt.setString(i++, bean.getId());  
   pstmt.setString(i++, bean.getPwd());    
   pstmt.setString(i++, bean.getName());  
   pstmt.setString(i++, bean.getJumin1());  
   pstmt.setString(i++, bean.getJumin2());  
   pstmt.setString(i++, bean.getEmail());    
   pstmt.setString(i++, bean.getZip1());  
   pstmt.setString(i++, bean.getZip2());  
   pstmt.setString(i++, bean.getAddr());  
   pstmt.setTimestamp(i++, bean.getJoindate());

   /*
    * ?์˜ ๊ฐœ์ˆ˜ : 10๊ฐœ
    * ?์˜ ํƒ€์ž… : String 9, Timestamp 1
    * ์ •์˜ํ•œ๋‹ค.
   */
   
   //jdbc 6๋‹จ๊ณ„ : ์‹คํ–‰
   pstmt.execute();
  } finally {
   //jdbc 7 : ๋‹ซ๊ธฐ
   DBUtil.close(conn, pstmt, null, null);
  }
 
 }
 
 //์ค‘๋ณต์•„์ด๋””๊ฐ€ ์žˆ๋Š”์ง€ ๊ฒ€์‚ฌํ•˜๋Š” ๋ฉ”์†Œ๋“œ
 public boolean isDuple(String id) {
  boolean result = false;
 
  return result;
 }
}



Proc ํŽ˜์ด์ง€์—์„œ ๊ฒฐ๊ณผ๋ฅผ ๋ฐ›์•„์„œ ์˜ˆ์™ธ์ฒ˜๋ฆฌ catch๋ฅผ ํ•˜๊ณ 
์ž…๋ ฅ bean์—์„œ๋Š” finally๋กœ๋งŒ ์ฒ˜๋ฆฌํ•œ๋‹ค.


###############################################################

<%@ page language="java" contentType="text/html; charset=EUC-KR" pageEncoding="EUC-KR"%>
<%
 //ํ•œ๊ธ€ ํŒŒ๋ผ๋ฏธํ„ฐ ์ฒ˜๋ฆฌ
 request.setCharacterEncoding("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>ํšŒ์›๊ฐ€์ž… ์ฒ˜๋ฆฌ</title>
</head>
<body>
 
 <jsp:useBean id="mgr" class="member.MemberMgr"></jsp:useBean>
 
 <jsp:useBean id="bean" class="member.MemberBean">
  <jsp:setProperty name="bean" property="*"></jsp:setProperty>
 </jsp:useBean>
 
 <%
  try {
   mgr.insertMember(bean);
 %>
  <script type="text/javascript">
   alert("๊ฐ€์ž…์„ฑ๊ณต");
   document.location.href = "membrList.jsp";
  </script>
 <%
  } catch(Exception e) {
   e.printStackTrace();
 %>
  <script type="text/javascript">
   alert("๊ฐ€์ž…์‹คํŒจ : <%=e.getMessage()%>
   history.back();
  </script>
 <%
  }
 %>
</body>
</html>

728x90
LIST
๋Œ“๊ธ€
๊ณต์ง€์‚ฌํ•ญ
์ตœ๊ทผ์— ์˜ฌ๋ผ์˜จ ๊ธ€
์ตœ๊ทผ์— ๋‹ฌ๋ฆฐ ๋Œ“๊ธ€
Total
Today
Yesterday
๋งํฌ
TAG more
ยซ   2025/06   ยป
์ผ ์›” ํ™” ์ˆ˜ ๋ชฉ ๊ธˆ ํ† 
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30
๊ธ€ ๋ณด๊ด€ํ•จ
250x250