1.恐怕不能,2.不用写7次,三次就够了 Dim sql As String Dim A As String Dim B As String Dim C As Stringsql = "SELECT X,Y,Z FROM T1 WHERE 1 = 1"If Len(A) > 0 Then sql &= " AND X = " + A; End IfIf Len(B) > 0 Then sql &= " AND Y = " + B; End IfIf Len(C) > 0 Then sql &= " AND Z = " + C; End If
我用的VB.NET
Dim sql As String
Dim A As String
Dim B As String
Dim C As Stringsql = "SELECT X,Y,Z FROM T1 WHERE 1 = 1"If Len(A) > 0 Then
sql &= " AND X = " + A;
End IfIf Len(B) > 0 Then
sql &= " AND Y = " + B;
End IfIf Len(C) > 0 Then
sql &= " AND Z = " + C;
End If
不管怎样先谢谢楼上的各位了~
我再去研究一下