Question

在整合框架里，想用接口实现类实现模糊查询！

我想接口实现类里实现一个模糊查询。我知道应该用like来实现，但是我不知道具体该怎么写，那位大虾能教我写写。
我想实现的是memberInfo表里的memberID,loginID两个字段查询的。就是根据会员ID或者登陆账号，来查询会员记录，该怎样写呢？？

Answer 1

我这有个分页模糊查询的例子，给你看看
按‘spmch’（商品名称）模糊查询并分页,PageBean类是一个分页的javabean:
你重点需要看的就是：" FROM spkfk where spmch like '%"this.spmch"%' Order by spid)a order by spid desc) b order by spid"
这一段！

public List<GoodsBean> getInfo(PageBean page, String spmch)
throws ClassNotFoundException, SQLException {
int onepagesize;
int max;
Connection conn = null;
PreparedStatement ps = null;
String url = "jdbc:sqlserver://localhost:1433;databaseName=st_ccerp";
String username = "sa";
String password = "";
String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; List<GoodsBean> list = new ArrayList<GoodsBean>();
onepagesize = page.getONEPAGESIZE();
int offset = page.getOffset();
max = offset + onepagesize;
ResultSet rs = null;

try {
Class.forName(driver);
conn = DriverManager.getConnection(url, username, password);
String sql = " spid,spmch,shpchd,shpgg,shiyzh,chuffl,leibie ";
String sql2 = null;
this.spmch = spmch;
if (spmch != null && spmch.length() != 0)
sql2 = (new StringBuilder("SELECT "))
.append(sql)
.append(" FROM ( SELECT Top ")
.append(onepagesize)
.append(sql)
.append(" FROM (SELECT Top ")
.append(max)
.append(sql)
.append(" FROM spkfk where spmch like '%")
.append(this.spmch)
.append(
"%' Order by spid)a order by spid desc) b order by spid")
.toString();
else
sql2 = (new StringBuilder("SELECT "))
.append(sql)
.append(" FROM ( SELECT Top ")
.append(onepagesize)
.append(sql)
.append(" FROM (SELECT Top ")
.append(max)
.append(sql)
.append(" FROM spkfk ")
.append(
" Order by spid)a order by spid desc) b order by spid")
.toString();
ps = conn.prepareStatement(sql2);
rs = ps.executeQuery();
while (rs.next()) {
list.add(new GoodsBean(rs.getString(1), rs.getString(2), rs
.getString(3), rs.getString(4), rs.getString(5), rs
.getString(6), rs.getString(7)));

}
} finally {
if (ps != null)
ps.close();
if (conn != null)
conn.close();
}
return list;
}

Answer 2

就以Struts+Hibernate+Spring整合来说吧！
第一步你得获得页面输入的memberID,loginID两个字段，这很简单，renquest就OK了，获得以后你可以把这俩字段放到Hibernate实体类中（最好是自己建个查询的DTO）传到Service中，在Service中在把这俩取出来，拼个SQl就行了
例如：select * from table where memberID like ‘%memberID%’

Answer 3

select * from memberInfo where memberID like '%你的输入值%' or loginID like '%你的输入值%'
还应该做一些必要的转码工作 如果只是单纯的用上面的SQL 会有出现很大的问题 例如 在页面上指输入一个 ‘ 号 那么程序就会出现异常。

Answer 4

select * from memberInfo where memberID like '%你的输入值%' or loginID like '%你的输入值%'