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 order by id desc";
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 order by id desc";
ResultSet rs=connsqlserver.executeQuery(sql);
while(rs.next()){
String id=rs.getString(1);
String title=rs.getString(2);
String author=rs.getString(3);
String news=rs.getString(4);
news news1=new news();
news1.setId(id);
news1.setTitle(title);
news1.setContent(news);
news1.setAuthor(author);
ret.add(news1);
}
}catch(Exception e){
e.printStackTrace();
}
connsqlserver.close();
return ret;
}
public Collection selectMoreNewsFy(int page){
Collection ret=new ArrayList();
MoreNewsPage down=new MoreNewsPage();
try{
connsqlserver connsqlserver=new connsqlserver();
String sql="select top 20 * from tb_news where id not in(select top "+down.getPageSize()*page+" id from tb_news 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()){
news n=new news();
n.setId(rs.getString(1));
n.setTitle(rs.getString(2));
n.setContent(rs.getString(3));
n.setAuthor(rs.getString(4));
n.setSubmittime(rs.getString(4));
ret.add(n);
}
}catch(Exception e){
e.printStackTrace();
}
connsqlserver.close();
return ret;
}
public Collection selectNewsFy(int page){
Collection ret=new ArrayList();
NewsPage down=new NewsPage();
try{
connsqlserver connsqlserver=new connsqlserver();
String sql="select top 10 * from tb_news where id not in(select top "+down.getPageSize()*page+" id from tb_news 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()){
news n=new news();
n.setId(rs.getString(1));
n.setTitle(rs.getString(2));
n.setContent(rs.getString(3));
n.setAuthor(rs.getString(4));
n.setSubmittime(rs.getString(4));
ret.add(n);
}
}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 id=rs.getString(1);
String title=rs.getString(2);
String author=rs.getString(3);
String news=rs.getString(4);
news news1=new news();
news1.setId(id);
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"));
prod
没有合适的资源?快使用搜索试试~ 我知道了~
该文件是一种基于JavaWeb的企业门户网站
共155个文件
gif:74个
jsp:34个
java:11个
需积分: 8 0 下载量 66 浏览量
2022-09-10
23:59:36
上传
评论
收藏 1.2MB ZIP 举报
温馨提示
该文件是一种基于JavaWeb的企业门户网站
资源详情
资源评论
资源推荐
收起资源包目录
该文件是一种基于JavaWeb的企业门户网站 (155个子文件)
selectsql.class 13KB
connsqlserver.class 2KB
ModifyCode.class 2KB
MoreNewsPage.class 1KB
DownTable.class 1KB
NewsPage.class 1KB
product.class 1KB
StringTrans.class 1KB
news.class 1KB
category.class 915B
user.class 727B
.classpath 945B
org.eclipse.wst.jsdt.ui.superType.container 49B
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
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
14.gif 10KB
7.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
8.gif 517B
3.gif 517B
2.gif 517B
13.gif 484B
9.gif 458B
6.gif 456B
1.gif 456B
11.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 15KB
connsqlserver.java 1KB
ModifyCode.java 1KB
共 155 条
- 1
- 2
Csdnable
- 粉丝: 3
- 资源: 39
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0