userentity.java

使用JSP技术实现销售管理平台

package cart;
import java.sql.*;
import java.util.*;
import java.math.*;

public class UserEntity
{
	private String id;
	private String userName;
	private String userPassword;
	
	
	public static String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
	public static String sConnStr = "jdbc:odbc:cart";
	public static Connection conn = null;
	
	public UserEntity(String id,String userName,String userPassword)
	{
		try 
		{
			Class.forName(sDBDriver); 
	    	}
	  	catch(java.lang.ClassNotFoundException e) 
	  	{
			System.err.println("UserEntity: " + e.getMessage());
		}
		
		this.id=id;
		this.userName=userName;
		this.userPassword=userPassword;
		
	}
	
	public static UserEntity queryUser(String userName) throws SQLException
	{
		try 
		{
			Class.forName(sDBDriver); 
	    	}
	  	catch(java.lang.ClassNotFoundException e) 
	  	{
			System.err.println("UserEntity: " + e.getMessage());
		}
                
                //query from database
		String sql="select id,user_name,user_password from user where user_name= ? ";
				
		ResultSet rs = null;
		try 
		{
			conn = DriverManager.getConnection(sConnStr); 
			PreparedStatement prepStmt = conn.prepareStatement(sql);
			
			prepStmt.setString(1,userName);
			
			rs = prepStmt.executeQuery();
		} 
		catch(SQLException ex) 
		{ 
			System.err.println("OrderItemEntity executeQuery: " + ex.getMessage());
		}
				
		UserEntity user=null;
		if(rs.next())
			user=new UserEntity(rs.getString(1),rs.getString(2),rs.getString(3));
		
		return user;
		
	}
	
	public String getUserName()
	{
		return userName;
	}
	
	public String getUserPassword()
	{
		return userPassword;
	}
	
}