网上购物商城系统的毕业论文(8)

}

UserDao ud=new UserDao();

boolean bed=ud.getName(uname); if(bed){ out.print(\用户名已存在,请重新填写注册信息!');

window.location='regist.jsp'\); }

User u=new User(); u.setName(uname); u.setPassword(upwd); u.setMail(uemail); boolean b=ud.add(u); if(b==false){ out.print(\信息填写不完整,请重新填写注册信息!');

window.location='regist.jsp'\); } else{ session.setAttribute(\,u); out.print(\注册成功!');

window.location='login.jsp'\); }

2.用户登陆模块核心代码：

/**

* 用户的登录的方法 验证用户信息 * @param name 用户名 * @param pwd 密码 * @return 用户信息 */

public User login(String username,String userpwd){ String sql=\; Connection conn=null; PreparedStatement st=null; ResultSet rs=null; User u_login=null; try { conn=DBHelper.getConnection(); st=conn.prepareStatement(sql); st.setString(1,username); st.setString(2,userpwd); rs=st.executeQuery(); if(rs.next()){ u_login=new User(); u_login.setId((int)rs.getDouble(1));

u_login.setName(rs.getString(2)); u_login.setPassword(rs.getString(3)); u_login.setMail(rs.getString(4)); u_login.setAdd(rs.getString(5)); u_login.setSex(rs.getString(6)); u_login.setPhone(rs.getString(7)); u_login.setSum(rs.getDouble(8)); u_login.setPoint((int)rs.getDouble(9)); }

} catch (SQLException e) { e.printStackTrace(); }finally{ DBHelper.close(rs, st, conn); }

return u_login;

}

public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding(\); response.setContentType(\); HttpSession session=request.getSession(); String username=request.getParameter(\); String userpwd=request.getParameter(\); String gid=request.getParameter(\); PrintWriter out=response.getWriter(); UserDao ud=new UserDao(); User u=ud.login(username,userpwd); System.out.println(\+username+\ pwd:\+userpwd); if(null!=u&&!u.equals(\)&&u.getName().equals(username)&&u.getPassword().equals(userpwd)){ session.setAttribute(\,u); System.out.println(gid); if(gid==null||gid.equals(\)){ response.sendRedirect(\); }else{ GoodDao gd=new GoodDao(); TbgoodsInfo g=gd.getMessage(gid); session.setAttribute(\, g); response.sendRedirect(\);

}

} } else{ out.print(\帐号或密码错误');

window.location='login.jsp'\); }

out.flush(); out.close();

3.商品展示模块核心代码：

//所有的商品的集合

public List getAll(){ List Goods = new ArrayList(); String sql = \; try{ conn = DBHelper.getConnection(); st=conn.prepareStatement(sql); rs=st.executeQuery(); while(rs.next()){ TbgoodsInfo g= new TbgoodsInfo(); g.setGoods_no(rs.getString(1)); g.setGoods_name(rs.getString(2)); g.setGoods_price(rs.getFloat(3)); g.setKind_no(rs.getInt(4)); g.setGoods_path(rs.getString(5)); g.setGoods_kucun(rs.getInt(6)); g.setGoods_weight(rs.getFloat(7)); Goods.add(g); } }catch(SQLException e){ e.printStackTrace(); }finally{ DBHelper.close(rs, st, conn); } return Goods; }

public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

request.setCharacterEncoding(\);

response.setContentType(\); //首页数据可共享 用application

ServletContext application=this.getServletContext(); Tb_goodsDAO tbd=new Tb_goodsDAO(); List tbgoodses=tbd.getAll(); application.setAttribute(\,tbgoodses); //session.setAttribute(\ response.sendRedirect(\); }

4.商品详情页面核心代码：

//获得一件商品的详细信息

public TbgoodsInfo getMessage(String no){ String sql = \+no; TbgoodsInfo g=null; try{ conn = DBHelper.getConnection(); st=conn.prepareStatement(sql); rs=st.executeQuery(); while(rs.next()){ g=new TbgoodsInfo(); g.setGoods_no(rs.getString(1)); g.setGoods_name(rs.getString(2)); g.setGoods_price(rs.getDouble(3)); g.setKind_no(rs.getInt(4)); g.setGoods_path(rs.getString(5)); g.setGoods_kucun(rs.getInt(6)); g.setGoods_weight(rs.getFloat(7)); } }catch(SQLException e){ e.printStackTrace(); }finally{ DBHelper.close(rs, st, conn); } return g;

}

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding(\); response.setContentType(\); GoodDao gd = new GoodDao();

//获取前一个页面的商品id

//int id=Integer.parseInt(request.getAttribute(\ String id=request.getParameter(\); System.out.println(id);

TbgoodsInfo g = gd.getMessage(id);

/*HttpSession session=request.getSession(); session.setAttribute(\

String name = g.getGoods_name(); float price =(float) g.getGoods_price(); int kind = g.getKind_no();

String path = g.getGoods_path();

float weight = (float) g.getGoods_weight(); int kucun = g.getGoods_kucun();*/ //数据可共享 用application

ServletContext application=this.getServletContext(); application.setAttribute(\, g); response.sendRedirect(\); }

}

5.购物车模块核心代码：

//向购物车增加商品

public void addgoods_mark(Shopping_card cartItem){ String sql=null; sql=\ + \ + \; try{ conn = DBHelper.getConnection(); st=conn.prepareStatement(sql); st.setInt(1, cartItem.getU().getId()); st.setString(2, cartItem.getG().getGoods_no()); st.setInt(3, cartItem.getCount()); st.executeUpdate(); }catch(SQLException e){ System.err.println(\增加的商品id已经存在，所以只加数量\);

Sql=\

sql=\shopping_card

goods_count=goods_count+\+cartItem.getCount()+\+cartItem.getG().getGoods_no(); try { conn= DBHelper.getConnection(); st=conn.prepareStatement(sql); st.executeUpdate(); } catch (SQLException e1) {

set