一个关于aop的异常

0 0

一个关于aop的异常5

这是我的连接数据库的类：
@Component
@Scope("prototype")
public class DaoConfig {
private static String url = "jdbc:sqlserver://localhost:1433;DatabaseName=BBS2.0";
private static String user = "sa";
private static String password = "sasa";
private static String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
public static Connection conn ;
public static Statement sm ;
public static ResultSet rs;

static {
try {
Class.forName(driver);
conn = getConnnection();
sm = conn.createStatement();
}
catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
    catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
    e.printStackTrace();
    }
}

public static Connection getConnnection() {
try {
return DriverManager.getConnection(url, user, password);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}
}
}

我的dao类继承这个类，并且用的都是sql语句，下面是其中一个方法：
public Post getPost(int postId) {
String sql = "select * from post where postId = "+postId+"";
try {
rs = sm.executeQuery(sql);
rs.next();
Post post = new Post();
post.setPostId(postId);
post.setPosttitle(rs.getString(2));
post.setPostContent(rs.getString(3));
post.setParentId(rs.getInt(4));
post.setPostDate(rs.getTimestamp(5));
return post;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
throw new RuntimeException();
}
}

我想用aop将每个dao类最后加上close语句
@After("daoClose()")
public void after() {
System.out.println("000000000000000000000");
try {
if(daoConfig.rs != null) {
daoConfig.rs.close();
}
if(daoConfig.sm != null) {
daoConfig.sm.close();
}
if(daoConfig.conn != null) {

daoConfig.conn.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}

结果确报异常：
com.microsoft.sqlserver.jdbc.SQLServerException: 该语句已关闭。