怎样直连jdbc?hibernate+spring
提示
java.lang.UnsupportedOperationException: The user must supply a JDBC connection
org.hibernate.connection.UserSuppliedConnectionProvider.closeConnection(UserSuppliedConnectionProvider.java:37)
com.action.TestAction.execute(TestAction.java:55)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
public String execute() throws Exception {
ConnectionProvider cp = ConnectionProviderFactory.newConnectionProvider();
Connection conn = null;
Statement st = null;
ResultSet rs = null;
String sql="select * from xt";
try {
conn = cp.getConnection();
st = conn.createStatement();
rs = st.executeQuery(sql);
if(rs.next()){
System.out.println((String)rs.getString("name"));
}
} catch (SQLException e) {
e.printStackTrace();
}
finally{
try {
cp.closeConnection(conn);
} catch (SQLException e) {
e.printStackTrace();
}
}
return SUCCESS;
}