📄 news.java
字号:
dbc.prepareStatement("SELECT * FROM news where news_title like ? or conten like ? order by ? desc");
dbc.setBytes(1,("%"+keyword+"%").getBytes("GBK"));
dbc.setBytes(2,("%"+keyword+"%").getBytes("GBK"));
dbc.setBytes(3,arr.getBytes("GBK"));
}
else if(scope.equals("title") && cata0_id>0){
dbc.prepareStatement("select * from news where news_title like ? and cata0_id= ? order by ? desc");
dbc.setBytes(1,("%"+keyword+"%").getBytes("GBK"));
dbc.setInt(2,cata0_id);
dbc.setBytes(3,arr.getBytes("GBK"));
}
else{
dbc.prepareStatement("select * from news where (news_title like ? or conten like ?) and cata0_id= ? order by ? desc");
dbc.setBytes(1,("%"+keyword+"%").getBytes("GBK"));
dbc.setBytes(2,("%"+keyword+"%").getBytes("GBK"));
dbc.setInt(3,cata0_id);
dbc.setBytes(4,arr.getBytes("GBK"));
}
rs = dbc.executeQuery();
while(rs.next()){
News news = new News();
news.setnews_id(rs.getString("news_id"));
news.setcata2_id(rs.getString("cata2_id"));
news.setnews_title(rs.getString("news_title"));
news.setdat(rs.getString("dat"));
news.setcoun(rs.getString("coun"));
news.setauthor(rs.getString("author"));
newsVector.add(news);
}
}
catch(Exception e){
System.err.println(e);
}
finally{
try{
dbc.close();
}
catch(Exception e){
e.printStackTrace();
}
}
return newsVector;
}
/*******************************
* 读出指定一级目录的十条最新资料 *
********************************/
public Vector loadToptenCata0News(String str){
DBConnect dbc = null;
ResultSet rs;
Vector newsVector = new Vector();
try{
dbc = new DBConnect();
dbc.prepareStatement("select * from news where cata0_id=? ORDER BY dat desc limit10");
dbc.setBytes(1,str.getBytes("GBK"));
rs = dbc.executeQuery();
while(rs.next()){
News news = new News();
news.setnews_id(rs.getString("news_id"));
news.setcata0_id(rs.getString("cata0_id"));
news.setcata1_id(rs.getString("cata1_id"));
news.setcata2_id(rs.getString("cata2_id"));
news.setnews_title(rs.getString("news_title"));
news.setdat(rs.getString("dat"));
news.setcoun(rs.getString("coun"));
newsVector.add(news);
}
}
catch(Exception e){
System.err.println(e);
}
finally{
try{
dbc.close();
}
catch(Exception e){
e.printStackTrace();
}
}
return newsVector;
}
/************************************
* 读出指定三级目录的十条最HOT资料 *
************************************/
public Vector loadToptenCata2News(String str){
DBConnect dbc = null;
ResultSet rs;
Vector newsVector = new Vector();
try{
dbc = new DBConnect();
dbc.prepareStatement("select * from news where cata2_id=? ORDER BY coun desc limit 10");
dbc.setBytes(1,str.getBytes("GBK"));
rs = dbc.executeQuery();
while(rs.next()){
News news = new News();
news.setnews_id(rs.getString("news_id"));
news.setcata0_id(rs.getString("cata0_id"));
news.setcata1_id(rs.getString("cata1_id"));
news.setcata2_id(rs.getString("cata2_id"));
news.setnews_title(rs.getString("news_title"));
news.setdat(rs.getString("dat"));
news.setcoun(rs.getString("coun"));
newsVector.add(news);
}
}
catch(Exception e){
System.err.println(e);
}
finally{
try{
dbc.close();
}
catch(Exception e){
e.printStackTrace();
}
}
return newsVector;
}
/*******************************
* 读出指定三级目录的资料 *
********************************/
public Vector loadCata2News(String cata2_id,String str){
DBConnect dbc = null;
ResultSet rs;
ICata icata=new ICata();
Vector newsVector = new Vector();
try{
dbc = new DBConnect();
dbc.prepareStatement("select * from news where cata2_id=? ORDER BY ? desc");
dbc.setBytes(1,cata2_id.getBytes("GBK"));
dbc.setBytes(2,str.getBytes("GBK"));
rs = dbc.executeQuery();
while(rs.next()){
ICata cata_name=icata.loadCataName(rs.getString("cata0_id"),rs.getString("cata1_id"),rs.getString("cata2_id"));
News news = new News();
news.setnews_id(rs.getString("news_id"));
news.setcata0_id(rs.getString("cata0_id"));
news.setcata0_name(cata_name.getcata0_name());
news.setcata1_id(rs.getString("cata1_id"));
news.setcata1_name(cata_name.getcata1_name());
news.setcata2_id(rs.getString("cata2_id"));
news.setcata2_name(cata_name.getcata2_name());
news.setnews_title(rs.getString("news_title"));
news.setdat(rs.getString("dat"));
news.setcoun(rs.getString("coun"));
newsVector.add(news);
}
}
catch(Exception e){
System.err.println(e);
}
finally{
try{
dbc.close();
}
catch(Exception e){
e.printStackTrace();
}
}
return newsVector;
}
/*******************************
* 读出综合TOP10的资料 *
********************************/
public Vector loadTop10News(){
DBConnect dbc = null;
ResultSet rs;
Vector newsVector = new Vector();
try{
dbc = new DBConnect();
dbc.prepareStatement("select * from news ORDER BY coun desc limit 10");
rs = dbc.executeQuery();
while(rs.next()){
News news = new News();
news.setnews_id(rs.getString("news_id"));
news.setcata0_id(rs.getString("cata0_id"));
news.setcata1_id(rs.getString("cata1_id"));
news.setcata2_id(rs.getString("cata2_id"));
news.setnews_title(rs.getString("news_title"));
news.setdat(rs.getString("dat"));
news.setcoun(rs.getString("coun"));
newsVector.add(news);
}
}
catch(Exception e){
System.err.println(e);
}
finally{
try{
dbc.close();
}
catch(Exception e){
e.printStackTrace();
}
}
return newsVector;
}
/*******************************
* 读出最新更新的资料 *
********************************/
public Vector loadNewNews(){
DBConnect dbc = null;
ResultSet rs;
Vector newsVector = new Vector();
ICata icata=new ICata();
try{
dbc = new DBConnect();
dbc.prepareStatement("select * from news ORDER BY dat desc limit 20");
rs = dbc.executeQuery();
while(rs.next()){
ICata cata_name=icata.loadCataName(rs.getString("cata0_id"),rs.getString("cata1_id"),rs.getString("cata2_id"));
News news = new News();
news.setnews_id(rs.getString("news_id"));
news.setcata0_id(rs.getString("cata0_id"));
news.setcata0_name(cata_name.getcata0_name());
news.setcata1_id(rs.getString("cata1_id"));
news.setcata1_name(cata_name.getcata1_name());
news.setcata2_id(rs.getString("cata2_id"));
news.setcata2_name(cata_name.getcata2_name());
news.setnews_title(rs.getString("news_title"));
news.setdat(rs.getString("dat"));
news.setcoun(rs.getString("coun"));
newsVector.add(news);
}
}
catch(Exception e){
System.err.println(e);
}
finally{
try{
dbc.close();
}
catch(Exception e){
e.printStackTrace();
}
}
return newsVector;
}
/************************
* 读出图片资料 *
************************/
public News loadPicNews(){
DBConnect dbc = null;
ResultSet rs;
News news = new News();
try{
dbc = new DBConnect();
dbc.prepareStatement("select * from news where img='1' order by dat desc limit 1");
rs = dbc.executeQuery();
if(rs.next()){
news.setnews_id(rs.getString("news_id"));
news.setcata0_id(rs.getString("cata0_id"));
news.setcata1_id(rs.getString("cata1_id"));
news.setcata2_id(rs.getString("cata2_id"));
news.setnews_title(rs.getString("news_title"));
news.setdat(rs.getString("dat"));
news.setcoun(rs.getString("coun"));
news.setimgsrc(rs.getString("imgsrc"));
}
}
catch(Exception e){
System.err.println(e);
}
finally{
try{
dbc.close();
}
catch(Exception e){
e.printStackTrace();
}
}
return news;
}
/**********************
* 上传图片 *
**********************/
public static void uploadPic(String pic,String news_id) throws Exception {
boolean foundErr = false;
String errMsg="";
DBConnect dbc = new DBConnect();
ResultSet rs;
if(pic.equals("") || pic==null){
errMsg = errMsg + "□ 您没有输入内容！<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
if(news_id.equals("") || news_id==null){
errMsg = errMsg + "□ 您没有从正常途径进入本页！<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
if(!foundErr){
try{
String imgsrc="upload/"+pic;
dbc.prepareStatement("Select * from news where news_id=?");
dbc.setBytes(1,news_id.getBytes("GBK"));
rs=dbc.executeQuery();
if(rs.next()){
dbc.prepareStatement("update news set imgsrc=? where news_id=?");
dbc.setBytes(1,imgsrc.getBytes("GBK"));
dbc.setBytes(2,news_id.getBytes("GBK"));
dbc.executeUpdate();
}
else{
dbc.prepareStatement("insert into news set imgsrc=?");
dbc.setBytes(1,imgsrc.getBytes("GBK"));
dbc.executeUpdate();
}
}
catch(Exception e){
System.err.println(e);
}
finally{
try{
dbc.close();
}
catch(Exception e){
e.printStackTrace();
}
}
}
if(foundErr) throw new Exception(errMsg);
}
/*******************************
* 读出推荐HOT的资料 *
********************************/
public Vector loadHotNews(){
DBConnect dbc = null;
ResultSet rs;
ICata icata=new ICata();
Vector newsVector = new Vector();
try{
dbc = new DBConnect();
dbc.prepareStatement("select * from news where hot='1' ORDER BY dat desc limit 10");
rs = dbc.executeQuery();
while(rs.next()){
ICata cata_name=icata.loadCataName(rs.getString("cata0_id"),rs.getString("cata1_id"),rs.getString("cata2_id"));
News news = new News();
news.setnews_id(rs.getString("news_id"));
news.setcata0_id(rs.getString("cata0_id"));
news.setcata0_name(cata_name.getcata0_name());
news.setcata1_id(rs.getString("cata1_id"));
news.setcata1_name(cata_name.getcata1_name());
news.setcata2_id(rs.getString("cata2_id"));
news.setcata2_name(cata_name.getcata2_name());
news.setnews_title(rs.getString("news_title"));
news.setdat(rs.getString("dat"));
news.setcoun(rs.getString("coun"));
newsVector.add(news);
}
}
catch(Exception e){
System.err.println(e);
}
finally{
try{
dbc.close();
}
catch(Exception e){
e.printStackTrace();
}
}
return newsVector;
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -