我在做插入语句是遇到了问题,代码如下:
/// <summary>
/// 添加一条记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
private static readonly string SQL_GET_SYSADMINNUM = "SELECT seqsysadmin.nextval FROM sysadmin";
private static readonly string SQL_ADMIN_INSERT_INTO = "INSERT INTO sysadmin(adminid,adminname,adminpwd,issuper) values(':adminid',':adminname',':adminpwd',':issuper')";
public void Add(BusManage.Model.SysAdmin model)
{
int id = 0;
id = Convert.ToInt32(OracleHelper.ExecuteScalar(OracleHelper.ConnectionString, CommandType.Text, SQL_GET_SYSADMINNUM));
model.ADMINID = id;
OracleParameter[] parm=new OracleParameter[]
{
new OracleParameter(":adminname",model.ADMINNAME),
new OracleParameter(":adminpwd",model.ADMINPWD),
new OracleParameter(":issuper",model.ISSUPER)
};
//OracleParameter[] parm =
//{
// new OracleParameter("adminid",OracleType.Number),
// new OracleParameter("adminname",OracleType.VarChar),
// new OracleParameter("adminpwd",OracleType.VarChar),
// new OracleParameter("issuper",OracleType.Char)
//};
//parm[0].Value = 3;
//parm[1].Value = "aaa";
//parm[2].Value = "bbb";
//parm[3].Value = '1';
OracleHelper.ExecuteNonQuery(OracleHelper.ConnectionString, CommandType.Text, SQL_ADMIN_INSERT_INTO, parm);
}
底层用的是微软的PETSHOP4.0的OracleHelper.cs类,用的VS2005+ORACLE 9i
报一个ORA-01036错
SQL语句经过了测试 没有问题 估计是参数的问题 也就是出在parm身上
请帮忙解决下,分不够还可以加分
/// <summary>
/// 添加一条记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
private static readonly string SQL_GET_SYSADMINNUM = "SELECT seqsysadmin.nextval FROM sysadmin";
private static readonly string SQL_ADMIN_INSERT_INTO = "INSERT INTO sysadmin(adminid,adminname,adminpwd,issuper) values(':adminid',':adminname',':adminpwd',':issuper')";
public void Add(BusManage.Model.SysAdmin model)
{
int id = 0;
id = Convert.ToInt32(OracleHelper.ExecuteScalar(OracleHelper.ConnectionString, CommandType.Text, SQL_GET_SYSADMINNUM));
model.ADMINID = id;
OracleParameter[] parm=new OracleParameter[]
{
new OracleParameter(":adminname",model.ADMINNAME),
new OracleParameter(":adminpwd",model.ADMINPWD),
new OracleParameter(":issuper",model.ISSUPER)
};
//OracleParameter[] parm =
//{
// new OracleParameter("adminid",OracleType.Number),
// new OracleParameter("adminname",OracleType.VarChar),
// new OracleParameter("adminpwd",OracleType.VarChar),
// new OracleParameter("issuper",OracleType.Char)
//};
//parm[0].Value = 3;
//parm[1].Value = "aaa";
//parm[2].Value = "bbb";
//parm[3].Value = '1';
OracleHelper.ExecuteNonQuery(OracleHelper.ConnectionString, CommandType.Text, SQL_ADMIN_INSERT_INTO, parm);
}
底层用的是微软的PETSHOP4.0的OracleHelper.cs类,用的VS2005+ORACLE 9i
报一个ORA-01036错
SQL语句经过了测试 没有问题 估计是参数的问题 也就是出在parm身上
请帮忙解决下,分不够还可以加分
new OracleParameter(":adminname",model.ADMINNAME),
new OracleParameter(":adminpwd",model.ADMINPWD),
new OracleParameter(":issuper",model.ISSUPER)
把":"去掉