📄 newsreplydao.java
字号:
package com.javaBeanDao;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.MessageFormat;
import java.util.ArrayList;
import java.util.List;
import com.sql.*;
import com.javaBean.*;
/**
* 这是一个对NewsReply表的数据javaBean进行操作的javaBean
* 对该表执行添，删，改，查的方法
* @author ACCP
*
*/
public class NewsReplyDao {
/**
* 这是一个专门用来对NewsReply表的数据javaBean进行添加操作的方法
* @param NewsReply
* @return 返回true就添加成功，否则就失败
*/
public boolean getNewsReplyInsert(NewsReply newsReply)
{
String sql="insert into NewsReply values({0},''{1}'',''{2}'',{3})";
MessageFormat mf=new MessageFormat(sql);
Object[] obj=new Object[]{newsReply.getNid()+"",newsReply.getNrtitle(),newsReply.getNrContent(),"default"};
sql=mf.format(obj);
return SQL.getSQL().getInsertAndUpdateAndDelete(sql);
}
/**
* 这是一个专门用来对NewsReply表的数据javaBean进行删除操作的方法
* @param nid
* @return 返回true就删除成功，否则就失败
*/
public boolean getNewsReplyDelete(int nrid)
{
String sql="delete from NewsReply where nrid="+nrid;
return SQL.getSQL().getInsertAndUpdateAndDelete(sql);
}
/**
* 这是一个专门用来对NewsReply表的数据javaBean进行修改操作的方法
* @param NewsReply
* @return 返回true就修改成功，否则就失败
*/
public boolean getNewsReplyUpdate(NewsReply newsReply)
{
String sql="update NewsReply set nid={0},nrtitle=''{1}'',nrcontent=''{2}'' where nrid={3}";
MessageFormat mf=new MessageFormat(sql);
Object[] obj=new Object[]{newsReply.getNid()+"",newsReply.getNrtitle(),newsReply.getNrContent(),newsReply.getNrid()+""};
sql=mf.format(obj);
return SQL.getSQL().getInsertAndUpdateAndDelete(sql);
}
/**
* 这是一个专门用来对NewsReply表的数据javaBean进行查询操作的方法 *
* @return 返回List就查询成功，否则就失败
*/
public List getNewsReplySelect()
{
String sql="select a.nrid,a.nid,a.nrtitle,a.nrcontent,b.ntitle,a.ndatetime from newsReply a inner join news b on a.nid=b.nid order by nrid desc";
ResultSet rs=SQL.getSQL().getSelect(sql);
List list=new ArrayList();
try {
NewsReply newsReply=null;
while(rs.next())
{
newsReply=new NewsReply();
newsReply.setNrid(rs.getInt(1));
newsReply.setNid(rs.getInt(2));
newsReply.setNrtitle(rs.getString(3));
newsReply.setNrContent(rs.getString(4));
newsReply.setNtitle(rs.getString(5));
newsReply.setNrdatetime(rs.getString(6));
list.add(newsReply);
}
return list;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}finally
{
SQL.getSQL().getClass();
}
}
/**
* 这是一个专门用来对NewsReply表的数据javaBean根据新闻ID进行查询操作的方法 *
* @return 返回News就查询成功，否则就失败
*/
public NewsReply getNridSelect(int nrid)
{
String sql="select * from NewsReply where nrid="+nrid;
ResultSet rs=SQL.getSQL().getSelect(sql);
NewsReply newsReply=null;
try {
if(rs.next())
{
newsReply=new NewsReply();
newsReply.setNrid(rs.getInt(1));
newsReply.setNid(rs.getInt(2));
newsReply.setNrtitle(rs.getString(4));
newsReply.setNrContent(rs.getString(5));
newsReply.setNrdatetime(rs.getString(6));
}
return newsReply;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}finally
{
SQL.getSQL().getClass();
}
}
public List getNidSelect(int nid)
{
String sql="select * from NewsReply where nid="+nid+"order by nrid desc";
ResultSet rs=SQL.getSQL().getSelect(sql);
List list=new ArrayList();
NewsReply newsReply=null;
try {
while(rs.next())
{
newsReply=new NewsReply();
newsReply.setNrid(rs.getInt(1));
newsReply.setNid(rs.getInt(2));
newsReply.setNrtitle(rs.getString(3));
newsReply.setNrContent(rs.getString(4));
newsReply.setNrdatetime(rs.getString(5));
list.add(newsReply);
}
return list;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}finally
{
SQL.getSQL().getClass();
}
}
/**
* 返回留言的总条数
* @return
*/
public int getNewsReplycount()
{
String sql="select count(*) from newsReply";
int page = 0;
ResultSet rs=SQL.getSQL().getSelect(sql);
try {
if(rs.next())
{
page=rs.getInt(1);
}
return page;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
SQL.getSQL().getClass();
}
return 0;
}
/**
* 得到总页数
* @param pagesize 页大小
* @return
*/
public int getcountpage(int pagesize)
{
int count=this.getNewsReplycount();
System.out.println("count");
if(count%pagesize==0)
{
return count/pagesize;
}
else
{
return count/pagesize+1;
}
}
/**
* 分页查找留言
*
* @return
*/
public List getNewsReplyCountPage(int curpage, int pagesize)
{
String sql="select top {0} a.nrid,a.nrtitle,a.nrcontent,b.ntitle,a.nid from newsReply a inner join news b on a.nid=b.nid where nrid not in("+"select top {1} nrid from newsReply order by ntid"+")order by nrid desc";
MessageFormat mf = new MessageFormat(sql);
Object[] obj=new Object[]{pagesize+"",(curpage-1)*pagesize+""};
sql=mf.format(obj);
ResultSet rs=SQL.getSQL().getSelect(sql);
List list=new ArrayList();
try {
NewsReply newsReply=null;
while(rs.next())
{
newsReply=new NewsReply();
newsReply.setNrid(rs.getInt(1));
newsReply.setNrtitle(rs.getString(2));
newsReply.setNrContent(rs.getString(3));
newsReply.setNtitle(rs.getString(4));
newsReply.setNid(rs.getInt(5));
list.add(newsReply);
}
return list;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}finally
{
SQL.getSQL().getClass();
}
}
public int getNidCount2()
{
String sql="select count(*) from newsReply";
int page = 0;
ResultSet rs=SQL.getSQL().getSelect(sql);
try {
if(rs.next())
{
page=rs.getInt(1);
}
return page;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
SQL.getSQL().getClass();
}
return 0;
}
/**
* 根据新闻返回留言的总条数
* @return
*/
public int getNidCount(int nid)
{
String sql="select count(*) from newsReply where nid="+nid;
// System.out.println("评论数是:"+sql);
int page = 0;
ResultSet rs=SQL.getSQL().getSelect(sql);
try {
if(rs.next())
{
page=rs.getInt(1);
}
return page;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
SQL.getSQL().getClass();
}
return 0;
}
public List getMaxNewsReplyCount()
{
String sql="select top 10 b.nid from news a inner join newsReply b on a.nid=b.nid group by b.nid order by count(*) desc ";
ResultSet rs=SQL.getSQL().getSelect(sql);
if(rs!=null)
{
List list=new ArrayList();
try {
while(rs.next())
{
list.add(rs.getInt(1));
// System.out.println("RS是:"+list.get(0));
}
return list;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return null;
}
public boolean NewsReplyDeletCount(String nrid)
{
String sql="delete from newsReply where nrid in("+nrid+")";
System.out.println(sql);
return SQL.getSQL().getInsertAndUpdateAndDelete(sql);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -