orderform.java

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

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 "你已经订购了该书，请去修改订单后再订购";
			}
	}

}