dao.java

java做的机票查询系统、 仅供初学者参考！ 包含了数据库！！

package GaoerferPackage;

import java.sql.*;
import java.util.*;
import GaoerferPackage.DBUtil;
import GaoerferPackage.Bean;
/**
 * 操作方法类
 * @author Administrator
 *
 */
public class DAO {
	private java.sql.ResultSet rs=null;
	private java.sql.PreparedStatement ps=null;
	private java.sql.Connection con=null;
	
	/**
	 * 根据会员卡号查询密码的方法
	 * @param card
	 * @return
	 */
	public Bean getCard_Password(String card) {
		
		Bean bean=null;
		DBUtil db=new DBUtil();
		
		try {
			con=db.getConnection();
		    String sql="select * from Card where CardNo=?";
		    ps=con.prepareStatement(sql);
		    ps.setString(1, card);
		    rs=ps.executeQuery();
		    
		    while(rs.next()) {
		    	bean=new Bean();
		    	//bean.setMCard(rs.getString(1));
		    	bean.setMPassword(rs.getString(2));

		    }
		    
		}
		catch(java.sql.SQLException sqle) {
			sqle.printStackTrace();
		}
		finally {
			db.close(rs, ps, con);
		}
		return bean;
		
		
	}
	
	/**
	 * 根据球场查询价格的方法
	 * @param court
	 * @return
	 */
    public Bean getPrice(String court,int num) {
		
		Bean bean=null;
		DBUtil db=new DBUtil();
		
		try {
			con=db.getConnection();
		    String sql="select Price from Court where CourtName=?";
		    ps=con.prepareStatement(sql);
		    ps.setString(1, court);
		    rs=ps.executeQuery();
		    
		    while(rs.next()) {
		    	bean=new Bean();
		    	bean.setMCourt(court);
		    	bean.setMNum(num);
		    	bean.setMPrice(rs.getFloat("Price"));

		    }
		    
		}
		catch(java.sql.SQLException sqle) {
			sqle.printStackTrace();
		}
		finally {
			db.close(rs, ps, con);
		}
		return bean;
		
		
	}

}