personimpl.java.bak

来自「这是一个简单的用B/S写的留言板小程序,用jsp和javaBean实现的」· BAK 代码 · 共 39 行

 package login1;
 import login1.personDAO;
 import login1.person;
 import java.sql.*;
 import java.io.*;
 import login1.dbcon;
 public class personimpl implements personDAO
 {
 	 public boolean login(person person)
 	 {
 	 	 boolean flag = false ;
		 String sql = "select name from note1 where id=? and password=?" ;
		 PreparedStatement pstmt = null ;
		 dbcon dbc = null ;
		 dbc = new dbcon() ;
		try
		{
			pstmt = dbc.getcon().prepareStatement(sql) ;
			pstmt.setString(1,person.getid()) ;
			pstmt.setString(2,person.getpassword()) ;
			ResultSet rest = pstmt.executeQuery() ;
		 if(rest.next())
		 {
		 	  flag=true;
		 	  person.setname(rest.getString(1));		 	  
		 }
		 rest.close();
		 pstmt.close();
		}catch(Exception e)
		{
			 
		}
		finally
		{
			dbc.close();
		}
		return flag;
 	 }
 }