I assume from your other post that you are trying to this in WSAD.
Yes, you can write finder methods for CMP beans. You can search by a where clause, EJB-QL or a full SQL query. For CMP beans you write the finder clause and the container manages the database calls. You can also write a finder that does a findAll if you want all the rows in a table. For details on how to create a finder in WSAD, try looking at an IBM
redbook.
You can add create methods as well. You add an ejbCreate method and an ejbPostCreate method with the same signature. In the ejbCreate method, you set the fields of the CMP.