关于返回 RusultSet问题
返回ResultSet 的话 跟数据库连接不能关闭
public ResultSet executeQuery(String UserName) throws Exception//接收SQL查询语句
{
Connection conn=null;
ResultSet rs=null;
Statement stmt = null;
try
{
conn= DriverManager.getConnection(url, "sa ", " ");
stmt=conn.createStatement();
if(UserName!=null&&!UserName.equals( " "))
{
rs= stmt.executeQuery( "select* from [User] where UserName= ' "+UserName+ " ' ");
}
else
{
rs= stmt.executeQuery( "select* from [User] ");
}
}
catch(SQLException ex)
{
System.out.println( "更新数据操作失败！ "+ex.getMessage());
}
return rs;
}
我是这么写的要怎么改 返回什么数据库才能关闭
[解决办法]
返回List吧。你这样返回是不可以关闭的、
