SQL多条件查询语句应怎么写

来源:百度知道 编辑:UC知道 时间:2024/06/14 17:46:54
public bool OperationSelect()//根据常量来分解消息包
{
switch (flgstr)//result用来返回操作是否成功
{
case "Logo": MsgDetail(); result = Log(); //对数据库的
break;
case "Find": MsgDetail(); result = Find();
break;
case "User": MsgDetail(); result = User();//对聊天对象的操作
break;
default: result = false;
break;
}
return result;
}
/// <summary>
///
/// </summary>
private void MsgDetail()
{
for (int i = 0,num=0; i < total; num++)//解包,提取各字段长度及消息
{
Buffer.BlockCopy(buffer, i, lenghtbuffer, 0, 4);
int count = BitConverter.ToInt32(lenghtbuffer, 0);

"ID likle '" + Flag[0] + "%' and " +
..."%' and....
最后多了一个 and
最简单的方法是把后面3个字截了

告诉你个好办法,
在where后面加 1=1
然后呢, 把 And 加到前面, 试试这个
============================================================

str = "select * from UserInformation where 1 = 1 " +
" And ID like '" + Flag[0] + "' "
" And Name like '" + Flag[1] + "' " +
" And Age like '" + Flag[2] + "' " +
" And Sex like '" + Flag[3] + "' " +
" And Cale like '" + Flag[4] + "' " +
" And Enducation like '" + Flag[5] + "' " +
" And Salary like '" + Flag[6] + "' " +
" And Contact like '" + Flag[7] + "' " +
" And Address like '" + Flag[8] + "' ";
<