linedao.java

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

package bus.dao;

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



import bus.bean.LineBean;
import bus.dao.ZhanDianDao;
import bus.db.Conn;

public class LineDao {
	private	Conn c=new Conn();
//	private Connection connection;
	private PreparedStatement prepar;
	private ResultSet res;
	private ZhanDianDao dd=new ZhanDianDao();
	public boolean addDiaoChaBean(LineBean line)
    {
        boolean flag = false;
        String sql = "insert into line (name) values(?)";
        try
        {
            prepar = c.getPre(sql);
            prepar.setString(1, line.getName()); 
           // prepar.setInt(2, diaocha.getSale()); 
            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 deletLine(int id)
	    {
	    	boolean flag = false;
	        String sql = "delete from line where id=?";
	        try
	        {
	           
	            prepar  = c.getPre(sql);
	            
	            prepar.setInt(1, id);
	            dd.deletZhan(id); 
	            int result = prepar.executeUpdate();
	            if (result > 0)
	            {
	                flag = true;
	            }
	            else
	            {
	                flag = false;
	            }
	        }
	        catch (Exception ex)
	        {
	            flag = false;
	            ex.printStackTrace();
	        }
	        return flag;
	    	
	    }
	   
	    public int selectId(String title)
	    {
	    	int id=0;
	    	String sql = "select id from line where name=?";
	        try
	        {
	           
	            prepar  = c.getPre(sql);
	            
	            prepar.setString(1, title);
	            
	            res = prepar.executeQuery();
	            while(res.next())
	            {
	                id = res.getInt("id");
	            }
	            
	        }
	        catch (Exception ex)
	        {
	            id=0;
	            ex.printStackTrace();
	        }
	        return id;
	    	
	    	
	    }
	    
	    
	    public boolean updateDiaoCha(LineBean diaocha)
	    {
	    	boolean flag = false;
	        String sql = "update line set  sale=? where id=?";
	        try
	        {
	            
	            prepar  = c.getPre(sql);
	           
	           
	            prepar.setInt(1,  diaocha.getSale());
	            prepar.setInt(2, diaocha.getId());
	            int result = prepar.executeUpdate();
	            if (result > 0)
	            {
	                flag = true;
	            }
	            else
	            {
	                flag = false;
	            }
	        }
	        catch (Exception ex)
	        {
	            flag = false;
	            ex.printStackTrace();
	        }
	        return flag;
	    }
}