新闻管理系统（MVC的模式）

package NewsManagerDAOImp; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import NewsManagerCreatConandDAO.Conn; import NewsManagerCreatConandDAO.NewsManagerAdminDAO; import NewsManagerJbn.AdminUser; import NewsManagerJbn.NewsDetail; public class NewsManagerAdminDAOImp implements NewsManagerAdminDAO{ Connection con =null; PreparedStatement pst = null; ResultSet rs = null; //管理员登陆 public AdminUser getAdminUserByNameAndPass(String username,String password) { AdminUser au=new AdminUser(); con=Conn.getConn(); try { pst=con.prepareStatement("select * from admin where adminname=? and adminpass=?"); pst.setString(1, username); pst.setString(2, password); rs=pst.executeQuery(); if(rs.next()) { au.setId(rs.getInt(1)); au.setAdminname(rs.getString(2)); au.setAdminpass(rs.getString(3)); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return au; } //管理员根据id删除新闻 public boolean AdminUserDeleteNews(String string) { con=Conn.getConn(); boolean deleteNews=false; String sql="delete from newsdetail where id=?"; try { pst=con.prepareStatement(sql); pst.setString(1,string); int i=pst.executeUpdate(); if(i>0) { deleteNews = true; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return deleteNews; } //管理员查询新闻的内容 public NewsDetail getNews(String userID) { con=Conn.getConn(); NewsDetail nd=new NewsDetail(); try { pst=con.prepareStatement("select * from newsdetail where id=?"); pst.setString(1,userID); rs=pst.executeQuery(); while(rs.next()) { nd.setId(rs.getString(1)); nd.setTitle(rs.getString(2)); nd.setContent(rs.getString(3)); nd.setAuthor(rs.getString(4)); nd.setTime(rs.getDate(5)); nd.setType(rs.getString(6)); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return nd; } //管理员编辑新闻 public boolean updateNews(NewsDetail newsDetail) { con=Conn.getConn(); // boolean isfang=false; String sql="update newsdetail set title=?, content=?, author=?,type=? where id=?"; try { pst=con.prepareStatement(sql); pst.setString(1,newsDetail.getTitle()); pst.setString(2,newsDetail.getContent()); pst.setString(3,newsDetail.getAuthor()); //pst.setDate(5, (Date) newsDetail.getTime()); pst.setString(4,newsDetail.getType()); pst.setString(5, newsDetail.getId()); int updateNews=pst.executeUpdate(); if(updateNews>0){ return true; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return false; } //添加新闻 public boolean addUser(NewsDetail newsdetail) { con=Conn.getConn(); boolean isfang=false; try { pst=con.prepareStatement("insert into newsdetail(title,content,author,type)values( ?,?,?,?)"); pst.setString(1, newsdetail.getTitle()); pst.setString(2, newsdetail.getContent()); pst.setString(3, newsdetail .getAuthor()); pst.setString(4, newsdetail .getType()); int i=pst.executeUpdate(); if(i>0) { isfang=true; }else{ isfang=false; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return isfang; } }