saledaoformysql.java

老师给的在线航班系统

package com.toa.abs.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;
import java.util.Set;

import com.toa.abs.model.Branch;
import com.toa.abs.model.Sales;

public class SaleDaoForMySql implements SaleDAO{
	private String configFileName;
	
	public SaleDaoForMySql(String configFileName){
		this.configFileName=configFileName;
	}
	
	public boolean addSales(Sales user) {
		//加载驱动
		//建立连接
		//得到Statement
		//执行SQL
		//返回结果
		//释放资源
		
		return false;
	}

	public Set getAllSales() {
		
		return null;
	}

	public Sales getSale(String name, String passwd) {
		//实现该方法
		Connection conn=null;
		PreparedStatement pstm=null;
		ResultSet rs=null;
		
		conn=JDBCUtil.getConnection(configFileName);
		try {
			pstm=conn.prepareStatement("select s.id,s.name"+
					",b.id,b.name,b.address,b.telphone"+
					",b.province,b.city "+
					"from sales s,branch b where s.branch_id=b.id and"+
					" s.name= ? and s.password=?");
			pstm.setString(1, name);
			pstm.setString(2, passwd);
			rs=pstm.executeQuery();
			if(rs.next()){
				Branch b=new Branch();
				b.setId(rs.getInt("b.id"));
				b.setName(rs.getString("b.name"));
				b.setAddress(rs.getString("b.address"));
				b.setCity(rs.getString("b.city"));
				b.setTelephone(rs.getString("b.telphone"));
				b.setProvince(rs.getString("b.province"));
				
				Sales s=new Sales();
				s.setId(rs.getInt("s.id"));
				s.setName(rs.getString("s.name"));
				s.setBelongBranch(b);
				
				return s;
				
			}else{
				return null;
			}
			
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			if(rs!=null)try{rs.close();}catch(SQLException e){}
			if(pstm!=null)try{pstm.close();}catch(SQLException e){}
			if(conn!=null)try{conn.close();}catch(SQLException e){}
		}
		
		return null;
	}

	public boolean modifyPassword(String name, String oldPassword, String newPassword) {
		
		return false;
	}

	public boolean removeSales(String name) {
		
		return false;
	}

}