buybook.java

可以让初学者有一个感性的认识

import java.sql.*;

public class BuyBook
{
	long id=0;
	String order_number,book_name;

	Connection con;
	Statement sql;
	ResultSet rs;

	public BuyBook()
	{	try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}catch(ClassNotFoundException e){}
	}

	public void setId(long n)
	{
		id=n;
	}

	public long getId()
	{
		return id;
	}
	
	public void setBook_name(String name)
	{
		book_name=name;
	}
	
	public String getBook_name()
	{
		return book_name;
	}
	public void setOrder_number(String number)
	{
		order_number=number;
	}
	
	public String getOrder_number()
	{
		return order_number;
	}
	
	public StringBuffer getMessageBybook_id()
	{	
		StringBuffer buffer=new StringBuffer();
		try
		{ 	con=DriverManager.getConnection("jdbc:odbc:shop","","");
			sql=con.createStatement();
			String condition="SELECT * FROM book WHERE id ="+id;
			rs=sql.executeQuery(condition);
			buffer.append("<Table Border>");
			buffer.append("<TR>");
				buffer.append("<TH width=50>"+"<Font size=3>"+"id"+"</Font>");
				buffer.append("<TH width=50>"+"<Font size=3>"+"订购号"+"</Font>");
				buffer.append("<TH width=70>"+"<Font size=3>"+"书名"+"</Font>");
				buffer.append("<TH width=60>"+"<Font size=3>"+"作者"+"</Font>");
				buffer.append("<TH width=60>"+"<Font size=3>"+"出版社"+"</Font>");
				buffer.append("<TH width=50>"+"<Font size=3>"+"出版时间"+"</Font>");
				buffer.append("<TH width=20>"+"<Font size=3>"+"价钱"+"</Font>");
				buffer.append("<TH width=50>"+"<Font size=3>"+"分类"+"</Font>");
			buffer.append("</TR>");

			while(rs.next())
			{
				order_number=rs.getString(2);
				book_name=rs.getString(3);
				String 作者=rs.getString(4);
				String 出版社=rs.getString(5);
				String 时间=rs.getString(6);
				String 价格=rs.getString("price");
				String 分类=rs.getString("category");
				buffer.append("<TR>");
					buffer.append("<TD>"+"<Font size=3>"+rs.getLong(1)+"</Font>");
					buffer.append("<TD>"+"<Font size=3>"+order_number+"</Font>");
					buffer.append("<TD>"+"<Font size=3>"+book_name+"</Font>");
					buffer.append("<TD>"+"<Font size=3>"+作者+"</Font>");
					buffer.append("<TD>"+"<Font size=3>"+出版社+"</Font>");
					buffer.append("<TD>"+"<Font size=3>"+时间+"</Font>");
					buffer.append("<TD>"+"<Font size=3>"+价格+"</Font>");
					buffer.append("<TD>"+"<Font size=3>"+分类+"</Font>");
				buffer.append("</TR>");
			}
			buffer.append("</Table>");
			con.close();
			return buffer;
		}catch(SQLException e)
		{	
			return buffer;
		}
	}
	
}