package com.mi.dao; import java.util.ArrayList; import java.util.List; import com.mi.entity.Film; public class FilmDao extends BaseDao { /********警속**************/ public int addFilm(Film film) { String sql = "insert into filmdb values(seqfid.nextval,?,?,?,?,?,?,?,to_date(?,'yyyy-mm-dd'))"; try { this.openConn(); ps = conn.prepareStatement(sql); ps.setString(1, film.getFname()); ps.setString(2, film.getFdire()); ps.setString(3, film.getFplayer()); ps.setString(4, film.getFintr()); ps.setString(5, film.getFpic()); ps.setInt(6, film.getFexpo()); ps.setString(7, film.getFcate()); ps.setString(8, film.getFdate()); return ps.executeUpdate(); } catch (Exception e) { e.printStackTrace(); } finally { this.closeConn(); } return 0; } /**********************몽앴name꿴冷寧몸*************/ public List<Film> findFilmByFname(String fname) { List<Film> list = new ArrayList<Film>(); try { this.openConn(); String sql = "select * from filmdb where fname = ?"; ps = conn.prepareStatement(sql); ps.setString(1, fname); rs = ps.executeQuery(); if (rs.next()) { Film film = new Film(); film.setFid(rs.getInt("fid")); film.setFname(rs.getString("fname")); film.setFdire(rs.getString("fdire")); film.setFplayer(rs.getString("fplayer")); film.setFintr(rs.getString("fintr")); film.setFpic(rs.getString("fpic")); film.setFexpo(rs.getInt("fexpo")); film.setFcate(rs.getString("fcate")); film.setFdate(rs.getString("fdate")); list.add(film); } } catch (Exception e) { e.printStackTrace(); } finally { this.closeConn(); } return list; } /**********************몽앴id꿴冷寧몸*************/ public Film findFilmByFid(Integer fid) { Film film = null; try { this.openConn(); String sql = "select * from filmdb where fid = ?"; ps = conn.prepareStatement(sql); ps.setInt(1, fid); rs = ps.executeQuery(); if (rs.next()) { film = new Film(); film.setFid(rs.getInt("fid")); film.setFname(rs.getString("fname")); film.setFdire(rs.getString("fdire")); film.setFplayer(rs.getString("fplayer")); film.setFintr(rs.getString("fintr")); film.setFpic(rs.getString("fpic")); film.setFexpo(rs.getInt("fexpo")); film.setFcate(rs.getString("fcate")); film.setFdate(rs.getString("fdate")); } } catch (Exception e) { e.printStackTrace(); } finally { this.closeConn(); } return film; } /************삿혤杰唐*************/ public List<Film> getAll(){ List<Film> list = new ArrayList<Film>(); String sql = "select * from filmdb "; try { this.openConn(); ps = this.conn.prepareStatement(sql); rs = ps.executeQuery(); while (rs.next()) { Film film = new Film(); film = new Film(); film.setFid(rs.getInt("fid")); film.setFname(rs.getString("fname")); film.setFdire(rs.getString("fdire")); film.setFplayer(rs.getString("fplayer")); film.setFintr(rs.getString("fintr")); film.setFpic(rs.getString("fpic")); film.setFexpo(rs.getInt("fexpo")); film.setFcate(rs.getString("fcate")); film.setFdate(rs.getString("fdate")); list.add(film); } } catch (Exception e) { e.printStackTrace(); }finally{ this.closeConn(); } return list; } /************몽앴잚깎삿혤*************/ public List<Film> getByFcate(String fcate){ List<Film> list = new ArrayList<Film>(); String sql = "select * from filmdb where fcate = ?"; try { this.openConn(); ps = this.conn.prepareStatement(sql); ps.setString(1, fcate); rs = ps.executeQuery(); while (rs.next()) { Film film = new Film(); film = new Film(); film.setFid(rs.getInt("fid")); film.setFname(rs.getString("fname")); film.setFdire(rs.getString("fdire")); film.setFplayer(rs.getString("fplayer")); film.setFintr(rs.getString("fintr")); film.setFpic(rs.getString("fpic")); film.setFexpo(rs.getInt("fexpo")); film.setFcate(rs.getString("fcate")); film.setFdate(rs.getString("fdate")); list.add(film); } } catch (Exception e) { e.printStackTrace(); }finally{ this.closeConn(); } return list; } }