user.java

手机在线系统 采用Java 中的J2ME, JSP 跟MySql 运行环境是：jsdk1.4以上

/**
 * @(#)User.java	
 * Copyright (c) 2004-2005 wuhua of workroom Inc. All Rights Reserved.
 * @version 	1.0, 10/05/2004
 * @author 	饶荣庆
 * @author 	余煜辉
 */

package com.j2me.data;

import java.sql.*;
import java.util.*;

/*
 *此类是用来用户登陆的数据库连接，增加用户的数据库连接类
 */
public class User extends DataConnect
{

	/*获得结果集方法*/
	public ResultSet viewUser(String sql)
		throws SQLException, Exception
	{
		ResultSet rs = null;
  
		
		try
		{					
			Statement stmt = con.createStatement();
		    rs = stmt.executeQuery(sql);
		}
		catch(SQLException sqlexception)
		{
			error = "SQLException: Could not execute the query.";
			throw new SQLException(error);
		}
		catch(Exception e)
		{
			error = "Exception: An unknow error occurred while retrieving User.";
			throw new Exception(error);
		}
		return rs;
	}

	/*注册用户的方法*/
	public void registerUser(String user, String password, String eMail, String phone)
		throws SQLException, Exception
	{
		if (con != null)
		{
			PreparedStatement updataUser;
			try
			{
				updataUser = con.prepareStatement("insert into user values(?, ?, ?, ?);");
				updataUser.setString(1, user);
				updataUser.setString(2, password);
				updataUser.setString(3, eMail);
				updataUser.setString(4, phone);
				updataUser.execute();
			}
			catch(SQLException sqlexception)
			{
				error = "SQLException: updata faile, possible duplicate entry.";
				throw new SQLException(error);
			}
		}
		else
		{
			error = "Exception: Connection to database was lost.";
			throw new Exception(error);
		}
	}

}