buybook.java

手工完成

package Bean;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.ArrayList;

public class BuyBook {

	public void insert(BuyBookBean buybook)
	{
		Bean.BuyBookBean book = buybook;
		Connection conn = null;
			conn = new DBConn().getConn();
			String sql = null;
			sql = "INSERT INTO buybook (username,bookID,count,money) VALUES (?,?,?,?)";
			
			try {
				PreparedStatement ps=conn.prepareStatement(sql);
				
				System.out.println("++++++++++++++++++++++++++++++++++++++++++");
				ps.setString(1, buybook.getUsername());System.out.println(buybook.getUsername());
				ps.setString(2, buybook.getBookID());System.out.println(buybook.getBookID());
				ps.setInt(3, buybook.getCount());System.out.println(buybook.getCount());
				ps.setDouble(4, buybook.getMoney());System.out.println(buybook.getMoney());
				
				ps.executeUpdate();//
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
			System.out.println("数据成功插入到数据库中！");
	}
	
	public ArrayList bookquery(String strusername)
	{
		String SQLString = "";
		String username = strusername;
		
		java.sql.ResultSet sqlRst = null;
		java.sql.Statement Stmt = null;
//		Users user = new Users();                 //--------这句话写在是错误的-----
		ArrayList<BuyBookBean> arraylist = new ArrayList();
		
		Connection conn=new DBConn().getConn();
		try 
		{
	//		SQLString = "select * from UsersAccess where UsersTable = " + "'" + ID + "'";
			SQLString = "select * from buybook where username = '" + username + "'";
			Stmt = conn.createStatement(); //语句对象 
			sqlRst=Stmt.executeQuery ( SQLString); ; //结果集对象 
			
			while(sqlRst.next())
			{
				Bean.BuyBookBean buybook = new Bean.BuyBookBean();   //---这句话必须写在这------
				buybook.setBookID(sqlRst.getString("bookID"));
				buybook.setUsername(sqlRst.getString("bookName"));
				buybook.setCount(sqlRst.getInt("count"));
				buybook.setMoney(sqlRst.getDouble("money"));
				
				arraylist.add(buybook);   //----把BookBean放入ArrayList中
			}
				Stmt.close (); 
				conn.close();
	
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		
		return arraylist;
	}
	
	public ArrayList buybookquery(String strusername)
	{
		String SQLString = "";
		String username = strusername;
		
		java.sql.ResultSet sqlRst = null;
		java.sql.Statement Stmt = null;
//		Users user = new Users();                 //--------这句话写在是错误的-----
		ArrayList<BookBean> arraylist = new ArrayList();
		
		Connection conn=new DBConn().getConn();
		try 
		{
			SQLString = "select * from buybook,book where username = ? and buybook.bookID = book.bookID";	
			PreparedStatement ps=conn.prepareStatement(SQLString);
			
			ps.setString(1,username);
			sqlRst = ps.executeQuery();
//			Stmt = conn.createStatement(); //语句对象 
//			sqlRst=Stmt.executeQuery ( SQLString); ; //结果集对象 
			
			while(sqlRst.next())
			{
				Bean.BookBean book = new Bean.BookBean();   //---这句话必须写在这------
				
				book.setBookID(sqlRst.getString("bookID"));
				book.setBookName(sqlRst.getString("bookName"));
				book.setAuthor(sqlRst.getString("author"));
				book.setPrice(sqlRst.getDouble("price"));
				book.setDiscount(sqlRst.getDouble("discount"));
				book.setPress(sqlRst.getString("press"));
				book.setSum(sqlRst.getInt("count"));
				book.setPicroot(sqlRst.getString("picroot"));
				
				arraylist.add(book);   //----把BookBean放入ArrayList中
			}
//				Stmt.close (); 
				conn.close();
	
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		
		return arraylist;
	}
}