connectioncustomer.java

JAVA网上书店的程序原代码,希望对大家偶用

package ebookshop.servlet;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import ebookshop.common.DataConnect;

public class ConnectionCustomer 
{
	public String getData(String userName,String passWord)
	{
		String tableName="customer";
		String sqlStr="select userName,passWord from "+tableName; 
				// "+"where userName=\""+userName+"\" "+"and"+" "+"passWord='"+passWord+"'";		
		
		Connection con=new DataConnect().getConnection("netbookdata");
		Statement st =null;
		ResultSet rs =null;		
		String resp=null;		
		try {
			
			st = con.createStatement();
			rs=st.executeQuery(sqlStr);
			while(rs.next())
			{
				if(rs.getString("userName").equals(userName) && rs.getString("passWord").equals(passWord))
				{
					resp="ok";
					return resp;
				}
				else
				{
					resp="no";
				}
			}
				
		}
		
		catch (SQLException e) {
			
			e.printStackTrace();
			//return;
			
		}
		finally
		{
			
				
			if(rs != null)
				try
				{
					rs.close();
				}
				catch(Exception e){e.getMessage();}
				
				if(st!= null)
					try
					{
						st.close();
					}
					catch(Exception e){e.getMessage();}
					if(con != null)
						try
						{
							con.close();
						}
						catch(Exception e){e.getMessage();}
				
		}
		return resp;

	}
}