2. CreateTest

CreateTest

create table board_2(

board_num number,

board_name varchar2(20),

board_pass varchar2(15),

board_subject varchar2(50),

board_content varchar2(2000),

board_file varchar2(50),

board_re_ref number,

board_re_lev number,

board_re_seq number,

board_readcount number,

board_date date,

primary key(board_num));

package net.board.test;

import java.sql.Date;

public class BoardBean {

private int BOARD_NUM;

private String BOARD_NAME;

private String BOARD_PASS;

private String BOARD_SUBJECT;

private String BOARD_CONTENT;

private String BOARD_FILE;

private int BOARD_RE_REF;

private int BOARD_RE_LEV;

private int BOARD_RE_SEQ;

private int BOARD_READCOUNT;

private Date BOARD_DATE;

public int getBOARD_NUM() {

return BOARD_NUM;

}

public void setBOARD_NUM(int bOARD_NUM) {

BOARD_NUM = bOARD_NUM;

}

public String getBOARD_NAME() {

return BOARD_NAME;

}

public void setBOARD_NAME(String bOARD_NAME) {

BOARD_NAME = bOARD_NAME;

}

public String getBOARD_PASS() {

return BOARD_PASS;

}

public void setBOARD_PASS(String bOARD_PASS) {

BOARD_PASS = bOARD_PASS;

}

public String getBOARD_SUBJECT() {

return BOARD_SUBJECT;

}

public void setBOARD_SUBJECT(String bOARD_SUBJECT) {

BOARD_SUBJECT = bOARD_SUBJECT;

}

public String getBOARD_CONTENT() {

return BOARD_CONTENT;

}

public void setBOARD_CONTENT(String bOARD_CONTENT) {

BOARD_CONTENT = bOARD_CONTENT;

}

public String getBOARD_FILE() {

return BOARD_FILE;

}

public void setBOARD_FILE(String bOARD_FILE) {

BOARD_FILE = bOARD_FILE;

}

public int getBOARD_RE_REF() {

return BOARD_RE_REF;

}

public void setBOARD_RE_REF(int bOARD_RE_REF) {

BOARD_RE_REF = bOARD_RE_REF;

}

public int getBOARD_RE_LEV() {

return BOARD_RE_LEV;

}

public void setBOARD_RE_LEV(int bOARD_RE_LEV) {

BOARD_RE_LEV = bOARD_RE_LEV;

}

public int getBOARD_RE_SEQ() {

return BOARD_RE_SEQ;

}

public void setBOARD_RE_SEQ(int bOARD_RE_SEQ) {

BOARD_RE_SEQ = bOARD_RE_SEQ;

}

public int getBOARD_READCOUNT() {

return BOARD_READCOUNT;

}

public void setBOARD_READCOUNT(int bOARD_READCOUNT) {

BOARD_READCOUNT = bOARD_READCOUNT;

}

public Date getBOARD_DATE() {

return BOARD_DATE;

}

public void setBOARD_DATE(Date bOARD_DATE) {

BOARD_DATE = bOARD_DATE;

}

}

<BoardBean.java>

package net.board.test;

import java.beans.PropertyVetoException;

import java.io.IOException;

import java.sql.Connection;

import java.sql.SQLException;

import org.apache.tomcat.dbcp.dbcp2.BasicDataSource;

public class DbcpSource {

private static DbcpSource ds;

private BasicDataSource bds;

private DbcpSource()

throws IOException, SQLException, PropertyVetoException {

// connection setup

bds = new BasicDataSource();

bds.setDriverClassName("oracle.jdbc.driver.OracleDriver");

bds.setUsername("scott");

bds.setPassword("tiger");

bds.setUrl("jdbc:oracle:thin:@127.0.0.1:1521:xe");

}

public static DbcpSource getInstance() throws IOException,

SQLException, PropertyVetoException {

if (ds == null){

ds = new DbcpSource();

return ds;

} else {

return ds;

}

}

public Connection getConnection() throws SQLException {

return this.bds.getConnection();

}

}

<DbcpSource.java>

package net.board.test;

import java.beans.PropertyVetoException;

import java.io.IOException;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

public class CreateTestData {

static DbcpSource ds = null;

static Connection con;

static PreparedStatement pstmt;

static ResultSet rs;

public static void main(String[] args) 

throws IOException, SQLException, PropertyVetoException {

ds = DbcpSource.getInstance();

con = ds.getConnection();

ArrayList<BoardBean> list = new ArrayList<BoardBean>();

for (int i = 0; i < 1; i++){

BoardBean bb = new BoardBean();

bb.setBOARD_NAME("글쓴이 999" + i);

bb.setBOARD_PASS("1111");

bb.setBOARD_SUBJECT("제목 999" + i);

bb.setBOARD_CONTENT("내용 999" + i + "\n" + "내용" + i);

list.add(bb);

}

for(int i = 0; i < list.size(); i++){

System.out.print("insert...."+i);

// insert

if (boardInsert(list.get(i))){

System.out.println(" --> 성공 !!!!");

}else{

System.out.println(" --> 실패 !!!!");

}

}

// connection close

con.close();

}

public static boolean boardInsert(BoardBean board){

int num = 0;

String sql = "";

int rowCnt = 0;

boolean result = false;

try{

pstmt = con.prepareStatement("select max(board_num)"

+ " from board_2");

rs = pstmt.executeQuery();

if (rs.next()){

num = rs.getInt(1) + 1;

}else{

num = 1;

}

sql = " insert into board_2 (board_num, board_name, board_pass, board_subject, "

+ " board_content, board_file, board_re_ref, board_re_lev, "

+ " board_re_seq, board_readcount, board_date) "

+ " values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, sysdate)";

pstmt = con.prepareStatement(sql);

pstmt.setInt(1, num);

pstmt.setString(2, board.getBOARD_NAME());

pstmt.setString(3, board.getBOARD_PASS());

pstmt.setString(4, board.getBOARD_SUBJECT());

pstmt.setString(5, board.getBOARD_CONTENT());

pstmt.setString(6, board.getBOARD_FILE());

pstmt.setInt(7, num);

pstmt.setInt(8, 0);

pstmt.setInt(9, 0);

pstmt.setInt(10, 0);

rowCnt = pstmt.executeUpdate();

if (rowCnt != 0) {

result = true;

}

}catch(Exception e){

System.out.println("boardInsert() 에러: " + e);

}finally{

try{

if (rs != null) rs.close();

if (pstmt != null)pstmt.close();

}catch(SQLException e){

e.printStackTrace();

}

}

return result;

}

}

<CreateTestData.java>