blog.rar_blog_个人博客_心情_文章

package com.blog.struts.action; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.Statement; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Collection; import com.blog.struts.form.Liuyan; import com.blog.struts.form.Pinglun; import com.blog.struts.form.Reader; import com.blog.struts.form.Userperson; import com.blog.util.DBConn; public class BlogBean { private Connection conn ; public BlogBean()throws Exception { this.conn=DBConn.getConnection(); } /** *在数据库中添加一个用户 */ public void addReader(Reader reader)throws Exception { java.util.Date date= new java.util.Date(); SimpleDateFormat myform=new SimpleDateFormat("yyyy-MM-dd hh:mm:ss"); String mydate=myform.format(date); Statement stmt=conn.createStatement(); stmt.executeUpdate("insert into reader values('"+reader.getTitle()+"','"+reader.getContent()+"','"+reader.getFenlei()+"','"+mydate+"')"); } public void addLiuyan(Liuyan liuyan)throws Exception { java.util.Date date= new java.util.Date(); SimpleDateFormat myform=new SimpleDateFormat("yyyy-MM-dd hh:mm:ss"); String mydate=myform.format(date); Statement stmt=conn.createStatement(); stmt.executeUpdate("insert into liuyan values('"+liuyan.getUsername()+"','"+liuyan.getReply_content()+"','"+mydate+"')"); } public void addUserperson(Userperson userperson)throws Exception { Statement stmt=conn.createStatement(); stmt.executeUpdate("insert into userperson values('"+userperson.getUsername()+"','"+userperson.getPassword()+"','"+userperson.getEmail()+"','"+userperson.getBirthday()+"','"+userperson.getArea()+"')"); } public Userperson getUserperson(String username)throws Exception { return this.getStudentHelper1("select * from userperson where username='"+username+"'"); } public String getUserperson2(String username)throws Exception { return this.getStudentHelper2("select * from userperson where username='"+username+"'"); } public void addPinglun(Pinglun pinglun)throws Exception{ java.util.Date time= new java.util.Date(); SimpleDateFormat myform=new SimpleDateFormat("yyyy-MM-dd hh:mm:ss"); String mydate=myform.format(time); Statement stmt=conn.createStatement(); stmt.executeUpdate("insert into pinglun values("+pinglun.getId()+",'"+pinglun.getUsername()+"','"+pinglun.getContect()+"','"+mydate+"','"+pinglun.getTitle()+"')"); } public Collection getReaders()throws Exception { return this.getStudentHelper("select * from reader order by date desc"); } public Collection getRizhi(String rizhi)throws Exception { return this.getStudentHelper("select * from reader where rizhi='"+rizhi+"' order by date desc"); } public Collection getReaderer()throws Exception { return this.getReaderHelper("select top 6 title, date from reader order by date desc"); } public Collection getReader()throws Exception { return this.getStudentHelper("select * from reader"); } /*public Collection getReader(String title)throws Exception{ Statement stmt=conn.createStatement(); ResultSet rst=stmt.executeQuery("select * from reader where title='"+title+"'"); Collection ret=new ArrayList(); while(rst.next()) { Product temp=new Product(); temp.setProductId(rst.getString("productid")); temp.setCategoryId(rst.getString("category")); temp.setName(rst.getString("name")); temp.setProducer(rst.getString("producer")); temp.setPrice(rst.getFloat("price")); temp.setDescription(rst.getString("descn")); ret.add(temp); } con.close(); return ret; }*/ public int getAvailableCount2(String fenlei)throws Exception { int ret=0; Statement stmt=conn.createStatement(); String strSql="select count(*) from reader where fenlei='"+fenlei+"'"; ResultSet rset=stmt.executeQuery(strSql); while(rset.next()) { ret=rset.getInt(1); } return ret; } public int getAvailableCount1(int id)throws Exception { int ret=0; Statement stmt=conn.createStatement(); String strSql="select count(*) from pinglun where id="+id; ResultSet rset=stmt.executeQuery(strSql); while(rset.next()) { ret=rset.getInt(1); } return ret; } public int getAvailableCount3()throws Exception { int ret=0; Statement stmt=conn.createStatement(); String strSql="select count(*) from liuyan"; ResultSet rset=stmt.executeQuery(strSql); while(rset.next()) { ret=rset.getInt(1); } return ret; } public int getAvailableCount4()throws Exception { int ret=0; Statement stmt=conn.createStatement(); String strSql="select count(*) from pinglin"; ResultSet rset=stmt.executeQuery(strSql); while(rset.next()) { ret=rset.getInt(1); } return ret; } public int getAvailableCount()throws Exception { int ret=0; Statement stmt=conn.createStatement(); String strSql="select count(*) from reader"; ResultSet rset=stmt.executeQuery(strSql); while(rset.next()) { ret=rset.getInt(1); } return ret; } public void deleteReaderFromDept(int id)throws Exception { try { this.executeHelper("delete from reader where id="+id); } catch(Exception e) { e.printStackTrace(); throw e; } } public void deletePinglunFromDept(String time)throws Exception { try { this.executeHelper("delete from pinglun where time='"+time+"'"); } catch(Exception e) { e.printStackTrace(); throw e; } } public void deletePinglun2FromDept(int id)throws Exception { try { this.executeHelper("delete from pinglun where id="+id); } catch(Exception e) { e.printStackTrace(); throw e; } } public Collection listData2(String page,int rowsPerPage)throws Exception { try { int pageNum=Integer.parseInt(page); Statement stmt=conn.createStatement(); String strSql="select top "+pageNum*rowsPerPage+" * from reader order by date desc"; ResultSet rst=stmt.executeQuery(strSql); Collection ret=new ArrayList(); int i=0; while(rst.next()) { if(i>(pageNum-1)*rowsPerPage-1) { Reader temp=new Reader(); temp.setId(rst.getInt("id")); temp.setTitle(rst.getString("title")); temp.setContent(rst.getString("content")); temp.setFenlei(rst.getString("fenlei")); temp.setDate(rst.getString("date")); ret.add(temp); } i++; } return ret; } catch(Exception e) { e.printStackTrace(); throw e; } } public Collection listData3(String page,int rowsPerPage)throws Exception { try { int pageNum=Integer.parseInt(page); Statement stmt=conn.createStatement(); String strSql="select top "+pageNum*rowsPerPage+" * from liuyan order by times desc"; ResultSet rst=stmt.executeQuery(strSql); Collection ret=new ArrayList(); int i=0; while(rst.next()) { if(i>(pageNum-1)*rowsPerPage-1) { Liuyan temp=new Liuyan(); temp.setUsername(rst.getString("username")); temp.setReply_content(rst.getString("reply_content")); temp.setTimes(rst.getString("times")); ret.add(temp); } i++; } return ret; } catch(Exception e) { e.printStackTrace(); throw e; } } public void resetReader(Reader reader)throws Exception { java.util.Date time= new java.util.Date(); SimpleDateFormat myform=new SimpleDateFormat("yyyy-MM-dd hh:mm:ss"); String mydate=myform.format(time); PreparedStatement pstmt=conn.prepareStatement("update reader set title=?,content=?,fenlei=?,date=