registration.java

这是用java实现的一个仓储管理系统

//先创建一个银行数据库"EarnestBank",数据源名为"MyEarnBK",
//建立客户注册表,表名="Registration",
//有6个字段:
//cFirst_name(名,char),cLast_name(姓,char),cAddress(地址,char),
//cAccount_type(帐号类型,char),mAnnual_income(钱数,money),
//cPhone_no(电话号码,char)
//以下代码向Registration表插入一条记录,数据从键盘输入.


import java.sql.*;
import java.io.*;

public class Registration
{
    public static void main(String args[])
    {
            Connection con=null;
	    PreparedStatement stat=null;
	    int res=0;

	    BufferedReader br = new BufferedReader(new InputStreamReader(System.in));
	    try
	    {
	        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	        con=DriverManager.getConnection("jdbc:odbc:MyEarnBK","sa","sa");
	        stat=con.prepareStatement("insert into Registration(cFirst_name,cLast_name,cAddress,cAccount_type,mAnnual_income,cPhone_no) values(?,?,?,?,?,?)");

	        System.out.print("First_name = ");
	        String First_name=br.readLine();   //从键盘读入值存入字串变量中

	        System.out.print("Last_name = ");
	        String Last_name=br.readLine();

	        System.out.print("Address = ");
	        String Address=br.readLine();

	        System.out.print("Account_type = ");
	        String Account_type=br.readLine();

	        System.out.print("Annual_income = ");
	        String Annual_income=br.readLine();

	        System.out.print("Phone_no = ");
	        String Phone_no=br.readLine();

	        stat.setString(1,First_name);  //用值替换SQL语句中的问号参数
	        stat.setString(2,Last_name);
	        stat.setString(3,Address);
                stat.setString(4,Account_type);
                stat.setFloat(5,Float.parseFloat(Annual_income));   //第5个属性是钱数,不是字符型
	        stat.setString(6,Phone_no);

	        res=stat.executeUpdate();
	        if (res!=0)
                System.out.println("Your details have been registered");
	    }

	    catch(Exception ex)
        {      
     	    System.out.println("Error registe: "+ex);
        }
	    if (con!=null)
	    	con=null;
    }
}