2008년 07월 14일

JSP]DB연결2-JDBC

DBMS에 알맞은 JDBC드라이버 준비 필수
~\WEB-INF\lib\mysql-connector-java-3.0.14-production-bin.jar 파일에 포함

<%@ page contentType = "text/html; charset=euc-kr" %>

<%@ page import = "java.sql.DriverManager" %>
<%@ page import = "java.sql.Connection" %>
<%@ page import = "java.sql.Statement" %>
<%@ page import = "java.sql.ResultSet" %>
<%@ page import = "java.sql.SQLException" %>

<html>
<head><title>회원 목록</title></head>
<body>

MEMBMER 테이블의 내용
<table width="100%" border="1">
<tr>
    <td>이름</td><td>아이디</td><td>이메일</td>
</tr>
<%
 // 1. JDBC 드라이버 로딩
    try{ Class.forName("com.mysql.jdbc.Driver");
    }catch(ClassNotFoundException ex){
  throw ex;
 }

    Connection conn = null;
    Statement stmt = null;
    ResultSet rs = null;
   
    try {
        String jdbcDriver = "jdbc:mysql://localhost:3306/chap11?" +
                            "useUnicode=true&characterEncoding=euc-kr";
        String dbUser = "lkyunl";
        String dbPass = "1234";
       
        String query = "select * from member order by MEMBERID";
       
        // 2. 데이터베이스 커넥션 생성
        conn = DriverManager.getConnection(jdbcDriver, dbUser, dbPass);
       
        // 3. Statement 생성
        stmt = conn.createStatement();
       
        // 4. 쿼리 실행
        rs = stmt.executeQuery(query);
       
        // 5. 쿼리 실행 결과 출력
        while(rs.next()) {
%>
<tr>
    <td><%= rs.getString("NAME") %></td>
    <td><%= rs.getString("MEMBERID") %></td>
    <td><%= rs.getString("EMAIL") %></td>
</tr>
<%
        }
    } catch(SQLException ex) {
        throw ex;
    } finally {
        if (rs != null) try { rs.close(); } catch(SQLException ex) {}
        if (stmt != null) try { stmt.close(); } catch(SQLException ex) {}
        if (conn != null) try { conn.close(); } catch(SQLException ex) {}
    }

%>
</table>

</body>
</html>

by kyun | 2008/07/14 11:10 | 트랙백 | 덧글(0)

2008년 07월 14일

JSP]DB(mysql)연결1 - DB설정

1. MySQL 4.0 설치

2. 데이타 베이스 생성
c:\mysql\bin>mysqladmin -u root create TESTDB

3.계정 생성
mysql>grant select,insert,update,delete,create,drop on TESTDB.* to 'kyun'@'localhost' identified by '1234'

4.접속
c:\mysql\bin>mysql -u kyun -p TESTDB

//쿼리문

create table 테이블명(
컬럼명 VARCHAR(2) NOT NULL PRIMARY KEY,
...
)

insert into 테이블명(컬럼1,...) values ('값1'...);

select * from TABLE where ID = 'kyun' AND PASSWD <> "1234" AND E-MAIL is not NULL order by ID asc;
count(*),max(ID),min..,sum..

update TABLE set NAME = 'lkyunl where NAME = 'kyun';

delete from TABLE where NAME = 'lkyunl';

select A.필드1,A.필드2,B.필드3,B.필드4 from TABLE as A, TABLE2 as B
where A.필드 = B.필드

select * from MEMBER as A, MEMBER_ETC as B where A.MEMBERID = B.MEMBERID;

 

by kyun | 2008/07/14 11:07 | 트랙백 | 덧글(0)

2008년 07월 10일

JSP]Bean+Property-회원가입폼

============================Memberinfo.java========================

package madvirus.member;

import java.sql.Timestamp;

public class MemberInfo {
   
    private String id;
    private String password;
    private String name;
    private String address;
    private Timestamp registerDate;
    private String email;
   
    public String getId() {
        return id;
    }
    public void setId(String val) {
        this.id = val;
    }
    public String getPassword() {
        return password;
    }
    public void setPassword(String val) {
        this.password = val;
    }
    public String getName() {
        return name;
    }
    public void setName(String val) {
        this.name = val;
    }
    public String getAddress() {
        return address;
    }
    public void setAddress(String val) {
        this.address = val;
    }
    public Timestamp getRegisterDate() {
        return registerDate;
    }
    public void setRegisterDate(Timestamp val) {
        this.registerDate = val;
    }
    public String getEmail() {
        return email;
    }
    public void setEmail(String val) {
        this.email = val;
    }
}
=======================================================================
class file path = ~\webapps\chap10\WEB-INF\classes\madvirus\member

