src/com/movie/dao/AdvanceDao.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.movie.dao;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.movie.pojo.Advance;

public class AdvanceDao extends Dao{
	int flag=0;
	  Advance advance=new Advance();

	
	/**
	 * 添加一条预告片记录
	 * @param notice
	 * @return 标识flag 
	 */
	public int advanceAdd(Advance advance){
    	try{
    	  this.getConnection();
    	  String sql="insert tb_advance(movieId,actor,director,submitTime,film,introduce,readNum) values('"+advance.getMovieId()+"',?,?,?,?,?,0)";
    	  pstat=cn.prepareStatement(sql);
    	  pstat.setString(1,advance.getActor());
    	  pstat.setString(2,advance.getDirector());
    	  pstat.setString(3,advance.getSubmitTime());
    	  System.out.println("advadao27:"+advance.getFilm());
    	  pstat.setString(4,advance.getFilm());
    	  pstat.setString(5,advance.getIntroduce());
    	  flag=pstat.executeUpdate();
    	}catch(SQLException e){
    		e.printStackTrace();
    	}
    	return flag;
    	
    }
	/**
	 * 查询所有预告片记录
	 * @return 记录集合list
	 */
	public List<Advance> getadvance(){
		List<Advance> list = new ArrayList<Advance>();
    	try{
    	  this.getConnection();
    	  String sql="select * from v_advance";
    	  pstat=cn.prepareStatement(sql);
    	  rs=pstat.executeQuery();
    	
    	  while(rs.next()){
    		  Advance advance=new Advance();
    		  advance.setId(rs.getString(1));
    		  advance.setReadNum(rs.getString("readNum").trim());
    		  advance.setActor(rs.getString("actor").trim());
    		  advance.setDirector(rs.getString("director").trim());
    		  advance.setFilm(rs.getString("film"));
    		  advance.setIntroduce(rs.getString("introduce").trim());
    		  advance.setMovieName(rs.getString("movieName").trim());
    		  advance.setSubmitTime(rs.getString("submitTime").trim());
    		  advance.setKindName(rs.getString("kindName"));
    		  list.add(advance);