java swing实现电影购票系统

/** * 执行增删改的操作 * @param sql * @param param * @return */ public static boolean operUpdate(String sql, List<Object> param) { int res = 0;// 获得影响的行数 Connection conn = null;// 获取连接 PreparedStatement psts = null;// 装载sql语句 ResultSet rs = null; conn = getConn(); try { psts = conn.prepareStatement(sql); if (param != null) { for (int i = 0; i < param.size(); i++) {  psts.setObject(i + 1, param.get(i)); } } res = psts.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } finally { closeAll(rs, psts, conn);//关闭相关的连接 } return res > 0 ? true : false; }

/** * 执行查找的操作 * @param sql * @param param * @return */ public static <T> List<T> operQuery(String sql, List<Object> param, Class<T> cls) { Connection conn = null;// 获取连接 PreparedStatement psts = null;// 装载sql语句 ResultSet rs = null; conn = getConn(); List<T> list = new ArrayList<T>(); try { psts = conn.prepareStatement(sql); if (param != null) { for (int i = 0; i < param.size(); i++) {  psts.setObject(i + 1, param.get(i)); } } rs=psts.executeQuery(); ResultSetMetaData rsmd = rs.getMetaData(); while(rs.next()){ T entity = cls.newInstance(); for(int j =0;j<rsmd.getColumnCount();j++){  String columnName = rsmd.getColumnName(j+1);  Object value = rs.getObject(columnName);  Field fields = cls.getDeclaredField(columnName);  fields.setAccessible(true);  fields.set(entity, value); } list.add(entity); } } catch (SQLException e) { e.printStackTrace(); } catch (InstantiationException e) { e.printStackTrace(); } catch (IllegalAccessException e) { e.printStackTrace(); } catch (NoSuchFieldException e) { e.printStackTrace(); } catch (SecurityException e) { e.printStackTrace(); } finally { closeAll(rs, psts, conn); } return list; }