JSP和.net下传参数的模糊查询

JSP下利用PreparedStatement传参数模糊查询解决方案：

sql = "select * from some_table where username like ?"
statement.setString(1, "%"+value+"%");

.NET下利用Command.Parameters传参数模糊查询解决方案：

sql = "select * from some_table where username like '%'+@username+'%'";
cmd.Parameters.Add("@username",OleDbType.VarChar,20).Value=username.Value.ToString().Trim();