oracle 反向模糊查询,sql 模糊查询方法 sql语句里like是否有反向用法?

public Fwxx getFwxxByFwid(int fwid){ private Connection connection = null;

private PreparedStatement pStatement = null;

private ResultSet rSet = null;

Fwxx fwxx = new Fwxx();

connection = DBConnection.getConnection();

String sql = "select * from scott.TBL_FWXX ,scott.tbl_fwlx,scott.tbl_qx,scott.tbl_jd where TBL_FWXX.lxid=tbl_fwlx.lxid and TBL_FWXX.jdid=tbl_jd.jdid and tbl_jd.qxid=tbl_qx.qxid and fwid = ?";

try {

pStatement = connection.prepareStatement(sql);

pStatement.setInt(1, fwid);

rSet = pStatement.executeQuery();

if(rSet.next()){

fwxx.setFwid(rSet.getInt("fwid"));

fwxx.setUsid(rSet.getInt("usid"));

fwxx.setJdid(rSet.getInt("jdid"));

fwxx.setLxid(rSet.getInt("lxid"));

fwxx.setShi(rSet.getInt("shi"));

fwxx.setTing(rSet.getInt("ting"));

fwxx.setFwxx(rSet.getString("fwxx"));

fwxx.setZj(rSet.getDouble("zj"));

fwxx.setTitle(rSet.getString("title"));

fwxx.setFwdate(rSet.getDate("fwdate"));

fwxx.setTelephone(rSet.getString("telephone"));

fwxx.setLxr(rSet.getString("lxr"));

fwxx.getFwlx().setFwlx(rSet.getString("fwlx"));

fwxx.getQx().setQx(rSet.getString("qx"));

fwxx.getJd().setJd(rSet.getString("jd"));

}

} catch (SQLException e) {

e.printStackTrace();

}finally{

DBConnection.closeAll(rSet, pStatement, connection);

}

return fwxx;

} ResultSet 用来接收查询的结果

取消

评论