在一个jsp页面中
ResultSet user = ConnDBSQLite.executeQuery("SELECT user_id,name,tel,email,position from user where department_id=1 ");
现在我想把department_id=后面改成个参数
String nn=request.getParameter("id") ;
int id = Integer.parseInt(nn);
就是这个从其他页面里获得参数
where department_id = 后面加上面获得那个参数id
格式该怎么写?
ResultSet user = ConnDBSQLite.executeQuery("SELECT user_id,name,tel,email,position from user where department_id=1 ");
现在我想把department_id=后面改成个参数
String nn=request.getParameter("id") ;
int id = Integer.parseInt(nn);
就是这个从其他页面里获得参数
where department_id = 后面加上面获得那个参数id
格式该怎么写?
declare @id int,@sql varchar(8000)
set @id=1
set @sql='SELECT user_id,name,tel,email,position from [user] where department_id='+ltrim(@id)
exec (@sql)