Question

asp.net 向oracle中添加数据

public static Boolean AddUserInfo(CustomerInfoBean custmBean)
{
//将对象custmBean中的值取出
string username = custmBean.Username;
string password = custmBean.Password;
string custmName = custmBean.CustmName;
string custmSex = custmBean.CustmSex;
Int32 custmAge = custmBean.CustmAge;
string custmEmail = custmBean.CustmEmail;
Int64 custmTel = custmBean.CustmTel;
string custmAddr = custmBean.CustmAddr;
Int32 postalCode = custmBean.PostalCode;

OracleConnection con = DBConn.CreateOrclConn();
try
{
con.Open();
string addSql = "insert into TBCUSTOMERINFO values ('" + username + "','" + password + "','" + custmName + "','" + custmSex + "'," + custmAge + ","
+ " '" + custmEmail + "'," + custmTel + ",'" + custmAddr + "'," + postalCode + ")";
OracleCommand ocmd = new OracleCommand(addSql, con);
ocmd.ExecuteNonQuery();
return true;
}
catch (OracleException oex)
{
HttpContext.Current.Response.Write("<script>alert('" + oex.Message + "')</script>");
return false;
}
finally
{
if (con != null)
{
con.Close();
}
}
}
为什么到了ocmd.ExecuteNonQuery();这一步时就不执行了呢……求高手指点

Answer 1

sql语句有小问题
insert into TBCUSTOMERINFO values ('" + username + "','" + password + "','" + custmName + "','" + custmSex + "'," + custmAge + "," + " '" + custmEmail + "'," + custmTel + ",'" + custmAddr + "'," + postalCode + ")";
在custmAge后面多了"+"

Answer 2

可能是数据库访问或插入语句有问题，建议取得输出的SQL语句后，拷贝到ORACLE数据库工具（如PL/SQL）中去分析下语句有问题没。

Answer 3

SQL语句有问题吧,可能某一个字段类型不一致导致的.