태그 'jdbc'에 해당하는 글 1건

[jsp] model2 jdbc

========== Controller.java ==========================


import java.io.IOException;
import java.util.*;
import java.io.PrintWriter;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import model.*;

/**
 * Servlet implementation class for Servlet: Controller
 *
 */
 public class Controller extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  response.setCharacterEncoding("KSC5601");
  Database db = new model.Database();
  Vector<Record> vlist = db.getDB();
 
  request.setAttribute("vlist",vlist);
  try{
   RequestDispatcher d =request.getRequestDispatcher("emp.jsp");  
   d.forward(request,response);  
  }catch(Exception e){}
 

 }          
}

--------------- Database.java --------------------

package model;

import java.sql.*;
import java.util.*;

public class Database {
 Statement stmt;
 Connection conn;
 String str="";
 
 public Database(){
  try{
//   다음 3 라인의 정보를 변경해 주세요//////////////////////////////////////////
   String dbURL = "jdbc:oracle:thin:@localhost:1521:ora92";
   String id = "scott";
   String pwd = "tiger";
   /////////////////////////////////////////////////////////////////////////////////////////////////////////
   Class.forName("oracle.jdbc.driver.OracleDriver");
   conn = DriverManager.getConnection(dbURL, id, pwd);
   stmt = conn.createStatement();
  }catch(Exception e){}  
 }
 
 public Vector<Record> getDB(){
 Vector<Record> v1 = new Vector<Record>();  
 try{
  ResultSet rs = stmt.executeQuery("select * from emp");
  while(rs.next()){      
   v1.add(new Record(rs.getInt(1),rs.getString(2),rs.getString(3)));
  }
  rs.close();
  stmt.close();
  conn.close();
 }catch(Exception e){}
 return v1;
 }

}

---------------- Record.java --------------

package model;

public class Record {
 private int empno;
 private String ename;
 private String job;
 
 public Record(int empno,String ename,String job){
  this.empno = empno;
  this.ename = ename;
  this.job = job;
 }

 public int getEmpno() {
  return empno;
 }

 public String getEname() {
  return ename;
 }

 public String getJob() {
  return job;
 }
}
----------------- emp.jsp -------------------

<%@ page language="java" contentType="text/html; charset=EUC-KR"
    pageEncoding="EUC-KR" import="java.util.*,model.*"%>
<!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>Insert title here</title>
</head>
<body>
<%

response.setContentType("text/html;charset=KSC5601");

request.setCharacterEncoding("KSC5601");

Vector<Record> vlist = (Vector<Record>)request.getAttribute("vlist");
for(int i = 0 ; i < vlist.size() ; i++){
 Record r = vlist.get(i);%>
 <%="번호 : " + r.getEmpno()+ "<br>"%>
 <%="이름 : " + r.getEname()+ "<br>"%>
 <%="직책 : " + r.getJob()+ "<p>"%>
<%}%>

</body>
</html>