企业门户网站jsp+javabean+css和sql2000

package com.enterprise.conn; import com.enterprise.conn.ConnectionSql; import com.enterprise.bean.*; import java.sql.SQLException; import java.sql.ResultSet; import java.util.*; public class ExecuteSQL { public ExecuteSQL(){ } /** * * @param name * @param pwd * @return 标志 * 用户存在返回1，用户不存在返回0 */ public int checkUser(String name,String pwd){ int flag=0; String sql="select * from tb_usertable where name='"+name+"' and password='"+pwd+"'"; try{ ConnectionSql consql=new ConnectionSql(); ResultSet rs=consql.executequery(sql); if(rs.next()) flag=1; else flag=0; consql.close(); }catch(SQLException e){ e.printStackTrace(); } return flag; } /** * * @return newslist 新闻列表 * 返回新闻列表 */ public List<News> selectNewsAll(){ List<News> newslist=new ArrayList<News>(); String sql="select * from tb_news"; try{ ConnectionSql consql=new ConnectionSql(); ResultSet rs=consql.executequery(sql); while(rs.next()){ News news=new News(); news.setNewid(rs.getInt("id")); news.setContent(rs.getString("content")); news.setTitle(rs.getString("title")); news.setAuthor(rs.getString("author")); news.setSubmittime(rs.getString("submittime")); newslist.add(news); } consql.close(); }catch(SQLException e){ e.printStackTrace(); } return newslist; } /** * * @param id * @return 返回一条新闻信息 */ public News selectNewsByID(int id){ News news=new News(); String sql="select * from tb_news where id='"+id+"'"; try{ ConnectionSql consql=new ConnectionSql(); ResultSet rs=consql.executequery(sql); if(rs.next()){ news.setNewid(rs.getInt("id")); news.setContent(rs.getString("content")); news.setTitle(rs.getString("title")); news.setAuthor(rs.getString("author")); news.setSubmittime(rs.getString("submittime")); } consql.close(); }catch(SQLException e){ e.printStackTrace(); } return news; } /** * * @param news * @return flag * 如果成功插入一条新闻，则返回1，否则返回0 */ public int newsInsert(News news){ int flag=0; String sql="insert into tb_news(title,content,author) values('"+news.getTitle()+"','"+news.getContent()+"','"+news.getAuthor()+"')"; ConnectionSql consql=new ConnectionSql(); flag=consql.executeupdate(sql); consql.close(); return flag; } /** * * @param news * @return flag * 如果成功更新一条新闻，则返回1，否则返回0； */ public int newsUpdate(News news){ int flag=0; String sql="update tb_news set title='"+news.getTitle()+"',author='"+news.getAuthor()+"',content='"+news.getContent()+"'where id='"+news.getNewid()+"'"; ConnectionSql consql=new ConnectionSql(); flag=consql.executeupdate(sql); consql.close(); return flag; } /** * * @param id * @return flag * 如果删除新闻成功，返回1，否则返回0； */ public int newsDel(int id){ int flag=0; String sql="delete from tb_news where id='"+id+"'"; ConnectionSql consql=new ConnectionSql(); flag=consql.executeupdate(sql); consql.close(); return flag; } /** * * @return businesslist 产品列表 * 返回产品列表 */ public List<Business> selectBusinessAll(){ List<Business> businesslist=new ArrayList<Business>(); String sql="select * from tb_business"; try{ ConnectionSql consql=new ConnectionSql(); ResultSet rs=consql.executequery(sql); while(rs.next()){ Business business=new Business(); business.setBusinessid(rs.getInt("id")); business.setCategory(rs.getString("category")); business.setImg(rs.getString("img")); business.setMs(rs.getString("ms")); business.setName(rs.getString("name")); business.setSubmittime(rs.getString("submittime")); businesslist.add(business); } consql.close(); }catch(SQLException e){ e.printStackTrace(); } return businesslist; } /** * * @return 产品个数 * 返回产品个数 */ public int getBusinessCount(){ int count=0; String sql="select count(*) from tb_business"; try{ ConnectionSql consql=new ConnectionSql(); ResultSet rs=consql.executequery(sql); while(rs.next()){ count=rs.getInt(1); } rs.last(); consql.close(); }catch(SQLException e){ e.printStackTrace(); } return count; } /** * * @return 返回所有产品记录集 * 返回所有产品记录集 */ public ResultSet selectbusiness(){ ResultSet rs=null; try{ ConnectionSql consql=new ConnectionSql(); String sql="select * from tb_business"; rs=consql.executequery(sql); rs.last(); consql.close(); }catch(Exception e){ e.printStackTrace(); } //connsqlserver.close(); return rs; } /** * 按所分页码的要求查询相应产品信息 * @param page * @return 记录集 */ public List<Business> selestBsinessByPage(int page){ List<Business> businesslist=new ArrayList<Business>(); CountPage count=new CountPage(); ConnectionSql consql=new ConnectionSql(); String sql="select top "+5+" * from tb_business where id not in(select top "+count.getPagesize()*page+" id from tb_business order by id)order by id"; ResultSet rs=consql.executequery(sql); try { while(rs.next()){ Business business=new Business(); business.setBusinessid(rs.getInt("id")); business.setCategory(rs.getString("category")); business.setImg(rs.getString("img")); business.setMs(rs.getString("ms")); business.setName(rs.getString("name")); business.setSubmittime(rs.getString("submittime")); businesslist.add(business); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return businesslist; } /** * 实现商品的注册 * @param business * @return */ public int businessAdd(Business business){ int flag=0; ConnectionSql consql=new ConnectionSql(); String sql="insert into tb_business(name,img,ms,category) values('"+business.getName()+"','"+business.getImg()+"','"+business.getMs()+"','"+business.getCategory()+"')"; flag=consql.executeupdate(sql); consql.close(); return flag; } /** * 检索所有目录列表 * @return 目录列表 */ public List<Category> selectCategoryAll(){ List<Category> categorylist=new ArrayList<Category>(); String sql="select * from tb_category"; try{ ConnectionSql consql=new ConnectionSql(); ResultSet rs=consql.executequery(sql); while(rs.next()){ Category category=new Category(); category.setId(rs.getInt("id")); category.setCategoryname(rs.getString("categoryname")); category.setSubmittime(rs.getString("submittime")); categorylist.add(category); } consql.close(); }catch(SQLException e){ e.printStackTrace(); } return categorylist; } }