最近在检查一方法时发现程序执行SQL查询时非常慢,但使用PLSQL DEV工具执行查询语句又很快。
看以下代码:
public boolean isExistSonoByStoreCode(String storeCode, String soNo, String billId)
{
StringBuffer sql = new StringBuffer();
sql.append("select bill_id, so_no from store_in_head where store_code = ? and UPPER(so_no) = UPPER(?) ");
DBUtil dbu = null;
PreparedStatement preStmt = null;
ResultSet rs = null;
boolean isExistSono = false;
try
{
dbu = new DBUtil();
preStmt = dbu.getConnection().prepareStatement(sql.toString());
preStmt.setString(1, storeCode);
preStmt.setString(2, soNo);
rs = preStmt.executeQuery();
while (rs.next())
{
String oldBillId = rs.getString("bill_id"
版权声明:本文为luweifeng1983原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。