persondaoimpl.java

一个简单的留言网上留言系统

package cn.li.note.dao.impl;

import cn.li.note.vo.*;
import java.sql.*;
import cn.li.note.dbc.*;
import cn.li.note.dao.*;

public class PersonDAOImpl implements PersonDAO
{
	  public boolean login(Person person)throws Exception
	  {
	  	 boolean flag=false;
	  	 String sql="SELECT name FROM person WHERE id=? and password=?";
	  	 PreparedStatement pstmt=null;
	  	 DataBaseConnection dbc=null;
	  	 
	  	 dbc=new DataBaseConnection();
	  	 try
	  	 {
	  	 	
	  	 	 pstmt=dbc.getConnection().prepareStatement(sql);
	  	 	 pstmt.setString(1,person.getId());
	  	 	 pstmt.setString(2,person.getPassword());
	  	 	 ResultSet rs=pstmt.executeQuery();
	  	 	 if(rs.next())
	  	 	 {
	  	 	 	 flag=true;
	  	 	 	 System.out.println(rs.getString(1));
	  	 	 	 person.setName(rs.getString(1));
	  	 	 	}
	  	 	 	rs.close();
	  	 	 	pstmt.close();
	  	 	}
	  	 	
	  	 	catch(Exception e)
	  	 	{
	  	 		throw new Exception("操作出现错误");
	  	 		}
	  	 		finally
	  	 		{
	  	 			dbc.close();
	  	 			}
	  	 	
	  	 	return flag;
	  	}
	};