bean1.java~15~

电影院售票网站的一个小程序, 无数据库,(已生成SQL脚本) 实现售票和座位查寻功能.

package movieticket;
import java.sql.*;


public class Bean1 {
    private String seat;
    private int sign;

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

    public Bean1() {
    }

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

    public void setSign(int sign) {
        this.sign = sign;
    }


    public String getSeat() {
        return seat;
    }

    public int getSign() {
        return sign;
    }


    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;
    }



}