kyun님의 이글루

JSP]DB연결2-JDBC

kyun — Mon, 14 Jul 2008 02:10:35 GMT

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" %>

회원 목록

MEMBMER 테이블의 내용

<%
// 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()) {
%>





<%
        }
    } 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) {}
    }

이름	아이디	이메일
<%= rs.getString("NAME") %>	<%= rs.getString("MEMBERID") %>	<%= rs.getString("EMAIL") %>

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

kyun — Mon, 14 Jul 2008 02:07:49 GMT

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;

JSP]Bean+Property-회원가입폼

kyun — Thu, 10 Jul 2008 00:58:41 GMT

============================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" %>

회원가입 입력 폼

===========================register.jsp===============================

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

가입

아이디	암호
이름		이메일
주소

JSP]모듈화

kyun — Tue, 08 Jul 2008 00:55:32 GMT

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

<% String code = request.getParameter("code"); %>

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

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

kyun — Mon, 07 Jul 2008 08:29:18 GMT

================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);
%>

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

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

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

JSP] 페이지 이동3-정보전달2

kyun — Mon, 07 Jul 2008 08:06:32 GMT

==================paramTo.jsp=============================
<%@ page contentType = "html/text; charset = euc - kr" %>
<%@ page import = "java.util.Calendar" %>
<%
Calendar cal = Calendar.getInstance();
request.setAttribute("time",cal);
%>

==================paramFrom.jsp=========================
<%@ page contentType = "html/text; charset=euc-kr"%>
<%@ page import = "java.util.Calendar" %>

<% Calendar cal = (Calendar) request.getAttribute("time");
%>
now TIME

HOUR: <%=cal.get(Calendar.HOUR) %>
MIN: <%=cal.get(Calendar.MINUTE) %>
SEC: <%=cal.get(Calendar.SECOND) %>

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

JSP] 페이지 이동2-정보전달

kyun — Mon, 07 Jul 2008 07:55:23 GMT

===================paramFrom.jsp=======================
<%@ page contentType = "html/text; charset=euc-kr"%>
<% String value = request.getParameter("p1");

if (value == null) value = "NOPARAM";
%>

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

p1 파라미터 : <%= request.getParameter("p1")%>

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

JSP] 페이지 이동

kyun — Mon, 07 Jul 2008 07:41:10 GMT

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

<form action = "<%= request.getContextPath() %>/view.jsp">
보고싶은 페잊 선택

=================view.jsp============================
<%@ page contentType = "text/html; charset = euc-kr" %>
<%
String code = request.getParameter("code");
String viewPageURI=null;

if (code.equals("A")){
  viewPageURI="/a.jsp";
  }else if (code.equals("B")){
  viewPageURI="/b.jsp";
  }else if (code.equals("C")){
  viewPageURI="/c.jsp";
  }
  %>

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

JSP] 파일 읽기 소스

kyun — Mon, 07 Jul 2008 04:09:43 GMT

==========================================================================
<%@ page contentType = "text/html; charset = euc-kr" %>
<%@ page import = "java.io.*" %>

<%
FileReader fr = null;
char [] buff = new char[512];
int len = -1;

try {
fr = new FileReader(
"E:\\Tomcat\\Tomcat5.5\\logs\\test.txt"); //절대경로
while((len=fr.read(buff)) != -1){
out.print(new String(buff,0,len));
}
}catch(IOException ex){
out.println("예외발생:" + ex.getMessage());
}finally{
if (fr != null) try { fr.close();} catch (IOException ex){}
}
%>

=========================================================================
추가:
상대경로 설정
1.getRealPath(String path)
2.getResource(String path)
3.getResourceAsStream(String path)

===========================================================================
<%@ page contentType = "text/html; charset = euc-kr" %>
<%@ page import = "java.io.*" %>

<% String resourcePath = "\\test.txt";%>
<%
BufferedReader br = null;
char [] buff = new char[512];
int len = -1;

try {
br = new BufferedReader(
  new InputStreamReader (
   application.getResourceAsStream(resourcePath)));
while((len=br.read(buff)) != -1){
   out.print(new String(buff,0,len));
}
}catch(IOException ex){
out.println("예외발생:" + ex.getMessage());
}finally{
if (br != null) try { br.close();} catch (IOException ex){}
}
%>

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

JSP] 가상 디렉토리 설정

kyun — Mon, 07 Jul 2008 02:30:28 GMT

목적 :
항상 webapps폴더의 하위 폴더로 추가할수는 없음
방법:
~\jakarta-tomcat-5.0.xx\conf\server.xml 파일에 웹 어플리케이션 정보 추가
예제:
http://localhost:8080/test를 c:\home\test폴더로 지정

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

- <Host name="localhost"appBase="webapps"unpackWARs="true"autoDeploy="true"xmlValidation="false"xmlNamespaceAware="false">