booksql.java

从一开始就使用动态提交技术

package bookshop;

import java.sql.*;
import java.util.*;


public class bookSql 
{
	Connection con;
	public bookSql()
	{
		con=bookConnectionSql.getConnect();
	}
	public Vector getClassBook()
	{
		Vector v=new Vector(1,1);
		
		try
		{
			Statement sta=con.createStatement();
			ResultSet rs=sta.executeQuery("Select * from classbook");
			while(rs.next())
			{
				classBookBean cBook=new classBookBean();
				cBook.setClassid(rs.getString(1).trim());
				cBook.setClassname(rs.getString(2).trim());
				v.add(cBook);
			}
		}catch(Exception e)
		{System.out.println(e);}
		return v;
	}
	public Vector getSelectBook(String id)
	{
		Vector v=new Vector(1,1);
		try
		{
			Statement sta=con.createStatement();
			ResultSet rs=sta.executeQuery("Select * from book where classid='"+id+"'");
			while(rs.next())
			{
				bookBean Book=new bookBean();
				Book.setBookid(rs.getString(1).trim());
				Book.setBookname(rs.getString(2).trim());
				Book.setBookauthor(rs.getString(3).trim());
				Book.setPublish(rs.getString(4).trim());
				Book.setPrice(rs.getDouble(5));
				v.add(Book);
			}
		}catch(Exception e)
		{System.out.println(e);}
		return v;
		
	}
	public Vector getBuyBook(String Bookid)
	{
		Vector v=new Vector(1,1);
		try
		{
			Statement sta=con.createStatement();
			ResultSet rs=sta.executeQuery("Select bookname,price from book where bookid='"+Bookid+"'");
			while(rs.next())
			{
				bookBean Book=new bookBean();
				Book.setBookname(rs.getString(1).trim());
				Book.setPrice(rs.getDouble(2));
				v.add(Book);
			}
		}catch(Exception e)
		{System.out.println(e);}
		return v;
		
	}

}