String sql = "select T_BOUQUET_ID,T_BOUQUET_NAME from TBBOUQUET where T_BOUQUET_ID = '"+strBouquetid+"' or T_BOUQUET_NAME = '"+strBouquetname+"'";
这个句子我想把 俩字段 加上模糊查询 应该怎么加%
谢谢
这个句子我想把 俩字段 加上模糊查询 应该怎么加%
谢谢
调试欢乐多
public ArrayList inqueryBouquet(String strBouquetid,String strBouquetname)
{
ArrayList noticeList = new ArrayList();
try{
conn = ConnectionDB.getConnection();
stmt = conn.createStatement();
String sql = "select T_BOUQUET_ID,T_BOUQUET_NAME from TBBOUQUET where T_BOUQUET_ID = '%"+strBouquetid+"%' or T_BOUQUET_NAME = '%"+strBouquetname+"%'";
System.out.println("this is =============>" + sql);
System.out.println("connect to db is successful~~~");
rs = stmt.executeQuery(sql);
while(rs.next()){
NoticeBouquet temp = new NoticeBouquet();
temp.setBouquetid(rs.getString("T_BOUQUET_ID"));
temp.setBouquetname(rs.getString("T_BOUQUET_NAME"));
noticeList.add(temp);
}
return noticeList; }
catch(SQLException e)
{
e.printStackTrace();
return null;
}
}
private function inqueryResultBouquet(result:Object):void
{
if(result.length==0)
{
Alert.show("This is a new ID or Name!","message");
}else{
M_List_Bouquet.dataProvider =null;
M_List_Bouquet.dataProvider = result;
nCount = M_List_Bouquet.dataProvider.length;
}
}