tianjiabeanbo.java

用MVC实现JSP购物车案例说明详细设计方案

package com.shop.model;
import java.sql.*;
import java.util.ArrayList;
public class TianjiaBeanBo {
	private Connection conn=null;
	private PreparedStatement pstmt=null;
	private ResultSet rs=null;
	/*public void insertmain(String bookid[],String authorid,String num[])
	{
		try {
			for(int i=0;i<bookid.length;i++)
			{
				
				String sql="insert into main values("+bookid[i]+","+authorid+","+num[i]+")";
				conn=new Conn().getConn();
				pstmt=conn.prepareStatement(sql);
				pstmt.executeQuery();
			}
		} catch (Exception e) {
			e.printStackTrace();
			// TODO: handle exception
		}
		finally 
		{
			try {
				rs.close();
				pstmt.close();
				conn.close();
			} catch (Exception e) {
				e.printStackTrace();
				// TODO: handle exception
			}
		}
	}
	public void insertprice(String allPrice,java.sql.Date datatime,String authorsid)
	{
		try {
			String sql="insert into price values("+allPrice+","+datatime+","+authorsid+")";
			conn=new Conn().getConn();
			pstmt=conn.prepareStatement(sql);
			pstmt.executeQuery();
		} catch (Exception e) {
			e.printStackTrace();
			// TODO: handle exception
		}
		finally 
		{
			try {
				rs.close();
				pstmt.close();
				conn.close();
			} catch (Exception e) {
				e.printStackTrace();
				// TODO: handle exception
			}
		}
	}*/
	public ArrayList showdingdan()
	{
		ArrayList al=new ArrayList();
		try {
			String sql="select s_name,username,m_num,p_allPrice,p_data from main,price,goods,users where p_m_userid_id=m_userid and m_s_id=s_id and m_userid=userid";
		
			conn=new Conn().getConn();
			pstmt=conn.prepareStatement(sql);
			rs=pstmt.executeQuery();
			while(rs.next())
			{
				GoodsBean gb=new GoodsBean();
				UserBean ub=new UserBean();
				TijiaoBean tb=new TijiaoBean();
				gb.setS_name(rs.getString(2));
				ub.setUsername(rs.getString(2));
				tb.setM_num(rs.getInt(4));
				//tb.setP_allPrice(rs.getFloat(2)); 
				//tb.setP_data(rs.getDate(3));
				al.add(gb);
				al.add(ub);
				al.add(tb);
			}
		} catch (Exception e) {
			e.printStackTrace();
			// TODO: handle exception
		}
		finally
		{
			try {
				rs.close();
				pstmt.close();
				conn.close();
			} catch (Exception e) {
				e.printStackTrace();
				// TODO: handle exception
			}
		}
		return al;
	}
	public void insertmain(String string, String uname, String string2) {
		// TODO 自动生成方法存根
		try {
			for(int i=0;i<string.length();i++)
			{
				String sql2="select userid from users where username='"+uname+"'";
				conn=new Conn().getConn();
				pstmt=conn.prepareStatement(sql2);
				rs=pstmt.executeQuery();
				int rs2=1;
				if(rs.next())
				{
					rs2=Integer.parseInt(rs.getString(1));
				}
				
				String sql="insert into main values("+string+","+rs2+","+string2+")";
				
				pstmt=conn.prepareStatement(sql);
				pstmt.executeUpdate();
			}
		} catch (Exception e) {
			e.printStackTrace();
			// TODO: handle exception
		}
		finally 
		{
			try {
				rs.close();
				pstmt.close();
				conn.close();
			} catch (Exception e) {
				e.printStackTrace();
				// TODO: handle exception
			}
		}
	}
	public void insertprice(String price, String string, String uname) {
		// TODO 自动生成方法存根
		try {
			String sql2="select userid from users where username='"+uname+"'";
			conn=new ConnDB().getConn();
			pstmt=conn.prepareStatement(sql2);
			rs=pstmt.executeQuery();
			int rs2=1;
			if(rs.next())
			{
				rs2=Integer.parseInt(rs.getString(1));
			}
		
			String sql="insert into price values("+price+",'"+string+"',"+rs2+")";
			//conn=new Conn()DB.getConn();
			pstmt=conn.prepareStatement(sql);
			pstmt.executeUpdate();
		} catch (Exception e) {
			e.printStackTrace();
			// TODO: handle exception
		}
		finally 
		{
			try {
				if(rs!=null)
				{
					rs.close();
				}
				pstmt.close();
				conn.close();
			} catch (Exception e) {
				e.printStackTrace();
				// TODO: handle exception
			}
		}
	}

}