accountserverimpl.java

来自「J2EE指南」· Java 代码 · 共 73 行

import java.rmi.*;
import java.rmi.server.UnicastRemoteObject;
import java.sql.*;

public class AccountServerImpl extends UnicastRemoteObject
implements AccountServer
{

	static ResultSet result;
	static Connection con;
	static PreparedStatement stat;
	public AccountServerImpl() throws RemoteException
	{
		super();
	}

	public String insertDetails(String firstName,String lastName,String address,String phone,String income,String accountType) throws RemoteException
	{
		int rowsAffected = 0;
		String sReturn = "fail";


		try
		{

			int income1=Integer.parseInt(income);


			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

			con=DriverManager.getConnection("jdbc:odbc:MyDataSource", "sa", "");

			stat=con.prepareStatement("Insert Registration values(?, ?, ?, ?, ?, ?)");


			stat.setString(1, firstName);
			stat.setString(2, lastName);
			stat.setString(3, address);
			stat.setString(4, accountType);
			stat.setInt(5, income1);
			stat.setString(6, phone);
			rowsAffected = stat.executeUpdate();
			
			if(rowsAffected>0)
			{
				 sReturn = "success";
			}

		}

		catch(Exception v)
		{
			System.out.println("error at value insert" + v);
		}
		return sReturn;
	}

	public static void main(String args[])
	{
		System.setSecurityManager(new RMISecurityManager());
		try
		{
  		  AccountServerImpl instance = new AccountServerImpl();
		  Naming.rebind("AccountServer",instance);
		  System.out.println("Server Registered");
		}
		catch(Exception e)
		{
		  System.err.println(e);
		}
	}
}