从上一画面中传来参数strMM,现已取得strMM的值,检索语句如下
SELECT *
FROM A
WHERE 1=1
AND A.xx = 'strMM'
想请教一下如何将strMM的值设置给AND A.xx = 'strMM'中的变量
SELECT *
FROM A
WHERE 1=1
AND A.xx = 'strMM'
想请教一下如何将strMM的值设置给AND A.xx = 'strMM'中的变量
调试欢乐多
FROM A
WHERE 1=1
AND A.xx='||strMM||'是jdbc : "SELECT *
FROM A
WHERE 1=1
AND A.xx='"+strMM+"'"
{
public DataTable getReleaseDate(String strProjectName, String strFileName)
{
int a = strFileName.Length;
DataTable ds = new DataTable();
OracleUtil oracleUtil = new OracleUtil();
StringBuilder strSql = new StringBuilder();
strSql.Append(" SELECT ");
strSql.Append(" VERSION , ");
strSql.Append(" PROJECT_NM , ");
strSql.Append(" FILE_NM , ");
strSql.Append(" UPD_YMDHMSF , ");
strSql.Append(" UPD_USER_ID , ");
strSql.Append(" REMARKS ");
strSql.Append(" FROM TR_ASSET_MANAGEMENT ");
strSql.Append(" WHERE 1=1 ");
//if (strProjectName != null && strProjectName != "")
//{
strSql.Append(" AND PROJECT_NM = 'strProjectName' ");
//}
//if (strFileName != null && strFileName != "")
//{
strSql.Append(" AND FILE_NM = 'strFileName' ");
//} ds = oracleUtil.GetDataTable(strSql.ToString());
oracleUtil.Close();
return ds;
}
}我全贴出来,大家给看看,上面的两个参数是从别的画面传过来的,我调试看过,值已经传过来了,但就是不知道怎么传到sql文里面了,有劳各位了
{
public DataTable getReleaseDate(String strProjectName, String strFileName)
{
int a = strFileName.Length;
DataTable ds = new DataTable();
OracleUtil oracleUtil = new OracleUtil();
StringBuilder strSql = new StringBuilder();
strSql.Append(" SELECT ");
strSql.Append(" VERSION , ");
strSql.Append(" PROJECT_NM , ");
strSql.Append(" FILE_NM , ");
strSql.Append(" UPD_YMDHMSF , ");
strSql.Append(" UPD_USER_ID , ");
strSql.Append(" REMARKS ");
strSql.Append(" FROM TR_ASSET_MANAGEMENT ");
strSql.Append(" WHERE 1=1 ");
//if (strProjectName != null && strProjectName != "")
//{
strSql.Append(" AND PROJECT_NM = '" && strProjectName && "' ");
//}
//if (strFileName != null && strFileName != "")
//{
strSql.Append(" AND FILE_NM = '" && strFileName &&"' ");
//} ds = oracleUtil.GetDataTable(strSql.ToString());
oracleUtil.Close();
return ds;
}
}
strSql.Append(" AND PROJECT_NM = '“ +strProjectName+ ”'