orderform.java

2． 实现用户注册

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

/**
 * @author Administrator
 *
 * TODO 要更改此生成的类型注释的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
import java.sql.*;
public class OrderForm {
   String logname,realname,order_number,phone,address,book_name,mount;
   Connection con;
   Statement sql;
   ResultSet rs;
   public OrderForm()
   {
   	try{
   		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   		}catch(ClassNotFoundException e){}
   	}
   public void setLogname(String name)
   {logname=name;}
   public String getLogname()
   {return logname;}
   public void setRealname(String name)
   {realname=name;}
   public String getRealname()
   {return realname;}
   public void setOrder_number(String number)
   {order_number=number;}
   public String getOrder_number()
   {return order_number;}
   public void setBook_name(String name)
   {book_name=name;}
   public String setBook_name()
   {return book_name;}
   public void setPhone(String ph)
   {phone=ph;}
   public String getPhone()
   {return phone;}
   public void setAddress(String ad)
   {address=ad;}
   public String getAddress()
   {return address;}
   public void setMount(String n)
   {mount=n;}
   public String getMount()
   {return mount;}
   public String setOrderBook()
   {
   	try{
   		con=DriverManager.getConnection("jdbc:odbc:shop","sa","");
   		sql=con.createStatement();
   		String s="'"+logname+"'"+","+"'"+realname+"'"+","+"'"+order_number+"'"+","+"'"+book_name+"'"+","+"'"+mount+"'"+","+"'"+phone+"'"+","+"'"+address+"'";
   		String condition="insert into orderform(logname,realname,order_number,book_name,mount,phone,address) values"+"("+s+")";
   		sql.executeUpdate(condition);
   		con.close();
   		return "该书被添加到你的定单";
   		}catch(SQLException e)
		{return "你已经订购了该书,请去修改定单后再订购";}
   	}
}