zhandiandao.java

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

package bus.dao;

import java.sql.PreparedStatement;
import java.sql.ResultSet;

import bus.bean.UserBean;
import bus.bean.ZhanDianBean;
import bus.db.Conn;
import java.util.*;
public class ZhanDianDao {

	private	Conn c=new Conn();
//	private Connection connection;
	private PreparedStatement prepar;
	private ResultSet res;
	
	public boolean addZhanDianBean(ZhanDianBean zhandian)
    {
        boolean flag = false;
        String sql = "insert into zhandian (line_id,content) values(?,?)";
        try
        {
            prepar = c.getPre(sql);
            prepar.setInt(1, zhandian.getLine_id()); 
            prepar.setString(2, zhandian.getContent()); 
            
            int result = prepar.executeUpdate();
            if (result > 0)
            {
                flag = true;
            }
            else
            {
                flag = false;
            }

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

        return flag;
    }
	
	   public ResultSet getUserResultSet(String sql)
	    {
	    	return c.executeQuery(sql);
	    }
	    
	   public boolean deletZhan(int line_id)
	    {
	    	boolean flag = false;
	        String sql = "delete from zhandian where line_id=?";
	        try
	        {
	           
	            prepar  = c.getPre(sql);
	           
	            prepar.setInt(1, line_id);
	            int result = prepar.executeUpdate();
	            if (result > 0)
	            {
	                flag = true;
	            }
	            else
	            {
	                flag = false;
	            }
	        }
	        catch (Exception ex)
	        {
	            flag = false;
	            ex.printStackTrace();
	        }
	        return flag;
	    	
	    }
	   public boolean deletDiaoCha1(int id)
	    {
	    	boolean flag = false;
	        String sql = "delete from diaocha1 where id=?";
	        try
	        {
	           
	            prepar  = c.getPre(sql);
	           
	            prepar.setInt(1, id);
	            int result = prepar.executeUpdate();
	            if (result > 0)
	            {
	                flag = true;
	            }
	            else
	            {
	                flag = false;
	            }
	        }
	        catch (Exception ex)
	        {
	            flag = false;
	            ex.printStackTrace();
	        }
	        return flag;
	    	
	    }
	    
	    
	   public ArrayList checkLogin(int id)
		{
		   ArrayList list=new ArrayList();
		   String flag="";
		  
		    try
		    {
		        String sql="select * from zhandian where line_id=?";
		        
		        prepar = c.getPre(sql);
		        prepar.setInt(1, id);
		        
		       
		        res = prepar.executeQuery();
		       
		        while(res.next())
		        {
		        	
		        	flag=res.getString("content");
		        	list.add(flag);
		        	
		        }
		    }
		    catch (Exception e)
		    {
		        list = null;
		        e.printStackTrace();
		    }
		    return list;
		}   
	  
}