jsp 게시판 만들기 1

jsp beans 로 게시판 만들기

디비에 테이블 생성

create table board(

unq int unsigned not null auto_increment,

title varchar(100) not null,

pwd varchar(100) not null,

name varchar(50),

content text,

hit int unsigned default '0',

rdate datetime,

primary key(unq));

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

DBCon.java

---------------------------------------------------------------

package testBean;

import java.sql.*;

import java.sql.DriverManager;

public class DBCon {

Connection con = null;

String url = "jdbc:mysql://localhost:3306/mysql";

public Connection getConnection() {

try {

Class.forName("com.mysql.jdbc.Driver");

con = DriverManager.getConnection(url, "root", "apmsetup");

return con;

} catch (Exception e) {

return null;

}

}

}

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

ElementBoard.java

----------------------------------------------------------------

package testBean;

public class ElementBoard {

private String title;

private String pwd;

private String name;

private String content;

private String rdate;

private int unq;

private int hit;

public String getTitle() {

return title;

}

public void setTitle(String title) {

this.title = title;

}

public String getPwd() {

return pwd;

}

public void setPwd(String pwd) {

this.pwd = pwd;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public String getContent() {

return content;

}

public void setContent(String content) {

this.content = content;

}

public String getRdate() {

return rdate;

}

public void setRdate(String rdate) {

this.rdate = rdate;

}

public int getUnq() {

return unq;

}

public void setUnq(int unq) {

this.unq = unq;

}

public int getHit() {

return hit;

}

public void setHit(int hit) {

this.hit = hit;

}

}

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

QueryBoardMake.java

--------------------------------------------------------------

public class QueryBoardMake extends ElementBoard {

private String query;

public String getInsert() {

query = "INSERT INTO board( title,pwd,name,content,rdate)" 

+ "VALUES('" + getTitle() + "','" + getPwd() + "','" + getName() + "','" + getContent() + "','" + getRdate() + "')";

return query;

}

public String getUpdate(int unq){

query="UPDATE board "

+ "SET title='"+getTitle()+"',name='"+getName()+"'"

+",content='"+getContent()+"',hit='"+getHit()+"'"

+",rdate='"+getRdate()+"'"

+"where unq='"+unq+"'";

return query;

}

public String getSelect(){

query="SELECT unq,title,name,hit,rdate FROM board ORDER BY unq                     DESC";

return query;

}

public String getDelete(int unq){

query="DELETE FROM board WHERE unq='"+unq+"'";

return query;

}

public String getSelectTotalCnt(){

query="SELECT COUNT(*) FROM board";

return query;

}

}

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