private const string PARA_ID = "@ID";
private const string PARA_LOGINNAME = "@LOGINNAME";
private const string PARA_PASSWORD = "@PASSWORD";
private const string PARA_TRUENAME = "@TRUENAME";
private const string PARA_SEX = "@SEX";
private const string PARA_BIRTHDAY = "@BIRTHDAY";
private const string PARA_TEL = "@TEL";
private const string PARA_QQ = "@QQ";
private const string PARA_EMAIL = "@EMAIL";
private const string PARA_CREATETIME = "@CREATETIME";
private const string PARA_LASTLOGINTIME = "@LASTLOGINTIME";
private const string PARA_ENABLE = "@ENABLE";
private const string PARA_QUANXIAN = "@QUANXIAN";
private const string PARA_CONTENTQUANXIAN = "@CONTENTQUANXIAN";
private const string PARA_SUPERADMIN = "@SUPERADMIN"; private const string SQL_INSERT = "INSERT INTO ADMIN(LOGINNAME, PASSWORD, TRUENAME, SEX, BIRTHDAY, TEL, QQ, EMAIL, CREATETIME, LASTLOGINTIME, ENABLE, QUANXIAN, CONTENTQUANXIAN, SUPERADMIN ) values ( @LOGINNAME, @PASSWORD, @TRUENAME, @SEX, @BIRTHDAY, @TEL, @QQ, @EMAIL, @CREATETIME, @LASTLOGINTIME, @ENABLE, @QUANXIAN, @CONTENTQUANXIAN, @SUPERADMIN )";
/// <summary>
/// 向数据库中插入一条新记录。
/// </summary>
/// <param name="info">实体类</param>
/// <returns>新插入记录的编号</returns>
public int InsertAdmin(AdminInfo info)
{
// 声明参数数组并赋值
OleDbParameter[] _param =
{
new OleDbParameter(PARA_LOGINNAME, SqlDbType.VarChar),
new OleDbParameter(PARA_PASSWORD, SqlDbType.VarChar),
new OleDbParameter(PARA_TRUENAME, SqlDbType.VarChar),
new OleDbParameter(PARA_SEX, SqlDbType.Int),
new OleDbParameter(PARA_BIRTHDAY, SqlDbType.DateTime),
new OleDbParameter(PARA_TEL, SqlDbType.VarChar),
new OleDbParameter(PARA_QQ, SqlDbType.VarChar),
new OleDbParameter(PARA_EMAIL, SqlDbType.VarChar),
new OleDbParameter(PARA_CREATETIME, SqlDbType.DateTime),
new OleDbParameter(PARA_LASTLOGINTIME, SqlDbType.DateTime),
new OleDbParameter(PARA_ENABLE, SqlDbType.Int),
new OleDbParameter(PARA_QUANXIAN, SqlDbType.VarChar),
new OleDbParameter(PARA_CONTENTQUANXIAN, SqlDbType.VarChar),
new OleDbParameter(PARA_SUPERADMIN, SqlDbType.Int)
}; _param[0].Value = info.LoginName;
_param[1].Value = info.PassWord;
_param[2].Value = info.TrueName;
_param[3].Value = info.Sex;
_param[4].Value = info.Birthday;
_param[5].Value = info.Tel;
_param[6].Value = info.QQ;
_param[7].Value = info.Email;
_param[8].Value = info.CreateTime;
_param[9].Value = info.LastLoginTime;
_param[10].Value = info.Enable;
_param[11].Value = info.QuanXian;
_param[12].Value = info.ContentQuanXian;
_param[13].Value = info.SuperAdmin; // 返回
try
{
return Int32.Parse(OleDbHelper.ExecuteScalar(OleDbHelper.ConnectionString, CommandType.Text, SQL_INSERT, _param).ToString());
}
catch
{
return 0;
} }
插入到access会报错,提示语法错误,请问是什么原因?
LZ 结贴率 不高.