影院售票（简易mvc设计模式）

package cn.Ticket.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import javax.naming.Context; import javax.naming.InitialContext; import javax.naming.NamingException; import javax.sql.DataSource; import cn.Ticket.entity.Ticket; public class TicketBean { private Connection conn; private PreparedStatement pre; private ResultSet rs; private List list; private DataSource ds; // 数据库连接 public Connection dbConnection() { try { Context text = new InitialContext(); ds = (DataSource)text.lookup("java:comp/env/ticket"); conn = ds.getConnection(); } catch(Exception sqlE) { sqlE.printStackTrace(); System.out.print("数据库连接失败！"); } return conn; } public boolean clear() { conn = this.dbConnection(); try { String sql = "update Ticket set Sign=0 where Sign=1"; pre = conn.prepareStatement(sql); pre.executeUpdate(); return true; } catch (SQLException e) { e.printStackTrace(); } return false; } public boolean buy(String Seat[]) { conn = this.dbConnection(); try { StringBuffer sql = new StringBuffer("update Ticket set Sign=1 where Seat in("); for(int i = 0; i < Seat.length; i++) { if(i == Seat.length-1) { sql.append(Seat[i]); sql.append(")"); System.out.println(sql); } else { sql.append(Seat[i]+","); } } pre = conn.prepareStatement(sql.toString()); pre.executeUpdate(); return true; } catch(SQLException e) { e.printStackTrace(); } finally { try { if(rs != null){ rs.close(); } if(conn != null) { conn.close(); } } catch(Exception e) { e.printStackTrace(); } } return false; } public static void main(String[] args) { TicketBean t = new TicketBean(); String[] item = {"11", "22"}; if(t.buy(item)) { System.out.println("chengfong"); }else { System.out.println("sssssss"); } } public int[] selectAll() { int Seat[] = new int[300]; conn = this.dbConnection(); int i = 0; try { String sql = "select Sign from Ticket"; pre = conn.prepareStatement(sql); rs = pre.executeQuery(); while(rs.next()) { Seat[i] = rs.getInt(1); i++; } } catch (SQLException e) { e.printStackTrace(); } return Seat; } }