お試し

時間がないので、とりあえずメモ

import net.java.ao.*;
import net.java.ao.db.*;
import java.util.logging.*;

public class Test {
	public static void main( String args ) throws Exception {
            Class.forName("com.mysql.jdbc.Driver");
            EntityManager manager = new EntityManager(
                    new MySQLDatabaseProvider(
                    "jdbc:mysql://localhost:3306/ao",
                    "root", "root"));
			Logger.getLogger("net.java.ao").setLevel(Level.FINE);

		
			User userList = manager.find( User.class );	// @@@SQL発行@@@ SELECT name,user_id FROM user
			for ( User user : userList ) {
				System.out.println( user.getUser_id() );
				System.out.println( user.getName() );
				System.out.println( user.getUser_mail() );	// @@@SQL発行@@@ SELECT user_mail FROM user WHERE user_id = ?
			}
	}
}

import net.java.ao.*;
import net.java.ao.schema.*;

@Preload("name")	// @@@ find()時にnameを選択するように指定
public interface User extends RawEntity {
	@AutoIncrement
	@NotNull
	@PrimaryKey("user_id")
	public String getUser_id();
	public String getName();
	public String getUser_mail();
}

mysql> describe user;

Field	Type	Null	Key	Default	Extra
user_id	char(10)	NO	PRI
name	varchar(50)	YES		NULL
user_mail	varchar(200)	YES		NULL