wenku（三）

DocDao.java

package wenku.dao;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.util.List;import java.util.Vector;import wenku.vo.DocVo;public class DocDao {public List findbyAll(Connection _conn, String strSql){Vector v = new Vector();//定义 存放SQL语句的 StringBufferStringBuffer sbSQL = null;//定义 PreparedStatementPreparedStatement ps = null;//定义数据库链接Connection conn = null;ResultSet rs=null;try{conn = _conn;sbSQL = new StringBuffer();sbSQL.append("select * from  document  where  "); sbSQL.append(strSql); ps = conn.prepareStatement(sbSQL.toString());//执行SQLrs = ps.executeQuery();while(rs.next()){DocVo vo1= new DocVo();vo1.setD_id(rs.getInt("d_id"));vo1.setC_id(rs.getInt("c_id"));vo1.setTitle(rs.getString("title"));vo1.setAuthor(rs.getString("author"));vo1.setUrl(rs.getString("url"));vo1.setType(rs.getString("type"));vo1.setHit(rs.getInt("hit"));vo1.setDownload(rs.getInt("download"));vo1.setTime(rs.getString("time"));v.addElement(vo1);} }catch (Exception ex){ex.printStackTrace();}finally{try{//关闭 psif (ps != null){ps.close();ps = null;}}catch (Exception ex){ex.printStackTrace();}}return v;}public DocVo findbykey(Connection _conn, DocVo vo){//定义 存放SQL语句的 StringBufferStringBuffer sbSQL = null;//定义 PreparedStatementPreparedStatement ps = null;//定义数据库链接Connection conn = null;ResultSet rs=null;try{conn = _conn;//拼写sqlsbSQL = new StringBuffer();sbSQL.append(" select * from  document  where ");sbSQL.append(" d_id = ?");//获得 数据库 prepareStatementps = conn.prepareStatement(sbSQL.toString());int nIndex = 1;ps.setLong(nIndex++, vo.getC_id());//执行SQLrs = ps.executeQuery();while(rs.next()){DocVo  vo1= new DocVo();vo1.setD_id(rs.getInt("d_id"));vo1.setC_id(rs.getInt("c_id"));vo1.setTitle(rs.getString("title"));vo1.setAuthor(rs.getString("author"));vo1.setUrl(rs.getString("url"));vo1.setType(rs.getString("type"));vo1.setHit(rs.getInt("hit"));vo1.setDownload(rs.getInt("download"));vo1.setTime(rs.getString("time"));vo=vo1;}}catch (Exception ex){ex.printStackTrace();}finally{try{//关闭 psif (ps != null){ps.close();ps = null;}}catch (Exception ex){ex.printStackTrace();}}return vo;}}

CatDao.java

package wenku.dao;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.util.List;import java.util.Vector;import wenku.vo.CatVo;public class CatDao {public List findbyAll(Connection _conn, String strSql){Vector v = new Vector();//定义 存放SQL语句的 StringBufferStringBuffer sbSQL = null;//定义 PreparedStatementPreparedStatement ps = null;//定义数据库链接Connection conn = null;ResultSet rs=null;try{conn = _conn;sbSQL = new StringBuffer();sbSQL.append("select * from  category  where  "); sbSQL.append(strSql); ps = conn.prepareStatement(sbSQL.toString());//执行SQLrs = ps.executeQuery();while(rs.next()){CatVo vo1= new CatVo();vo1.setC_id(rs.getInt("c_id"));vo1.setName(rs.getString("name"));v.addElement(vo1);} }catch (Exception ex){ex.printStackTrace();}finally{try{//关闭 psif (ps != null){ps.close();ps = null;}}catch (Exception ex){ex.printStackTrace();}}return v;}public CatVo findbykey(Connection _conn, CatVo vo){//定义 存放SQL语句的 StringBufferStringBuffer sbSQL = null;//定义 PreparedStatementPreparedStatement ps = null;//定义数据库链接Connection conn = null;ResultSet rs=null;try{conn = _conn;//拼写sqlsbSQL = new StringBuffer();sbSQL.append(" select * from  category  where ");sbSQL.append(" id = ?");//获得 数据库 prepareStatementps = conn.prepareStatement(sbSQL.toString());int nIndex = 1;ps.setLong(nIndex++, vo.getC_id());//执行SQLrs = ps.executeQuery();while(rs.next()){CatVo  vo1= new CatVo();vo1.setC_id(rs.getInt("c_id"));vo1.setName(rs.getString("name"));vo=vo1;}}catch (Exception ex){ex.printStackTrace();}finally{try{//关闭 psif (ps != null){ps.close();ps = null;}}catch (Exception ex){ex.printStackTrace();}}return vo;}}