DB이용한 입출력하기

<입력폼에 값 입력후 DB저장 처리후 출력하기 소스 #1>

 

 

==============================================

list_write.jsp

 

<%@ page contentType='text/html;charset=euc-kr' pageEncoding="euc-kr" %>
<%@ page import="java.sql.*"%>
<%@include file="dbconn.jsp"%>
<%
 String query = "select * from family";
 rs = stmt.executeQuery(query);                       
 
 while(rs.next()){
  int id = rs.getInt("id");
  String name = rs.getString("name");                      
  out.println(id);
  out.println(name + "<br>");
 }
%>
<%@include file="_tail.jsp"%>

==============================================

exequery.jsp

 

<%@ page contentType='text/html;charset=euc-kr' pageEncoding="euc-kr" %>
<%request.setCharacterEncoding("euc-kr"); %>
<%@ page import="java.sql.*"%>
<%@include file="dbconn.jsp"%>
<%
 String name = request.getParameter("name");
%>
<%  
  String query = "insert into family(name) values('";
  query += name;
  query +="')";
  
  stmt.executeUpdate(query);
  response.sendRedirect("list_output.jsp");
%>
<%@include file="_tail.jsp"%>

 

==============================================

list_output.jsp

 

<%@ page contentType='text/html;charset=euc-kr' pageEncoding="euc-kr" %>
<%@ page import="java.sql.*"%>
<%@include file="dbconn.jsp"%>
<%
 String query = "select * from family";
 rs = stmt.executeQuery(query);                       
 
 while(rs.next()){
  int id = rs.getInt("id");
  String name = rs.getString("name");                      
  out.println(id);
  out.println(name + "<br>");
 }
%>
<%@include file="_tail.jsp"%>