JAVA实例项目8(源码附件及说明)

package com.wsy; import java.sql.*; import java.util.*; import java.text.*; public class selectsql { public static ResultSet rs; public static StringTrans s; public static connsqlserver connsqlserver=new connsqlserver(); /* * 关于tb_usertable表的操作 */ public static Collection getRet(){ Collection ret=new ArrayList(); try{ connsqlserver connsqlserver=new connsqlserver(); String sql="select * from tb_usertable"; rs=connsqlserver.executeQuery(sql); while(rs.next()){ String names=rs.getString("name"); String passwords=rs.getString("password"); user user=new user(); user.setName(names); user.setPassword(passwords); ret.add(user); } } catch(Exception e){ e.printStackTrace(); } connsqlserver.close(); return ret; } public static int check(String name,String password){ int i=0; String names=""; String passwords=""; try{ connsqlserver connsqlserver=new connsqlserver(); String sql="select * from tb_usertable where name='"+name+"'and password='"+password+"'"; System.out.println(sql); rs=connsqlserver.executeQuery(sql); while(rs.next()){ names=rs.getString("name"); passwords=rs.getString("password"); if(names!=null){ i=1; } } } catch(Exception e){ e.printStackTrace(); } connsqlserver.close(); return i; } /* * 关于tb_news表的操作 */ public int Insert(String title,String author,String news){ int i=0; try{ connsqlserver connsqlserver=new connsqlserver(); String sql="insert into tb_news(title,author,content) values('"+title+"','"+author+"','"+news+"')"; i=connsqlserver.executeUpdate(sql); }catch(Exception e){ e.printStackTrace(); } connsqlserver.close(); return i; } public void Insert1(String title,String author,String news){ try{ connsqlserver connsqlserver=new connsqlserver(); String sql="insert into tb_business(title,author,content) values('"+title+"','"+author+"','"+news+"')"; connsqlserver.executeUpdate(sql); }catch(Exception e){ e.printStackTrace(); } } public Collection selectNewsAll(){ Collection ret=new ArrayList(); try{ connsqlserver connsqlserver=new connsqlserver(); String sql="select * from tb_news"; ResultSet rs=connsqlserver.executeQuery(sql); while(rs.next()){ news news1=new news(); news1.setId(rs.getString("id")); news1.setTitle(rs.getString("title")); news1.setContent(rs.getString("content")); news1.setAuthor(rs.getString("author")); news1.setSubmittime(rs.getString("submittime")); ret.add(news1); } }catch(Exception e){ e.printStackTrace(); } connsqlserver.close(); return ret; } public Collection selectNews(String id){ Collection ret=new ArrayList(); try{ connsqlserver connsqlserver=new connsqlserver(); String sql="select * from tb_news where id='"+id+"'"; ResultSet rs=connsqlserver.executeQuery(sql); while(rs.next()){ String ids=rs.getString("id"); String title=rs.getString("title"); String author=rs.getString("author"); String news=rs.getString("content"); news news1=new news(); news1.setId(ids); news1.setTitle(title); news1.setContent(news); news1.setAuthor(author); ret.add(news1); } }catch(Exception e){ e.printStackTrace(); } connsqlserver.close(); return ret; } public Collection selectNews(){ Collection ret=new ArrayList(); try{ connsqlserver connsqlserver=new connsqlserver(); String sql="select top 6 * from tb_news"; ResultSet rs=connsqlserver.executeQuery(sql); while(rs.next()){ String title=rs.getString(2); String author=rs.getString(3); String news=rs.getString(4); news news1=new news(); news1.setTitle(title); news1.setContent(news); news1.setAuthor(author); ret.add(news1); } }catch(Exception e){ e.printStackTrace(); } connsqlserver.close(); return ret; } public Collection selectNewsforqyxw(){ Collection ret=new ArrayList(); try{ connsqlserver connsqlserver=new connsqlserver(); String sql="select top 15 * from tb_news"; ResultSet rs=connsqlserver.executeQuery(sql); while(rs.next()){ String title=rs.getString(2); String author=rs.getString(3); String news=rs.getString(4); news news1=new news(); news1.setTitle(title); news1.setContent(news); news1.setAuthor(author); ret.add(news1); } }catch(Exception e){ e.printStackTrace(); } connsqlserver.close(); return ret; } public int updateNews(String title,String content,String author,String id){ int i=0; try{ connsqlserver connsqlserver=new connsqlserver(); String sql="UPDATE tb_news SET title = '"+title+"', content = '"+content+"', author = '"+author+"' WHERE (id = '"+id+"')"; i=connsqlserver.executeUpdate(sql); }catch(Exception e){ e.printStackTrace(); } connsqlserver.close(); return i; } public int delNews(String id){ int i=0; try{ connsqlserver connsqlserver=new connsqlserver(); String sql="delete from tb_news where id='"+id+"'"; i=connsqlserver.executeUpdate(sql); }catch(Exception e){ e.printStackTrace(); } connsqlserver.close(); return i; } /* * 关于tb_business表的操作 */ public Collection selectBusinessAll(){ Collection ret=new ArrayList(); try{ connsqlserver connsqlserver=new connsqlserver(); String sql="select * from tb_business"; ResultSet rs=connsqlserver.executeQuery(sql); while(rs.next()){ product product=new product(); product.setId(rs.getString("id")); product.setImg(rs.getString("img")); product.setMsg(rs.getString("ms")); product.setName(rs.getString("name")); product.setSubmittime(rs.getString("submittime")); product.setCategory(rs.getString("category")); ret.add(product); } }catch(Exception e){ e.printStackTrace(); } connsqlserver.close(); return ret; } public ResultSet selectbusiness(){ ResultSet rs=null; try{ connsqlserver connsqlserver=new connsqlserver(); String sql="select * from tb_business"; rs=connsqlserver.executeQuery(sql); rs.last(); }catch(Exception e){ e.printStackTrace(); } //connsqlserver.close(); return rs; } public Collection selectBusinessForId(String id){ Collection ret=new ArrayList(); try{ connsqlserver connsqlserver=new connsqlserver(); String sql="select * from tb_business where id='"+id+"'"; ResultSet rs=connsqlserver.executeQuery(sql); while(rs.next()){ product product=new product(); product.setId(rs.getString("id")); product.setImg(rs.getString("img")); product.setMsg(rs.getString("ms")); product.setName(rs.getString("name")); product.setSubmittime(rs.getString("submittime")); product.setCategory(rs.getString("category")); ret.add(product); } }catch(Exception e){ e.printStackTrace(); } connsqlserver.close(); return ret; } public Collection selectBusinessFy(int page){ Collection ret=new ArrayList(); DownTable down=new DownTable(); try{ connsqlserver connsqlserver=new connsqlserver(); String sql="select top 10 * from tb_business where id not in(select top "+down.getPageSize()*page+" id from tb_business order by id)order by id"; //String sql="select * from (select top 20 * from (select top "+10*page+" * from tb_business order by id ASC)as aSysTable order by id desc) as bsystable order by id ASC"; //System.out.println(sql); ResultSet rs=connsqlserver.executeQuery(sql); while(rs.next()){ product product=new product(); product.setId(rs.getString("id")); product.setImg(rs.getString("img")); product.setMsg(rs.getString("ms")); product.setName(rs.getS