src/com/movie/dao/MovieDao.java

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

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

package com.movie.dao;

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

import com.movie.pojo.Movie;

public class MovieDao extends Dao{
	int flag=0;
	/**
	 * 添加一条电影记录
	 * @param notice
	 * @return 标识flag 
	 */
	public int movieAdd(Movie movie){
    	try{
    	  this.getConnection();
    	  String sql="insert tb_movie(movieName,kindId,state,photo) values(?,?,?,?)";
    	  pstat=cn.prepareStatement(sql);
    	  pstat.setString(1,movie.getMovieName());
    	  pstat.setString(2,movie.getKindId());
    	  pstat.setString(3, movie.getState());
    	  pstat.setString(4, movie.getPhoto());
    	  flag=pstat.executeUpdate();
    	}catch(SQLException e){
    		e.printStackTrace();
    	}
    	return flag;
    	
    }
	/**
	 * 查询所有电影记录
	 * @return 记录集合list
	 */
	public List<Movie> getMovie(int typeId){
		List<Movie> list = new ArrayList<Movie>();
    	try{
    	  this.getConnection();
    	  String sql;
    	  if(typeId==0){
    		  sql="select * from v_movie";
    	  }else{
    		  sql="select * from v_movie where kindId='"+typeId+"'";
    	  }
    	  pstat=cn.prepareStatement(sql);
    	  rs=pstat.executeQuery();
    	
    	  while(rs.next()){
    		  Movie movie=new Movie();
    		  movie.setId(rs.getString(1));
    		  movie.setMovieName(rs.getString(2));
    		  movie.setScore(rs.getString(3));
    		  movie.setState(rs.getString(4));
    		  movie.setKindId(rs.getString(5));
    		  movie.setKindName(rs.getString(6));
    		  movie.setPhoto(rs.getString("photo"));
    		  list.add(movie);
    	  }
    	}catch(SQLException e){