JDBC 다운은 이전 포스트를 참고
duridan-program.tistory.com/25?category=1193590
Mysql JDBC
(먼저 Mysql를 설치 한 후에 진행 ) 1. JDBC 설치(1) dev.mysql.com/downloads/ MySQL :: MySQL Community Downloads The world's most popular open source database dev.mysql.com Connector J 선택 하기 2...
duridan-program.tistory.com
JSP 페이지에서 테이블에 레코드 추가
구성도
insertTestForm
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>레코드 추가</title>
</head>
<body>
<h2>member 테이블에 레코드 추가</h2>
<form method="post" action="insertTestPro.jsp">
아이디 : <input type="text" name="id" maxlength="50"><br>
패스워드 : <input type="password" name="passwd" maxlength="16"><br>
이름 : <input type="text" name="name" maxlength="10"><br>
<input type="submit" value="입력">
</form>
</body>
</html>insertTestPro
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<%request.setCharacterEncoding("utf-8"); %>
<%
String id=request.getParameter("id");
String passwd=request.getParameter("passwd");
String name=request.getParameter("name");
Timestamp register = new Timestamp(System.currentTimeMillis());
Connection conn = null;
PreparedStatement pstmt=null;
String str="";
try{
String jdbcUrl = "jdbc:mysql://localhost:3306/jspmysql";
String dbId= "root";
String dbPass = "00000000";
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(jdbcUrl, dbId, dbPass);
String sql="insert into member values(?,?,?,?)";
pstmt=conn.prepareStatement(sql);
pstmt.setString(1,id);
pstmt.setString(2,passwd);
pstmt.setString(3, name);
pstmt.setTimestamp(4, register);
pstmt.executeUpdate();
str="member테이블에 새로운 레코드를 추가 했습니다.";
}catch(Exception e){
e.printStackTrace();
str="member테이블에 새로운 레코드를 추가 했습니다.";
}finally{
if(pstmt !=null)
try{pstmt.close();}catch(SQLException sqle){}
if(conn !=null)
try{conn.close();}catch(SQLException sqle){}
}
%>
<html>
<head>
<title>레코드 추가</title>
</head>
<body>
<%=str %>
</body>
</html>
JSP 페이지에서 테이블에 레코드 화면에 추가
selectTest.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>레코드 표시</title>
</head>
<body>
<h2>레코드 표시</h2>
<table border ='1'>
<tr>
<td width="100">아이디</td>
<td width="100">패스워드</td>
<td width="100">이름</td>
<td width="250">가입일자</td>
</tr>
<%
Connection conn=null;
PreparedStatement pstmt=null;
ResultSet rs =null;
try{
String jdbcUrl = "jdbc:mysql://localhost:3306/jspmysql";
String dbId= "root";
String dbPass = "00000000";
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(jdbcUrl, dbId, dbPass);
String sql = "select * from member";
pstmt = conn.prepareStatement(sql);
rs = pstmt.executeQuery();
while(rs.next()){
String id = rs.getString("id");
String passwd = rs.getString("passwd");
String name = rs.getString("name");
Timestamp register = rs.getTimestamp("reg_date");
%>
<tr>
<td width="100"><%=id %></td>
<td width="100"><%=passwd %></td>
<td width="100"><%=name %></td>
<td width="250"><%=register.toString()%></td>
</tr>
<%}
}catch(Exception e){
e.printStackTrace();
}finally{
if(rs != null)
try{rs.close();}catch(SQLException sqle){}
if(pstmt != null)
try{pstmt.close();}catch(SQLException sqle){}
if(conn != null)
try{conn.close();}catch(SQLException sqle){}
}
%>
</table>
</body>
</html>
'개발 > JSP' 카테고리의 다른 글
| [JSP] 게시판 - 未完 (0) | 2021.04.06 |
|---|---|
| [JSP] JSP 페이지에서 테이블 관련 [수정] (0) | 2021.04.06 |
| [JSP] JDBC를 사용한 JSP와 데이터베이스 연동 (0) | 2021.04.06 |
| [JSP] 자바 빈 (java bean) (0) | 2021.04.05 |
| [JSP] 에러 처리 (0) | 2021.04.05 |