=============================registerForm.jsp============================

<%@ page contentType = "text/html; charset=euc-kr" %>
<html>
<head><title>회원가입 입력 폼</title></head>
<body>

<form action="<%= request.getContextPath() %>/register.jsp" method="post">

<table border="1" cellpadding="0" cellspacing="0">
<tr>
    <td>아이디</td>
    <td colspan="3"><input type="text" name="id" size="10"></td>
</tr>
<tr>
    <td>이름</td>
    <td><input type="text" name="name" size="10"></td>
    <td>이메일</td>
    <td><input type="text" name="email" size="10"></td>
</tr>
<tr>
    <td>주소</td>
    <td colspan="3"><input type="text" name="address" size="30"></td>
</tr>
<tr>
    <td colspan="4" align="center">
    <input type="submit" value="회원가입">
    </td>
</tr>
</table>

</form>

</body>
</html>
===========================register.jsp===============================

<%@ page contentType = "text/html; charset=euc-kr" %>
<%
    request.setCharacterEncoding("euc-kr");  //읽어올 파라미터의 캐릭터 인코딩을 euc-kr로 지정
%>
<jsp:useBean id="memberInfo" class="madvirus.member.MemberInfo" /> //memberinfo 자바빈 클래스의 객체를 생성하여 memberInfo이름으로 지정
<jsp:setProperty name="memberInfo" property="*" /> //파라미터의 값을 memberInfo자바빈 객체의 프로퍼티값으로 지정
<jsp:setProperty name="memberInfo" property="password"
                 value="<%= memberInfo.getId() %>" />memberInfo자바빈 객체의 password프로퍼티의 값을 memberInfo.getId()와 동일하게 지정.라인 08에서memberInfo변수를 사용하여 id프로퍼티에 접근하고 있다
<html>
<head><title>가입</title></head>
<body>

<table width="400" border="1" cellpadding="0" cellspacing="0">
<tr>
    <td>아이디</td>
    <td><jsp:getProperty name="memberInfo" property="id" /></td>
    <td>암호</td>
    <td><jsp:getProperty name="memberInfo" property="password" /></td>
</tr>
<tr>
    <td>이름</td>
    <td><jsp:getProperty name="memberInfo" property="name" /></td>
    <td>이메일</td>
    <td><jsp:getProperty name="memberInfo" property="email" /></td>
</tr>
<tr>
    <td>주소</td>
    <td colspan="3">
    <jsp:getProperty name="memberInfo" property="address" />
    </td>
</tr>
</table>

</body>
</html>

by kyun | 2008/07/10 09:58 | 트랙백 | 덧글(1)

2008년 07월 08일

JSP]모듈화

======================main.jsp==========================
<%@ page contentType = "text/html; charset=euc-kr" %>
<html>
<body>

<% String code = request.getParameter("code"); %>
<form method="post">
<p>
<select name ="code">
 <option value="a">A</option>
 <option value="b">B</option>
 <option value="c">C</option>
 <option value="d">D</option>
 <option value="e">E</option>
</select>
</p>
<input type = "submit" value="submit">
</form>
<br><br><br>
<jsp:include page="/sub.jsp" flush = "true">
 <jsp:param name = "type" value="<%=code%>" />
</jsp:include>


</body>
</html>
=======================sub.jsp================================
<%@ page contentType = "html/text;  charset=euc-kr" %>
<% String type =request.getParameter("type");%>
===============================================================

by kyun | 2008/07/08 09:55 | 트랙백 | 덧글(0)

2008년 07월 07일

JSP]페이지 이동-자바스크립트 사용

================write.jsp=================================================
<%@ page contentType="html/text; charset=euc-kr" %>
<%@ page import = "java.net.URLEncoder"%>
<%@ page import = "java.util.Random" %>
<%
 Random random = new Random();
 int number = random.nextInt();
 String numberString = Integer.toString(number);
 %>
 
<script language= "JavaScript">
location.href = "<%=request.getContextPath()%>/list.jsp"+"?num=<%=URLEncoder.encode(numberString)%>";
</script>

==============list.jsp=======================================================
<%@ page contentType = "html/text; charset = euc-kr" %>
<html>
<body>

parameter:<%= request.getParameter("num") %>
</body>
</html>
==========================================================================

by kyun | 2008/07/07 17:29 | 트랙백 | 덧글(0)

◀ 이전 페이지          다음 페이지 ▶