|
paredStatement stmt = conn.prepareStatement(sql);
stmt.setString(1, name);
ResultSet rs = stmt.executeQuery();
if(rs.next()){
return false;
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
utils.closeConnection(conn);
}
return true;
}
}
8、测试：
package cn.com.dale.test;
import org.junit.Test;
import cn.com.dale.Bean.User;
import cn.com.dale.Dao.UserDao;
import cn.com.dale.DaoImpl.UserDaoImpl;
public class test01 {
@Test
public void test(){
//Utils utils = new Utils();
//System.out.println(utils.openConnection());
User user = new User();
user.setName("小非");
user.setPassword("123");
UserDao userDao = new UserDaoImpl();
userDao.register(user);
User user1 = userDao.login(user);
System.out.println(user1.getName()+":"+user1.getPassword());
}
}
?
|