int number=System.Int32.Parse(check_value);
sqlstr="select num as 编号,type as 产品型号,name as 产品名称,fault_phenomena as 故障现象,fault_remove as 故障排除 from knowledge where num=?";num是自动编号。
请问如何写查询num等于number的记录。
sqlstr="select num as 编号,type as 产品型号,name as 产品名称,fault_phenomena as 故障现象,fault_remove as 故障排除 from knowledge where num=?";num是自动编号。
请问如何写查询num等于number的记录。
sqlstr="select num as 编号,type as 产品型号,name as 产品名称,fault_phenomena as 故障现象,fault_remove as 故障排除 from knowledge where num=" + number;这样就应该可以啊,我不太懂你的意思啊?
sqlstr="select num as 编号,type as 产品型号,name as 产品名称,fault_phenomena as 故障现象,fault_remove as 故障排除 from knowledge where num="+number+"";
也可以写成存储过程的
sqlstr="select num as 编号,type as 产品型号,name as 产品名称,fault_phenomena as 故障现象,fault_remove as 故障排除 from knowledge where num=" + number;
如果是int类型则用
sqlstr="select num as 编号,type as 产品型号,name as 产品名称,fault_phenomena as 故障现象,fault_remove as 故障排除 from knowledge where num=" + number;
如果为字符类型则用
sqlstr="select num as 编号,type as 产品型号,name as 产品名称,fault_phenomena as 故障现象,fault_remove as 故障排除 from knowledge where num='" + number+"'";
因为有 where num=1 和 where num='1' 的区别。