newsdao.java

毕业设计JSP公交车查询系统

package bus.dao;
import bus.bean.NewsBean;
import bus.bean.*;
import bus.db.*;

import java.sql.*;
import java.util.ArrayList;
public class NewsDao {
		private	Conn c=new Conn();
//		private Connection connection;
		private PreparedStatement prepar;
		private ResultSet res;
       
		public boolean addNewsBean(NewsBean news)
	    {
	        boolean flag = false;
	        String sql = "insert into news (title,content,datenews,sale) values(?,?,?,?)";
	        
	      
	        try
	        {
	            prepar = c.getPre(sql);
	            prepar.setString(1, news.getTitle());
	            prepar.setString(2,  news.getContent());
	            prepar.setString(3, news.getDatenews());
	            prepar.setInt(4, news.getSale());
	         
	            int result = prepar.executeUpdate();
	            if (result > 0)
	            {
	                flag = true;
	            }
	            else
	            {
	                flag = false;
	            }

	        }
	        catch (Exception ex)
	        {
	            flag = false;
	            ex.printStackTrace();
	        }

	        return flag;
	    }

		public ArrayList getList1(int id)
		{
			ArrayList list=new ArrayList();
			
			try
		    {
		        String sql="select * from news where type_id=?";
		        prepar = c.getPre(sql);
		        prepar.setInt(1,id);
		        res=prepar.executeQuery();
		        while(res.next())
		        {
		        	NewsBean news=new NewsBean();
		        	news.setContent(res.getString("content"));
		        	news.setDatenews(res.getString("datenews"));
		        	news.setTitle(res.getString("title"));
		        	
		        	news.setId(res.getInt("id"));
		        	list.add(news);
		       
		        }
		        
		    }
		    catch (Exception e)
		    {
		      list=null;
		        e.printStackTrace();
		    }
		    
		    return list;
		}
	    public ResultSet getNewsResultSet(String sql)
	    {
	    	return c.executeQuery(sql);
	    }
	    
	    public boolean deletNews(int news_id)
	    {
	    	boolean flag = false;
	    	
	        String sql = "delete from news where id=?";
	        try
	        {
	           
	            prepar  = c.getPre(sql);
	           
	            prepar.setInt(1, news_id);
	            int result = prepar.executeUpdate();
	            if (result > 0)
	            {
	                flag = true;
	            }
	            else
	            {
	                flag = false;
	            }
	        }
	        catch (Exception ex)
	        {
	            flag = false;
	            ex.printStackTrace();
	        }
	        return flag;
	    	
	    }
	    public boolean updateNews(NewsBean news)
	    {
	    	boolean flag = false;
	        String sql = "update news set  title=? , content=? , datenews=? ,sale=? where id=?";
	        try
	        {
	            
	            prepar  = c.getPre(sql);
	           
	            prepar.setString(1, news.getTitle());
	            prepar.setString(2, news.getContent());
	            prepar.setString(3, news.getDatenews());
	            prepar.setInt(4, news.getSale());
	            prepar.setInt(5, news.getId());

	            int result = prepar.executeUpdate();
	            if (result > 0)
	            {
	                flag = true;
	            }
	            else
	            {
	                flag = false;
	            }
	        }
	        catch (Exception ex)
	        {
	            flag = false;
	            ex.printStackTrace();
	        }
	        return flag;
	    }
	
	    public NewsBean selectNews(int id)
	    {
	    	ResultSet result=null;
	    	String content=null;
	    	   String title=null;
	    	   NewsBean news=new NewsBean();
	        String sql = "select * from news  where id=?";
	        try
	        {
	            
	            prepar  = c.getPre(sql);
	           
	            prepar.setInt(1, id);

	            result = prepar.executeQuery();
               while(result.next()){
	    		title= result.getString("title");
	    		content= result.getString("content");
	    		
	            news.setTitle(title);
	            news.setContent(content);
               }
	        }
	        catch (Exception ex)
	        {
	        	System.out.println("heloman!!");
	        	news=null;
	            ex.printStackTrace();
	        }
	        return news;
	    }
	    public boolean deletAllNews(int sale)
	    {
	    	boolean flag = false;
	    	
	        String sql = "delete from news where sale=?";
	        try
	        {
	            
	            prepar  = c.getPre(sql);
	           
	            prepar.setInt(1, sale);
	            int result = prepar.executeUpdate();
	            if (result > 0)
	            {
	                flag = true;
	            }
	            else
	            {
	                flag = false;
	            }
	        }
	        catch (Exception ex)
	        {
	            flag = false;
	            ex.printStackTrace();
	        }
	        return flag;
	    	
	    }
}