所有的finally块均出现:finally block does not complete normallywhy?期待大虾指教!^_^
//本JavaBean包括数据的插入、更新、删除和查询等。package lee.javaBean;import java.sql.*;public class DBUtil
{
private DBLink dblink=new DBLink();
private Statement stmt;
private ResultSet rs;
//获取查询的行数:没有结果返回-1,查询异常返回-2;
public int getRowCount(String strSql)
{
int intCount=0;
try{
stmt=dblink.getStmtread();
rs=stmt.executeQuery("SELECT COUNT(*) FROM"+strSql);
if(rs.next())
{
intCount=rs.getInt(1);
}
else intCount=-1;
}
catch(Exception e)
{
intCount=-2;
}
finally
{
dblink.close();
return intCount;
}
}
//执行插入操作
public int insert(String strSql)
{
int count=0;
stmt=dblink.getStmt();
try
{
count=stmt.executeUpdate(strSql);
}
catch(Exception e)
{
count=-2;
System.err.println(e.getMessage());
e.printStackTrace();
}
finally
{
dblink.close();
return count;
}
}
//更新数据库数据
public int update(String sql)
{
int count=0;
stmt=dblink.getStmt();
try
{
count=stmt.executeUpdate(sql);
}
catch(Exception e)
{
count=-2;
System.err.print(e.getMessage());
e.printStackTrace();
}
finally
{
dblink.close();
return count;
}
}
//删除数据库数据
public int delete(String sql)
{
int count=0;
stmt=dblink.getStmt();
try
{
count=stmt.executeUpdate(sql);
}
catch(Exception e)
{
count=-2;
System.err.println(e.getMessage());
e.printStackTrace();
}
finally
{
dblink.close();
return count;
}
}
}
//本JavaBean包括数据的插入、更新、删除和查询等。package lee.javaBean;import java.sql.*;public class DBUtil
{
private DBLink dblink=new DBLink();
private Statement stmt;
private ResultSet rs;
//获取查询的行数:没有结果返回-1,查询异常返回-2;
public int getRowCount(String strSql)
{
int intCount=0;
try{
stmt=dblink.getStmtread();
rs=stmt.executeQuery("SELECT COUNT(*) FROM"+strSql);
if(rs.next())
{
intCount=rs.getInt(1);
}
else intCount=-1;
}
catch(Exception e)
{
intCount=-2;
}
finally
{
dblink.close();
return intCount;
}
}
//执行插入操作
public int insert(String strSql)
{
int count=0;
stmt=dblink.getStmt();
try
{
count=stmt.executeUpdate(strSql);
}
catch(Exception e)
{
count=-2;
System.err.println(e.getMessage());
e.printStackTrace();
}
finally
{
dblink.close();
return count;
}
}
//更新数据库数据
public int update(String sql)
{
int count=0;
stmt=dblink.getStmt();
try
{
count=stmt.executeUpdate(sql);
}
catch(Exception e)
{
count=-2;
System.err.print(e.getMessage());
e.printStackTrace();
}
finally
{
dblink.close();
return count;
}
}
//删除数据库数据
public int delete(String sql)
{
int count=0;
stmt=dblink.getStmt();
try
{
count=stmt.executeUpdate(sql);
}
catch(Exception e)
{
count=-2;
System.err.println(e.getMessage());
e.printStackTrace();
}
finally
{
dblink.close();
return count;
}
}
}
try-catch语句块就会失去控制