package dbcon;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
public class DBdao {
//查询商品类别
public ArrayList getbooktype()
{
ArrayList list=new ArrayList();
String sql="select * from booktype_tb";
Connection conn=null;
try {
conn=DBcon.getconn();
Statement sta=conn.createStatement();
ResultSet res=sta.executeQuery(sql);
while(res!=null&&res.next())
{
booktype_tb type=new booktype_tb();
type.setType_id(res.getInt("type_id"));
type.setType_name(res.getString("type_name"));
type.setType_info(res.getString("type_info"));
list.add(type);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}
//查询销量前十的商品
public ArrayList getbook()
{
ArrayList list=new ArrayList();
String sql="select top 10 * from book_tb b ,(select book_id, sum(subscibe_num) num from userorderinfo_tb group by book_id) s where b.bookid = s.book_id order by s.num desc";
System.out.println(sql);
Connection conn=DBcon.getconn();
try {
Statement sta=conn.createStatement();
ResultSet res= sta.executeQuery(sql);
while(res!=null&&res.next())
{
book_tb book=new book_tb();
book.setBookid(res.getInt("bookid"));
book.setBookname(res.getString("bookname"));
book.setAutor(res.getString("autor"));
book.setBook_concern(res.getString("book_concern"));
book.setSynopsis(res.getString("synopsis"));
book.setList(res.getString("list"));
book.setImage(res.getString("image"));
book.setMarket_price(res.getFloat("market_price"));
book.setPreferential_price(res.getFloat("preferential_price"));
book.setType_id(res.getInt("type_id"));
list.add(book);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}
//根据图书类别查询图书
public ArrayList getbookbytype(String type_name)
{
ArrayList list=new ArrayList();
String sql="select * from book_tb where type_id=(select type_id from booktype_tb where type_name='"+type_name+"')";
Connection conn=DBcon.getconn();
try {
Statement sta=conn.createStatement();
ResultSet res= sta.executeQuery(sql);
while(res!=null&&res.next())
{
book_tb book=new book_tb();
book.setBookid(res.getInt("bookid"));
book.setBookname(res.getString("bookname"));
book.setAutor(res.getString("autor"));
book.setBook_concern(res.getString("book_concern"));
book.setSynopsis(res.getString("synopsis"));
book.setList(res.getString("list"));
book.setImage(res.getString("image"));
book.setMarket_price(res.getFloat("market_price"));
book.setPreferential_price(res.getFloat("preferential_price"));
book.setType_id(res.getInt("type_id"));
list.add(book);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}
//新书上架 查询最进刚出来的书 根据id 自增
public ArrayList getnewbook()
{
ArrayList list=new ArrayList();
String sql="select top 10 * from book_tb order by bookid desc";
Connection conn=DBcon.getconn();
try {
Statement sta=conn.createStatement();
ResultSet res= sta.executeQuery(sql);
while(res!=null&&res.next())
{
book_tb book=new book_tb();
book.setBookid(res.getInt("bookid"));
book.setBookname(res.getString("bookname"));
book.setAutor(res.getString("autor"));
book.setBook_concern(res.getString("book_concern"));
book.setSynopsis(res.getString("synopsis"));
book.setList(res.getString("list"));
book.setImage(res.getString("image"));
book.setMarket_price(res.getFloat("market_price"));
book.setPreferential_price(res.getFloat("preferential_price"));
book.setType_id(res.getInt("type_id"));
list.add(book);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}
//根据图书id 查询该图书所有信息
public book_tb selectbyid(int bookid)
{
book_tb book=new book_tb();
String sql="select * from book_tb where bookid="+bookid;
Connection conn=DBcon.getconn();
try {
Statement sta=conn.createStatement();
ResultSet res= sta.executeQuery(sql);
while(res!=null&&res.next())
{
book.setBookid(res.getInt("bookid"));
book.setBookname(res.getString("bookname"));
book.setAutor(res.getString("autor"));
book.setBook_concern(res.getString("book_concern"));
book.setSynopsis(res.getString("synopsis"));
book.setList(res.getString("list"));
book.setImage(res.getString("image"));
book.setMarket_price(res.getFloat("market_price"));
book.setPreferential_price(res.getFloat("preferential_price"));
book.setType_id(res.getInt("type_id"));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return book;
}
/*
* 新用户注册
*/
public boolean adduser(user_tb user)
{
String sql="insert into user_tb values (?,?,?,?,?,?,?,?)";
PreparedStatement pps=null;
Connection conn=DBcon.getconn();
try {
pps= conn.prepareStatement(sql);
pps.setString(1, user.getUser_name());
pps.setString(2, user.getUser_psw());
pps.setString(3, user.getUser_truename());
pps.setString(4, user.getUser_email());
pps.setString(5, user.getUser_tel());
pps.setString(6, user.getUser_address());
pps.setString(7, user.getUser_type());
pps.setString(8, user.getUser_state());
int i=pps.executeUpdate();
if(i==1)
{
System.out.println("添加成功!");
return true;
}
} catch (SQLException e) {
e.printStackTrace();
}
finally
{
if(pps!=null)
{
try {
pps.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
else if(conn!=null)
{
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
return false;
}
/*
* 用户登陆查询
*/
public user_tb selectuser(String username,String psw)
{
String sql="select * from user_tb where user_psw='"+psw+"' and user_name='"+username+"'";
Connection conn=DBcon.getconn();
ResultSet res=null;
Statement stm=null;
try {
stm=conn.createStatement();
res=stm.executeQuery(sql);
if(res!=null&&res.next())
{
user_tb user=new user_tb();
user.setUser_id(res.getInt("user_id"));
user.setUser_name(res.getString("user_name"));
user.setUser_psw(res.getString("user_psw"));
user.setUser_address(res.getString("user_address"));
user.setUser_email(res.getString("user_email"));
user.setUser_tel(res.getString("user_tel"));
user.setUser_truename(res.getString("user_truename"));
user.setUser_type(res.getString("user_type"));
System.out.println("登陆成功");
return user;
}
else
{
System.out.println("用户名或密码输入错误请重新登陆");
return null;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}
finally
{
if(res!=null)
{
try {
res.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
else if(stm!=null)
{
try {
stm.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
else if(conn!=null)
{
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
/*
* 用户登陆后修改个人信息
*/
public boolean updateuser(user_tb user,int userid)
{
Stri
jsp项目（网上书店） （355个子文件） 
DBdao.class 33KB UploadServlet.class 7KB chaxunfangfa.class 5KB insertclass.class 5KB pageorderuser.class 5KB VerifyCodeServlet.class 4KB loginservlet.class 4KB insertdingdan.class 4KB page.class 3KB pagedb.class 3KB zhuceservlet.class 3KB delbook.class 3KB fangfa.class 3KB wodedingdan.class 3KB pageservlet.class 3KB xiangxibook.class 3KB myshoppingservlet.class 3KB writeservlet.class 2KB book_tb.class 2KB statefenyeservlet.class 2KB fenyeservlet.class 2KB userorder_tb.class 2KB user_tb.class 2KB xiugaicount.class 2KB updateuserstate.class 2KB timefenyeservlet.class 2KB sailorderservlet.class 2KB type2orderservlet.class 2KB typeorderservlet.class 2KB stateorderservlet.class 2KB addressservlet.class 2KB delbooktype.class 2KB usernameservlet.class 2KB orderfenyeservlet.class 2KB updateuserinfo.class 2KB shanchu.class 2KB orderservlet.class 2KB timeorderservlet.class 2KB czservlet.class 2KB gouwuche.class 2KB updatebooktype.class 2KB showallservlert.class 2KB listbooktype.class 2KB listbooktype2.class 2KB updateorderservlet.class 2KB panduan.class 2KB qingkong.class 2KB dingdanmingxi.class 2KB selectfirst.class 2KB userservlet.class 2KB typeservlet.class 2KB indexservlet.class 2KB addbooktypeservlet.class 2KB dingdanqueren.class 2KB userorderinfo_tb.class 1KB listbook2.class 1KB updatetype.class 1KB listbook.class 1KB fil.class 1KB booktype.class 1KB bookreview_tb.class 1KB DBcon.class 1KB booktype_tb.class 946B .classpath 712B all.css 26KB book.css 16KB comm_answer.css 12KB public_footer090310.css 2KB secBook_Show.css 1KB
sale_logo.gif 12KB 55165863271.gif 12KB left_top.gif 8KB jiesuan.gif 6KB shopping.gif 5KB buyhc.gif 3KB an_bag_tellme.gif 2KB butt_balance.gif 2KB logo_home.gif 2KB logo_atten.gif 1KB button_member.gif 1KB button_home.gif 1KB button_contact.gif 1KB button_cart.gif 1KB button_cashier.gif 1KB button_faq.gif 1KB an_bag2.gif 1KB button.gif 768B button_s.gif 718B search.gif 624B logo_buy.gif 363B logo_mine.gif 269B top_1.gif 152B new.gif 111B left_10.gif 64B left_4.gif 60B left_9.gif 59B left_5.gif 59B left_6.gif 59B left_2.gif 58B left_8.gif 58B共 355 条
- 1
- 2
- 3
- 4
资源评论
youyuhehe6182012-05-26jsp简单项目实现
shitiantian2013-06-28不错，很全
