1、把表名称动态的拼到你的 sql 中,如下:Dim strSQL As String = "select * from " + enqueryrecord.ProGetTable + " where ProCardNO=@cardno"

2、Dim params() As SqlParameter = {New SqlParameter("@cardno", enqueryrecord.ProCardNO)}

3、一个iBATIS的简单实现(含sql语句中表名等的动态传入)

时间:2026-02-18 01:18:33
1、把表名称动态的拼到你的 sql 中,如下:Dim strSQL As String = "select * from " + enqueryrecord.ProGetTable + " where ProCardNO=@cardno"

2、Dim params() As SqlParameter = {New SqlParameter("@cardno", enqueryrecord.ProCardNO)}

3、一个iBATIS的简单实现(含sql语句中表名等的动态传入)
