jsp新代码第208课

new208.java

package pack03;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class new208
{
	public final static String DRIVER = "com.mysql.jdbc.Driver";
	public final static String URL = "jdbc:mysql://localhost:3306/test?&useUnicode=true&characterEncoding=utf-8";
	public final static String DBNAME = "root";
	public final static String DBPASS = "mysql123";
	
	public Connection getConnection() throws ClassNotFoundException
	{
		Connection conn = null;
		try
		{
			conn = DriverManager.getConnection(URL,DBNAME,DBPASS);
			
		} 
		catch (SQLException e) 
		{
			e.printStackTrace();
		}
		
		return conn;
	}
	
	public void close(Connection conn)
	{
		try
		{
			if (conn != null)
			{
				conn.close();
				conn = null;
			}
		} 
		catch (SQLException e)
		{
			e.printStackTrace();
		}
	}
	
	public void close(PreparedStatement pstmt)
	{
		try
		{
			if(pstmt != null)
			{
				pstmt.close();
				pstmt = null;
			}
		} 
		catch (SQLException e)
		{
			e.printStackTrace();
		}
	}
	
	public void close(ResultSet rs)
	{
		try
		{
			if(rs != null)
			{
				rs.close();
				rs = null;
			}
		} 
		catch (SQLException e)
		{
			e.printStackTrace();
		}
	}
	
	public boolean doLogin(String sql,String[] params) 
	{
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		int num = 0;
		boolean flag = false;
		
		try
		{
			try
			{
				conn = this.getConnection();
			} 
			catch (ClassNotFoundException e)
			{
				e.printStackTrace();
			}
			pstmt = conn.prepareStatement(sql);
			if(params != null && params.length > 0)
			{
				for (int i = 0; i < params.length; i++)
				{
					pstmt.setString(i+1, params[i]);
				}
				
			}
			rs = pstmt.executeQuery();
			if (rs.next())
			{
				flag = true;
			}
		} 
		catch (SQLException e)
		{
			e.printStackTrace();
		}
		finally
		{
			this.close(rs);
			this.close(pstmt);
			this.close(conn);
		}
		return flag;
	}
}