用Hibernate吧,MySQL的配置hibernate.cfg.xml如下:<hibernate-configuration>
    <session-factory>
    <!---->
<property name="dialect">net.sf.hibernate.dialect.MySQLDialect</property>
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="connection.username">root</property>
<property name="connection.password">password</property>
<property name="connection.url">jdbc:mysql://localhost/testdb?autoReconnect=true&amp;useUnicode=true&amp;characterEncoding=GB2312</property>
<property name="connection.pool.size">1</property>
<property name="statement_cache.size">25</property>
<property name="jdbc.fetch_size">50</property>
<property name="jdbc.batch_size">30</property>
<!---->
        <property name="show_sql">true</property>
        <property name="dialect">net.sf.hibernate.dialect.MySQLDialect</property>
        <mapping resource="user.hbm.xml"/>
    </session-factory>
</hibernate-configuration>