@Override
public int countTheTotalRows(String portCode,String portName,String portNameLocalized,String countryCode) throws SQLException{
int totalRows=0;
String sql="select * from BPS_PORT BPS WHERE PORT_CODE LIKE Upper('%"+
portCode +"%') AND PORT_NAME LIKE Upper('%"+portName+"%') AND PORT_NAME_LOCALIZED LIKE Upper('%"+
portNameLocalized+"%') AND COUNTRY_CODE LIKE Upper( '%"+countryCode+"%')";
Connection coreconn = new NGenConn().getConnection();
Statement state = coreconn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
ResultSet rs = state.executeQuery(sql);
rs.last();
totalRows=rs.getRow();
return totalRows;
}
这个是直接用*查询最大值
用count(*)的以后补上