selectticket.java

订购火车票

package m;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
public class SelectTicket {
	Connection con;
	PreparedStatement ps;
	ResultSet rs;
	String sql;
	
	public ArrayList checkTicket(){
		ArrayList list=new ArrayList();
		con=ConnectionToDB.getCon();
	    sql="select * from Ticket";
		try {
			ps=con.prepareStatement(sql);
			rs=ps.executeQuery();
			while(rs.next()){
				Ticket ticket=new Ticket();
				ticket.setSeat(rs.getString(1));
				ticket.setSign(rs.getInt(2));
				list.add(ticket);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return list;
	}
	
	//此方法用于实现清场的功能
	public void UpdateDB(){
		con=ConnectionToDB.getCon();
		sql="update Ticket set Sign=0";
		try {
			ps=con.prepareStatement(sql);
			ps.executeUpdate();
			ps.close();
			con.close();
			
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
	//此方法用于实现购买的功能
	public void go(String seat){
		
		con=ConnectionToDB.getCon();
		sql="update Tickset Sign=";
		
	}
	
	
	public void buy(String Seat){
		con=ConnectionToDB.getCon();

		sql="update Ticket set Sign=1 where Seat=?";
		try {
			ps=con.prepareStatement(sql);
			ps.setString(1, Seat);
			ps.executeUpdate();

		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}