Spring3 MVC +HibernateJPA Eclipse Demo

package com.web.test; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.List; import javax.persistence.EntityManager; import javax.persistence.EntityManagerFactory; import javax.persistence.Persistence; import org.junit.After; import org.junit.AfterClass; import org.junit.Before; import org.junit.BeforeClass; import org.junit.Test; import com.web.domain.dao.BaseDAO; import com.web.domain.entity.User; import com.web.domain.implement.BaseDAOImplement; import com.web.domain.service.BaseService; import com.web.domain.service.BaseServiceImplement; public class UserTest { protected static EntityManagerFactory emf; protected EntityManager em; private final String drivername = "sun.jdbc.odbc.JdbcOdbcDriver"; private final String url = "jdbc:odbc:conn"; private final String username = ""; private final String password = ""; private Connection conn = null; @BeforeClass public static void createEntityManagerFactory() { emf = Persistence.createEntityManagerFactory("JPAUNIT"); } @AfterClass public static void closeEntityManagerFactory() { emf.close(); } @Before public void beginTransaction() { em = emf.createEntityManager(); em.getTransaction().begin(); } @After public void rollbackTransaction() { if (em.getTransaction().isActive()) { em.getTransaction().rollback(); } if (em.isOpen()) { em.close(); } } public void accessTest()throws ClassNotFoundException, SQLException{ Class.forName(drivername); this.conn = DriverManager.getConnection(url, username, password); String sql = "select * from student where uid=?"; User user = new User(); PreparedStatement pstmt = null; try { pstmt = this.conn.prepareStatement(sql); pstmt.setInt(1, 1); ResultSet rs = pstmt.executeQuery(); if (rs.next()) { user.setuID(rs.getInt("uid")); user.setuserName(rs.getString("username")); } System.out.print(user.getuID()); System.out.print(user.getuserName()); pstmt.close(); } catch (Exception e) { System.out.print(e); } } @Test public void entityTest(){ User user = new User(); try { user= (User) em.find(User.class, 1); System.out.print(user.getuID()); System.out.print(user.getuserName()); } catch (Exception e) { e.printStackTrace(); } } }