utilarticle.java
来自「spring+struts+hibernate做的银行系统」· Java 代码 · 共 393 行
JAVA
393 行
/*
* Created on 2006-4-14
*
* TODO To change the template for this generated file go to
* Window - Preferences - Java - Code Style - Code Templates
*/
package cn.com.tym.util.tablebean;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Collection;
import javax.servlet.http.HttpServletRequest;
import cn.com.tym.admin.ArticleForm;
import cn.com.tym.pub.Constants;
import cn.com.tym.pub.DB;
import cn.com.tym.pub.PageBean;
import cn.com.tym.table.bean.ArticleBean;
import cn.com.tym.table.bean.RegisterBean;
import cn.com.tym.util.text.DealText;
import cn.com.tym.util.text.ExchangeInput;
/**
* @author jack_booth
*
* TODO To change the template for this generated type comment go to
* Window - Preferences - Java - Code Style - Code Templates
*/
public class UtilArticle {
public ArrayList getArrticlist(int chice,DB db) throws SQLException{
String strSql="";
switch(chice)
{
case Constants.SUBJECTLIST_INT ://�������¹������
strSql="SELECT TOP 4 article_id, mainTitle, subTitle " +
"FROM mdh_article where coteid=1 order by article_id desc ";
break;
case Constants.LIFELIST_INT : //���ؾ������
strSql="select top 6 article_id, mainTitle, subTitle from mdh_article where coteid=2 order by article_id desc ";
break;
}
ArrayList arraylist=new ArrayList();
ResultSet rs=db.OpenSql(strSql);
while(rs.next()){
ArticleBean bean=new ArticleBean();
bean.setArticleId(rs.getString("article_id"));
bean.setMainTitle(rs.getString("mainTitle"));
// ebean.setContent(rs.getString("second_content"));
arraylist.add(bean);
bean=null;
}
return arraylist;
}
//修改要的文件
public ArticleBean getArrticBean(String articleId,DB db) throws SQLException{
String strSql="select article_id,coteId,mainTitle,subTitle,author,source,editor,digest,keyword," +
"content,articleTime from mdh_article where article_id='"+articleId+"' ";
ArticleBean bean=null;
ResultSet rs=db.OpenSql(strSql);
if(rs.next()){
bean=new ArticleBean();
bean.setArticleId(rs.getString("article_id"));
bean.setCoteId(rs.getString("coteId"));
bean.setMainTitle(rs.getString("mainTitle"));
bean.setSubTitle(rs.getString("subTitle"));
bean.setAuthor(rs.getString("author"));
bean.setSource(rs.getString("source"));
bean.setEditor(rs.getString("editor"));
bean.setDigest(rs.getString("digest"));
bean.setKeyword(rs.getString("keyword"));
bean.setContent(rs.getString("content"));
bean.setArticleTime(rs.getString("articleTime"));
}
return bean;
}
//�ҵĵش���, ����������е���Ѷ
public ArrayList getLifelist(DB db) throws SQLException{
//���ؾ������
String strSql="SELECT TOP 4 article_id, mainTitle, subTitle " +
"FROM mdh_article where coteid=2 order by article_id desc ";
ArrayList arraylist=new ArrayList();
ResultSet rs=db.OpenSql(strSql);
while(rs.next()){
ArticleBean bean=new ArticleBean();
bean.setArticleId(rs.getString("article_id"));
bean.setMainTitle(rs.getString("mainTitle"));
if(rs.getString("mainTitle").length()>10)
bean.setMainTitle(rs.getString("subTitle"));
arraylist.add(bean);
bean=null;
}
return arraylist;
}
//���� ��Ա
public ArrayList getPhotoList(DB db) throws SQLException{
String strSql="";
RegisterBean bean=null;
ArrayList arraylist=new ArrayList();
//���»�Ա
strSql="SELECT TOP 2 register_id,rname,rsex,rcity from mdh_register order by register_id desc ";
try{
ResultSet rs=db.OpenSql(strSql);
while(rs.next()){
bean=new RegisterBean();
bean.setRid(rs.getString("register_id"));
bean.setRname(rs.getString("rname"));
if(bean.getRname().length()>4)
bean.setRname(bean.getRname().substring(0,4)+"."); //�������ִ���4���ַ��ʡȥ
bean.setRsex(rs.getString("rsex"));
// bean.setDay(checkSex(rs.getString("rsex"))); //�����Ա�ͼ��
bean.setCity(rs.getString("rcity"));
arraylist.add(bean);
bean=null;
}
}catch(SQLException e){
e.printStackTrace();
throw e;
}
return arraylist;
}
//�鿴���������
public ArticleBean seeArticle(String id,DB db ) throws SQLException
{
int bid=ExchangeInput.StringToInt(id);
ArticleBean bean=null;
String strSql = "select article_id, mainTitle, subTitle,content,articleTime,source from mdh_article where article_id='"+bid+"'";
try
{
ResultSet rs=db.OpenSql(strSql);
if(rs.next())
{
bean=new ArticleBean();
bean.setArticleId(rs.getString("article_id"));
bean.setMainTitle(rs.getString("mainTitle"));
bean.setContent(rs.getString("content"));
bean.setArticleTime(rs.getString("articleTime"));
bean.setSource(rs.getString("source"));
}
}
catch(SQLException e)
{
e.printStackTrace();
throw e;
}
return bean;
}
//��������
public boolean insert(ArticleForm frm,DB db)
throws SQLException
{
boolean check = false;
// bigClassID = exchangeInput.StringToInt(frm.getCoteId());
// viewBigClass viewBigClass = new viewBigClass();
// if(viewBigClass.seeByID(bigClassID))
// bigClassName = viewBigClass.getBigClassName();
// viewBigClass = null;
ArticleBean bean=new ArticleBean();
bean.setCoteId(frm.getCoteId());
bean.setMainTitle(ExchangeInput.StringToString(frm.getMainTitle()));
bean.setSubTitle(ExchangeInput.StringToString(frm.getSubTitle()));
bean.setAuthor(ExchangeInput.StringToString(frm.getAuthor()));
bean.setSource(ExchangeInput.StringToString(frm.getSource()));
bean.setEditor(ExchangeInput.StringToString(frm.getEditor()));
bean.setDigest(ExchangeInput.StringToString(frm.getDigest()));
bean.setKeyword(ExchangeInput.StringToString(frm.getKeyword()));
bean.setContent(ExchangeInput.StringToString(frm.getEdit()));
bean.setArticleTime(ExchangeInput.getNewTime());
bean.setStatus(frm.getStatus());
if(!bean.getMainTitle().equals("") && !bean.getContent().equals(""))
{
String mainTitle = DealText.dealToSql(bean.getMainTitle());
String subTitle = DealText.dealToSql(bean.getSubTitle());
String author = DealText.dealToSql(bean.getAuthor());
String source = DealText.dealToSql(bean.getSource());
String editor = DealText.dealToSql(bean.getEditor());
String digest = DealText.dealToSql(bean.getDigest());
String keyword = DealText.dealToSql(bean.getKeyword());
String content = DealText.dealToSql(bean.getContent());
String strSql = "insert into mdh_article values('"+bean.getCoteId()+"','"+mainTitle+"','"+subTitle+"','"+author+"','"+source+"','"+editor+"','"+digest+"','"+keyword+"','"+content+"','"+bean.getArticleTime()+"','"+bean.getStatus()+"') ";
try{
if(db.ExecSql(strSql)!= 0)
check = true;
db.close();
}catch(SQLException e){
db.close();
throw e;
}
}
return check;
}
//修改资讯操作
public boolean makeAction(ArticleForm frm,DB db)
throws SQLException
{
boolean check = false;
ArticleBean bean=new ArticleBean();
bean.setCoteId(frm.getCoteId());
bean.setMainTitle(ExchangeInput.StringToString(frm.getMainTitle()));
bean.setSubTitle(ExchangeInput.StringToString(frm.getSubTitle()));
bean.setAuthor(ExchangeInput.StringToString(frm.getAuthor()));
bean.setSource(ExchangeInput.StringToString(frm.getSource()));
bean.setEditor(ExchangeInput.StringToString(frm.getEditor()));
bean.setDigest(ExchangeInput.StringToString(frm.getDigest()));
bean.setKeyword(ExchangeInput.StringToString(frm.getKeyword()));
bean.setContent(ExchangeInput.StringToString(frm.getEdit()));
bean.setArticleTime(ExchangeInput.getNewTime());
bean.setStatus(frm.getStatus());
if(!bean.getMainTitle().equals("") && !bean.getContent().equals(""))
{
String mainTitle = DealText.dealToSql(bean.getMainTitle());
String subTitle = DealText.dealToSql(bean.getSubTitle());
String author = DealText.dealToSql(bean.getAuthor());
String source = DealText.dealToSql(bean.getSource());
String editor = DealText.dealToSql(bean.getEditor());
String digest = DealText.dealToSql(bean.getDigest());
String keyword = DealText.dealToSql(bean.getKeyword());
String content = DealText.dealToSql(bean.getContent());
String strSql = "insert into mdh_article values('"+bean.getCoteId()+"','"+mainTitle+"','"+subTitle+"','"+author+"','"+source+"','"+editor+"','"+digest+"','"+keyword+"','"+content+"','"+bean.getArticleTime()+"','"+bean.getStatus()+"') ";
try{
if(db.ExecSql(strSql)!= 0)
check = true;
db.close();
}catch(SQLException e){
db.close();
throw e;
}
}
return check;
}
//���ؾ������
public ArrayList getLiftList(HttpServletRequest request, DB db)throws SQLException{
ArrayList list = new ArrayList();
String strSql= "select * from mdh_article where coteId=2 and status=0 order by article_id desc";
Collection arraylist=new ArrayList();
ResultSet rs = null;
PageBean pageBean=new PageBean(request);
pageBean.setPageSize(10);
pageBean.count();
int currRow=pageBean.getCurrentRow();
int lastRow=pageBean.getLastRow();
String csql="select count(*) from mdh_article where coteId=2 and status=0 ";
String urlStr="WelcomeAction.do?method=liftList";
try{
pageBean.count(db,rs,csql,urlStr);
}
catch(Exception e){}
//strSql="SELECT COUNT(*) FROM mdh_secondCote WHERE rownum<="+ lastRow;
//strSql="select count(*) top '"+lastRow+"' from mdh_secondCote";
// strSql="Select top 5 * FROM (" +strSql + ")";
UtilCote util=new UtilCote();
strSql=" select top "+lastRow+" * from mdh_article where coteId=2 and status=0 order by article_id desc ";
try{
rs=db.OpenSql(strSql);
if(currRow>0)
rs.absolute(currRow);
while(rs.next())
{
ArticleBean bean=new ArticleBean();
// artil.articleId=ExchangeInput.StringToInt(rs.getString("article_id"));
bean.setArticleId(rs.getString("article_id"));
bean.setCoteId(rs.getString("coteId")) ;
bean.setCoteName(util.getCoteName(2,db));
bean.setMainTitle(rs.getString("mainTitle"));
if(bean.getMainTitle().length()>19)//��������19��ʱ,����ʾ������
bean.setMainTitle(rs.getString("subTitle"));
bean.setArticleTime(ExchangeInput.getTime(rs.getString("articleTime")));
bean.setContent(rs.getString("content"));
list.add( bean);
bean=null;
}}
catch(SQLException e){
db.close();
e.printStackTrace();
}
finally{
db.close();
}
return list;
}
//���¹���
public ArrayList getSubjectList(HttpServletRequest request, DB db)throws SQLException{
ArrayList list = new ArrayList();
String strSql= "select * from mdh_article where coteId=1 and status=0 order by article_id desc";
Collection arraylist=new ArrayList();
ResultSet rs = null;
PageBean pageBean=new PageBean(request);
pageBean.setPageSize(10);
pageBean.count();
int currRow=pageBean.getCurrentRow();
int lastRow=pageBean.getLastRow();
String csql="select count(*) from mdh_article where coteId=1 and status=0 ";
String urlStr="WelcomeAction.do?method=subjectList";
try{
pageBean.count(db,rs,csql,urlStr);
}
catch(Exception e){}
//strSql="SELECT COUNT(*) FROM mdh_secondCote WHERE rownum<="+ lastRow;
//strSql="select count(*) top '"+lastRow+"' from mdh_secondCote";
// strSql="Select top 5 * FROM (" +strSql + ")";
UtilCote util=new UtilCote();
strSql=" select top "+lastRow+" * from mdh_article where coteId=1 and status=0 order by article_id desc ";
try{
rs=db.OpenSql(strSql);
if(currRow>0)
rs.absolute(currRow);
while(rs.next())
{
ArticleBean bean=new ArticleBean();
// artil.articleId=ExchangeInput.StringToInt(rs.getString("article_id"));
bean.setArticleId(rs.getString("article_id"));
bean.setCoteId(rs.getString("coteId")) ;
bean.setCoteName(util.getCoteName(2,db));
bean.setMainTitle(rs.getString("mainTitle"));
if(bean.getMainTitle().length()>19)//��������19��ʱ,����ʾ������
bean.setMainTitle(rs.getString("subTitle"));
bean.setArticleTime(ExchangeInput.getTime(rs.getString("articleTime")));
bean.setContent(rs.getString("content"));
list.add( bean);
bean=null;
}}
catch(SQLException e){
db.close();
e.printStackTrace();
}
finally{
db.close();
}
return list;
}
//��������
public static boolean checkAdmin(String id,String newPwd,DB db)throws SQLException{
boolean bool=false;
String strSql="update mdh_admin set admin_pwd='"+newPwd+"' where card_id='"+id+"'";
try{
if(db.ExecSql(strSql)!=0){
bool=true;
}}catch(SQLException e){
throw e;
}
return bool;
}
}
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?