漫画推荐系统javaweb

package org.user.dao.impl; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import org.dao.user.IusersDao; import org.student.Util.DBUtils; import org.student.entity.Student; import org.user.Util.usersDBUtils; import org.user.entity.Bjedu; import org.user.entity.BookName; import org.user.entity.BookScore; import org.user.entity.Users; import org.user.entity.liuyan; import org.user.entity.totalman; public class usersdaoImpl implements IusersDao{ public boolean isExist(String username) { return QueryUserBySon(username)!=null?true:false; } public boolean isLiuyanExist(String username) { return QueryLiuyanByUsername(username)!=null?true:false; } public boolean isBookScoreExist(String username,String bookname) { if(QueryBookScoreByUsername(username)!=null?true:false) { BookName ceshi = null; ArrayList<String> arr = new ArrayList<String>(); boolean result = true; ceshi = BookNameByUsername(username); arr=ceshi.getBookname(); for(int i = 0;i<arr.size();i++) { if(arr.get(i).equals(bookname)) { result = false; } } return result; } return true; } public int AddUsers(Users user){ String sql = "insert into yonghu values(?,?,?)"; Object params[] = {user.getUsername(),user.getPassword(),user.getUserpwd()}; return usersDBUtils.executeUpdate(sql, params); } public int AddBookScore(BookScore bookscore){ String sql = "insert into bookscore values(?,?,?)"; Object params[] = {bookscore.getUsername(),bookscore.getBookname(),bookscore.getScore()}; return usersDBUtils.executeUpdate(sql, params); } public int AddLiuyan(liuyan liuyan){ String sql = "insert into liuyan values(?,?,?,?)"; Object params[] = {liuyan.getUsername(),liuyan.getAge(),liuyan.getSex(),liuyan.getTextarea()}; return usersDBUtils.executeUpdate(sql, params); } public liuyan QueryLiuyanByUsername(String username) { liuyan liuyan = null; ResultSet rs = null; try { String sql = "select * from liuyan where username = ?"; Object params[] = {username}; rs = usersDBUtils.executeQuery(sql, params); if(rs.next()) { //当只有一条记录时，使用if String uname =rs.getString("username"); int age =rs.getInt("age"); String sex = rs.getString("sex"); String textarea = rs.getString("textarea"); liuyan = new liuyan(uname,age,sex,textarea); } return liuyan; } catch (ClassNotFoundException e) { e.printStackTrace(); return null; } catch(SQLException e) { e.printStackTrace(); return null; } catch(Exception e) { e.printStackTrace(); return null; } finally { try { if(usersDBUtils.conn!=null)usersDBUtils.conn.close(); if(usersDBUtils.pstmt!=null)usersDBUtils.pstmt.close(); if(rs!=null)rs.close(); }catch(SQLException e) { e.printStackTrace(); } } } public int GetBookScoreByBookName(String username,String bookname){ String sql = "select count(1) from bookscore where username= ? and bookname= ? "; Object params[] = {username,bookname}; return usersDBUtils.getBookScoreByBookName(sql, params); } public BookName BookNameByUsername(String username) { ArrayList<String> result = new ArrayList<String>(); BookName bn = null; ResultSet rs = null; try { String sql = "select bookname from bookscore where username = ?"; Object params[] = {username}; rs = usersDBUtils.executeQuery(sql, params); while(rs.next()) { //当只有一条记录时，使用if String uname =rs.getString(1); result.add(uname); } bn = new BookName(result,username); return bn; } catch (ClassNotFoundException e) { e.printStackTrace(); return null; } catch(SQLException e) { e.printStackTrace(); return null; } catch(Exception e) { e.printStackTrace(); return null; } finally { try { if(usersDBUtils.conn!=null)usersDBUtils.conn.close(); if(usersDBUtils.pstmt!=null)usersDBUtils.pstmt.close(); if(rs!=null)rs.close(); }catch(SQLException e) { e.printStackTrace(); } } } public BookScore QueryBookScoreByUsername(String username) { BookScore bookscore = null; ResultSet rs = null; try { String sql = "select * from bookscore where username = ?"; Object params[] = {username}; rs = usersDBUtils.executeQuery(sql, params); if(rs.next()) { //当只有一条记录时，使用if String uname =rs.getString("username"); String bookname = rs.getString("bookname"); int score = rs.getInt("score"); bookscore = new BookScore(uname,bookname,score); } return bookscore; } catch (ClassNotFoundException e) { e.printStackTrace(); return null; } catch(SQLException e) { e.printStackTrace(); return null; } catch(Exception e) { e.printStackTrace(); return null; } finally { try { if(usersDBUtils.conn!=null)usersDBUtils.conn.close(); if(usersDBUtils.pstmt!=null)usersDBUtils.pstmt.close(); if(rs!=null)rs.close(); }catch(SQLException e) { e.printStackTrace(); } } } public List<liuyan> queryliuyanPage(int currentPage, int pageSize) { List<liuyan> liuyans = new ArrayList<liuyan>(); liuyan liuyan = null; ResultSet rs = null; // String sql = "select * from" // +"(" // +"select rownum r,t.* from" // +"(select s.* from liuyan s order by age asc) t" // +" where rownum<=?" // +")" // +"where r>=?" // ; String sql="select * from liuyan limit ?,?"; //Object[] params = {currentPage*pageSize,(currentPage-1)*pageSize+1}; Object[] params = {currentPage*pageSize,pageSize}; try { rs = usersDBUtils.executeQuery(sql, params); // TODO Auto-generated method stub while(rs.next()) { //当只有一条记录时，使用if String uname = rs.getString("username"); int age = rs.getInt("age"); String sex =rs.getString("sex"); String textarea=rs.getString("textarea"); liuyan = new liuyan(uname,age,sex,textarea); liuyans.add(liuyan); } return liuyans; } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); return null; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); return null; } finally { try { if(usersDBUtils.conn!=null)usersDBUtils.conn.close(); if(usersDBUtils.pstmt!=null)usersDBUtils.pstmt.close(); if(rs!=null)rs.close(); }catch(SQLException e){ e.printStackTrace(); } } } public List<BookScore> QueryAllBookScore() { List<BookScore> bookscores = new ArrayList<BookScore>(); BookScore bookscore = null; ResultSet rs = null; String sql="select * from bookscore"; Object[] params = null; try { rs = usersDBUtils.executeQuery(sql, params); // TODO Auto-generated method stub while(rs.next()) { //当只有一条记录时，使用if String uname = rs.getString("username"); String bookname =rs.getString("bookname"); int score=rs.getInt("score"); bookscore = new BookScore(uname,bookname,score); bookscores.add(bookscore); } return bookscores; } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); return null; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); return null; } finally { try { if(usersDBUtils.conn!=null)usersDBUtils.conn.close(); if(usersDBUtils.pstmt