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
企业门户新闻网 javaweb
需积分: 10 73 浏览量
2010-09-30
15:11:17
上传
评论
收藏 1.21MB RAR 举报
企业门户新闻网 javaweb （149个子文件） 
selectsql.class 11KB connsqlserver.class 2KB ModifyCode.class 2KB DownTable.class 1KB product.class 1KB StringTrans.class 1KB news.class 1KB category.class 915B user.class 727B .classpath 1KB style.css 971B Thumbs.db 199KB Thumbs.db 114KB Thumbs.db 27KB Thumbs.db 22KB Thumbs.db 6KB Thumbs.db 6KB db_net 1.08MB
~$readme.doc 162B
5.gif 57KB 4.gif 56KB ht03.gif 52KB 2.gif 49KB 5.gif 49KB 4.gif 49KB 7.gif 46KB 3.gif 30KB 4.gif 27KB 1.gif 27KB 3.gif 25KB 4.gif 24KB ht05.gif 23KB ht05new2.gif 23KB 32.gif 23KB 31.gif 22KB 33.gif 22KB 30.gif 21KB ht06.gif 21KB 2.gif 13KB ht02.gif 13KB 10.gif 11KB 5.gif 11KB 8.gif 10KB ht01.gif 10KB 5.gif 10KB 8.gif 10KB 7.gif 10KB 14.gif 10KB 9.gif 10KB 4.gif 10KB 6.gif 10KB 6.gif 10KB 6.gif 8KB 3.gif 7KB 8.gif 7KB 7.gif 6KB 1.gif 6KB 11.gif 6KB ht04.gif 6KB ht043.gif 6KB ht045.gif 6KB ht042.gif 6KB ht044.gif 6KB ht041.gif 5KB 5.gif 2KB 2.gif 2KB 1.gif 2KB 12.gif 2KB 3.gif 1KB 1.gif 1KB 16.gif 946B 15.gif 857B 7.gif 645B 8.gif 635B 2.gif 519B 2.gif 517B 3.gif 517B 8.gif 517B 13.gif 484B 9.gif 458B 11.gif 456B 1.gif 456B 6.gif 456B 9.gif 403B 10.gif 264B 17.gif 231B 6.gif 225B 12.gif 223B 7.gif 157B 分隔符.gif 43B 分隔符.gif 43B 分隔符.gif 43B 分隔符.gif 43B
gswh.html 3KB jszc.html 3KB selectsql.java 13KB connsqlserver.java 1KB ModifyCode.java 1KB StringTrans.java 948B product.java 887B共 149 条
- 1
- 2
资源评论
