buybook.java

2． 实现用户注册

/*
 * 创建日期 2007-4-27
 *
 * TODO 要更改此生成的文件的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
package aa;



/**
 * @author Administrator
 *
 * TODO 要更改此生成的类型注释的模板，请转至
 * 窗口 － 首选项 － 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","sa","");
	  	sql=con.createStatement();
	  	String condition="select * from book where id="+id;
	  	rs=sql.executeQuery(condition);
	  	buffer.append("<table border><font size=3");
	  	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 author=rs.getString(4);
	  		String pulic=rs.getString(5);
	  		Date time=rs.getDate(6);
	  		String price=rs.getString("price");
	  		String category=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>"+author+"</font>");
	  		buffer.append("<td>"+"<font size=3>"+pulic+"</font>");
	  		buffer.append("<td>"+"<font size=3>"+time+"</font>");
	  		buffer.append("<td>"+"<font size=3>"+price+"</font>");
	  		buffer.append("<td>"+"<font size=3>"+category+"</font>");
	  		buffer.append("</tr>");
	  		}
	  	buffer.append("</table>");
	  	buffer.append("</font>");
	  	con.close();
	  	return buffer;
		}catch(SQLException e){return buffer;}
	}
};