orderform.java

来自「这套JSP学习资料」· Java 代码 · 共 101 行

import java.sql.*;

public class OrderForm
{
	String logname,realname,order_number,book_name,phone,address,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 getBook_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","","");
			sql=con.createStatement();
			String s="'"+logname+"'"+","+"'"+realname+"'"+","+"'"+order_number+"'"+","+"'"+book_name+"'"+","+"'"+mount+"'"+","+"'"+phone+"'"+","+"'"+address+"'";
			String condition="INSERT INTO orderform VALUES"+"("+s+")";
			sql.executeUpdate(condition);
			con.close();
			return "该书被添加到你的订单";
		}catch(SQLException e)
		{	
			return "你已经订购了该书，请去修改订单后再订购";
		}
	}

}