package movieticket;
import java.sql.*;


public class Bean1 {
    private String seat;


    Connection con=null;
    PreparedStatement spt=null;
    ResultSet rs=null;

    public Bean1() {
    }

    public void setSeat(String seat) {
        this.seat = seat;
    }




    public String getSeat() {
        return seat;
    }




    public boolean sqlupdate1(String seat)
    {

        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            con=DriverManager.getConnection("Jdbc:Odbc:ticket","sa","123");
            spt=con.prepareStatement("update Ticket set sign=1 where seat=?");
            spt.setString(1,seat);
            spt.executeUpdate();

        } catch (Exception ex) {
            System.out.println(ex);
            return false;

        }
        finally
        {
            try
            {
                spt.close();
                con.close();
            }catch(SQLException ex)
            {
                System.out.println(ex);
            }
        }
        return true;
    }

    public boolean sqlupdate2()
    {
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            con=DriverManager.getConnection("Jdbc:Odbc:ticket","sa","123");
            spt=con.prepareStatement("update Ticket set sign=0 ");
            spt.executeUpdate();

        } catch (Exception ex) {
            System.out.println(ex);
            return false;

        }
        finally
        {
            try
            {
                spt.close();
                con.close();
            }catch(SQLException ex)
            {
                System.out.println(ex);
            }
        }
        return true;

    }
    public ResultSet sqlsearch()
    {
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            con=DriverManager.getConnection("Jdbc:Odbc:ticket","sa","123");
            spt=con.prepareStatement("select seat from Ticket where sign=1");

            rs=spt.executeQuery();
            return rs;

        } catch (Exception ex) {
            System.out.println(ex);
            return null;

        }
        finally
        {
            try
            {
                rs.close();
                spt.close();
                con.close();
            }catch(SQLException ex)
            {
                System.out.println(ex);
            }
        }


    }



}