Rar! ϐs
ct . j j !>J]90 www\.classpath
t / 1;J]90 www\.mymetadata
&t , "
L]90 www\.project
www2
com.genuitec.eclipse.j2eedt.core.WebClasspathBuilder
org.eclipse.jdt.core.javabuilder
com.genuitec.eclipse.j2eedt.core.J2EEProjectValidator
com.genuitec.eclipse.j2eedt.core.DeploymentDescriptorValidator
org.eclipse.wst.validation.validationbuilder
com.genuitec.eclipse.ast.deploy.core.DeploymentBuilder
com.genuitec.eclipse.ast.deploy.core.deploymentnature
com.genuitec.eclipse.j2eedt.core.webnature
org.eclipse.jdt.core.javanature
't = eic90 www\src\bean\ContentBean.javapackage bean;
public class ContentBean {
private String title;
private String content;
private String user;
private String posttime;
private String replaytxt;
private int hitsnum;
public int getHitsnum() {
return hitsnum;
}
public void setHitsnum(int hitsnum) {
this.hitsnum = hitsnum;
}
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}
public String getContent() {
return content;
}
public void setContent(String content) {
this.content = content;
}
public String getUser() {
return user;
}
public void setUser(String user) {
this.user = user;
}
public String getPosttime() {
return posttime;
}
public void setPosttime(String posttime) {
this.posttime = posttime;
}
public String getReplaytxt() {
return replaytxt;
}
public void setReplaytxt(String replaytxt) {
this.replaytxt = replaytxt;
}
}
7=t @ oxOe90 www\src\bean\indexBean.java prpackage bean;
public class indexBean {
private int id;
private String title;
private String user;
private String posttime;
private int hitsnum;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}
public String getUser() {
return user;
}
public void setUser(String user) {
this.user = user;
}
public String getPosttime() {
return posttime;
}
public void setPosttime(String posttime) {
this.posttime = posttime;
}
public int getHitsnum() {
return hitsnum;
}
public void setHitsnum(int hitsnum) {
this.hitsnum = hitsnum;
}
}
-\t A s s
C("c90 www\src\bean\SearchBean.java
package bean;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import data.DataConn;
public class SearchBean {
private String title;
private String user;
private String posttime;
private int hitsnum;
private int id;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public int getHitsnum() {
return hitsnum;
}
public void setHitsnum(int hitsnum) {
this.hitsnum = hitsnum;
}
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}
public String getUser() {
return user;
}
public void setUser(String user) {
this.user = user;
}
public String getPosttime() {
return posttime;
}
public void setPosttime(String posttime) {
this.posttime = posttime;
}
}
ߥt B I}(d90 www\src\bean\showContent.java package bean;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Date;
import data.DataConn;
import bean.ContentBean;
public class showContent {
public ArrayList viewContent(int id) {
ArrayList content = new ArrayList();
String sql = "select * from content where id="+id;
try {
DataConn dataconn = new DataConn();
Connection conn = dataconn.getConn("root", "root", "test");
Statement statement = dataconn.getStatement(conn);
ResultSet rs = dataconn.getResultSet(statement, sql);
while(rs.next()) {
ContentBean art = new ContentBean();
art.setTitle(rs.getString("title"));
art.setContent(rs.getString("content"));
art.setUser(rs.getString("puser"));
art.setPosttime(dataconn.toStrChnYmdHms(rs.getTimestamp("posttime")));
art.setReplaytxt(rs.getString("replay_txt"));
content.add(art);
}
conn.close();
statement.executeUpdate("update `content` set HitsNum = HitsNum +1 where id="+id);
statement.close();
rs.close();
}catch(SQLException ex) {
ex.printStackTrace();
}finally{
//conn.close();
}
return content;
}
}
t @ ~ ~ L+QDze90 www\src\bean\showIndex.java package bean;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import data.DataConn;
public class showIndex {
public static int allsize;
public static int allpage;
public ArrayList indexlist(int nowpage, int pagesize) {
ArrayList list = new ArrayList();
String sql="SELECT * FROM content order by id desc";
try {
DataConn dataconn = new DataConn();
Connection conn = dataconn.getConn("root", "root", "test");
Statement statement = dataconn.getStatement(conn);
ResultSet rs = dataconn.getResultSet(statement, sql);
rs.last();
allsize = rs.getRow();
if(nowpage<1) nowpage=1;
allpage = (allsize+pagesize-1)/pagesize;
if(nowpage>allpage)
nowpage = allpage;
if(allpage>0){
rs.absolute((nowpage-1)*pagesize+1);
int i=0;
while(i