jsp+servlet视频网站

package netVideo.dao.impl; import java.io.PrintStream; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import netVideo.Utils.DBUtils; import netVideo.Utils.StringUtils; import netVideo.bean.Video; import netVideo.dao.VideoDao; public class VideoDaoImpl implements VideoDao { public ArrayList<String> ListFirSub() { Statement stat = DBUtils.getStmt(); String sqlstr = "select * from video group by firsub"; try { ResultSet set = stat.executeQuery(sqlstr); ArrayList list = new ArrayList(); while (set.next()) { list.add(StringUtils.ToLocal(set.getString("firsub"))); } return list; } catch (SQLException e) { e.printStackTrace(); } return null; } public ArrayList<String> ListSecSub(String Firsub) { Statement stat = DBUtils.getStmt(); String sqlstr = "select * from video where firsub like '" + Firsub + "' group by secsub"; try { ResultSet set = stat.executeQuery(sqlstr); ArrayList list = new ArrayList(); while (set.next()) { list.add(StringUtils.ToLocal(set.getString("secsub"))); } return list; } catch (SQLException e) { System.err.println("二级科目显示异常"); } return null; } public int getRowCount(String Firsub) { Statement stat = DBUtils.getStmt(); String sqlstr = "select count(*) from video where firsub like '" + Firsub + "' group by secsub"; try { ResultSet set = stat.executeQuery(sqlstr); if (set.next()) { return set.getInt(1); } } catch (SQLException e) { e.printStackTrace(); } return 0; } public ArrayList<String> List(String Secsub) { Statement stat = DBUtils.getStmt(); String sqlstr = "select * from video where secsub like '" + Secsub + "' group by videoname"; try { ResultSet set = stat.executeQuery(sqlstr); ArrayList list = new ArrayList(); while (set.next()) { list.add(StringUtils.ToLocal(set.getString("videoname"))); } return list; } catch (SQLException e) { e.printStackTrace(); } return null; } public String getAddr(String source) { Statement stat = DBUtils.getStmt(); String sqlstr = "select * from video where videoname like '" + source + "'"; try { ResultSet set = stat.executeQuery(sqlstr); if (set.next()) { return set.getString("URL"); } } catch (SQLException e) { e.printStackTrace(); } return null; } public boolean findSource(String source) { Statement stat = DBUtils.getStmt(); String sqlstr = "select * from video where videoname like '" + source + "'"; try { ResultSet set = stat.executeQuery(sqlstr); while (set.next()) { if (set.getString("videoname").equals(source)) { return true; } } } catch (SQLException e) { e.printStackTrace(); } return false; } public boolean addvideo(Video video) { String source = video.getVideoname(); if (findSource(source)) { return false; } Statement stat = DBUtils.getStmt(); String sqlstr = "insert into upload values('" + video.getFirsub() + "','" + video.getSecsub() + "','" + video.getVideoname() + "','" + video.getOwner() + "','" + video.getURL() + "')"; try { if (stat.executeUpdate(sqlstr) > 0) { return true; } } catch (SQLException e) { e.printStackTrace(); } return false; } }