package news.db;
import news.db.*;
import news.form.*;
import java.sql.*;
import java.util.*;
public class NewsDAO{
public int insert(News n){
Connection con = null;
int k=0;
PreparedStatement pstmt = null;
String sql = "";
sql = "insert into news(title,author,content,pubtime)values(?,?,?,now())";
try{
con = DatabaseConnection.getCon();
pstmt = con.prepareStatement(sql);
pstmt.setString(1,n.getTitle());
pstmt.setString(2,n.getAuthor());
pstmt.setString(3,n.getContent());
k=pstmt.executeUpdate();
}catch(Exception e){e.printStackTrace();
}
finally{
try{
if(con!=null){
con.close();
}
}catch(Exception e2){}
}
return k;
}
public ArrayList searchAll(){
Connection con = null;
PreparedStatement pstmt = null;
String sql = "";
ResultSet rs = null;
News n=null;
sql = "select * from news";
ArrayList ar = new ArrayList();
try{
con = DatabaseConnection.getCon();
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
while(rs.next()){
n = new News();
n.setTitle(rs.getString("title"));
n.setAuthor(rs.getString("author"));
n.setContent(rs.getString("content"));
n.setPubtime(rs.getDate("pubtime"));
n.setId(rs.getInt("id"));
ar.add(n);
}
}catch(Exception e){e.printStackTrace();
}
finally{
try{
if(con!=null){
con.close();
}
}catch(Exception e2){}
}
return ar;
}
public int delete(String aa){
Connection con = null;
int k=0;
PreparedStatement pstmt = null;
String sql = "";
sql = "delete from news where id=?";
try{
con = DatabaseConnection.getCon();
pstmt = con.prepareStatement(sql);
pstmt.setString(1,aa);
k=pstmt.executeUpdate();
}catch(Exception e){e.printStackTrace();
}
finally{
try{
if(con!=null){
con.close();
}
}catch(Exception e2){}
}
return k;
}
public News search(String id){
Connection con = null;
PreparedStatement pstmt = null;
String sql = "";
ResultSet rs = null;
News u = new News();
sql = "select * from news where id=?";
try{
con = DatabaseConnection.getCon();
pstmt = con.prepareStatement(sql);
pstmt.setString(1,id);
rs = pstmt.executeQuery();
if(rs.next()){
u.setId(rs.getInt("id"));
u.setTitle(rs.getString("title"));
u.setAuthor(rs.getString("author"));
u.setContent(rs.getString("content"));
u.setPubtime(rs.getDate("pubtime"));
}
}catch(Exception e){e.printStackTrace();
}
finally{
try{
if(con!=null){
con.close();
}
}catch(Exception e2){}
}
return u;
}
public int update(News u){
Connection con = null;
int k=0;
PreparedStatement pstmt = null;
String sql = "";
sql = "update news set title=?,author=?,content=? where id=?";
try{
con = DatabaseConnection.getCon();
pstmt = con.prepareStatement(sql);
pstmt.setString(1,u.getTitle());
pstmt.setString(2,u.getAuthor());
pstmt.setString(3,u.getContent());
pstmt.setInt(4,u.getId());
k=pstmt.executeUpdate();
}catch(Exception e){e.printStackTrace();
}
finally{
try{
if(con!=null){
con.close();
}
}catch(Exception e2){}
}
return k;
}
}
JSP+Struts新闻发布系统
5星 · 超过95%的资源 需积分: 9 190 浏览量
2008-12-18
11:28:47
上传
评论 6
收藏 2.06MB RAR 举报 
.rar （29个子文件） 
newsss 
allnews.jsp 757B addnews.htm 366B WEB-INF news.sql 179B web.xml 1KB classes news form News.class 1KB filter EncodingFilter.class 843B action NewsAction.class 2KB db DatabaseConnection.class 976B NewsDAO.class 4KB EncodingFilter.java 564B NewsAction.java 3KB DatabaseConnection.java 480B News.java 923B NewsDAO.java 4KB struts-config.xml 882B lib 
mysql-connector-java-5.0.0-beta-bin.jar 464KB commons-beanutils.jar 184KB jakarta-oro.jar 64KB standard.jar 384KB commons-validator.jar 82KB commons-fileupload.jar 22KB jstl.jar 20KB commons-logging.jar 37KB struts.jar 531KB antlr.jar 350KB commons-digester.jar 164KB tip.jsp 245B index.htm 207B news.jsp 604B
javagxc
- 粉丝: 103
- 资源: 43
评论5