读书人

C#兑现oracle数据的查询和删除

发布时间: 2012-09-24 13:49:41 作者: rapoo

C#实现oracle数据的查询和删除

C# code
public static void doInsertData()        {                      string conStr = "provider='OraOleDb.Oracle';Data Source=" +            "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)))" +            "(CONNECT_DATA =(SERVICE_NAME = test)));User Id=test;Password=test;";            string sqlInsertStr = "insert into SYM_SOFTWARE_COLLECTION" +             "(USERNAME,IP,MAC,YONGYOUSTATUS,YONGYOUEDITION,JINDIESTATUS,JINDIEEDITION,GUANJIAPOSTATUS,GUANJIAPOEDITION,RECORDTIME)" +                "values('" + username + "','" + ip + "','" + mac + "','" + yySta + "','" + yyEdition + "','" + jdSta + "','"                    + jdEdition + "','" + gjpSta + "','" + gjpEdition + "', sysdate )";            String sqlQueryStr = "select * from SYM_SOFTWARE_COLLECTION  where USERNAME='test3';";            String sqlDeleteStr = "delete from SYM_SOFTWARE_COLLECTION  where USERNAME='test2';";            OleDbConnection sqlCon = new OleDbConnection(conStr);            try            {                sqlCon.Open();                //执行插入没问题,执行查询和删除时都有报错了                //OleDbCommand cmd = new OleDbCommand(sqlInsertStr, sqlCon);                //OleDbCommand cmd = new OleDbCommand(sqlDeleteStr, sqlCon);                OleDbCommand cmd = new OleDbCommand(sqlQueryStr, sqlCon);                                cmd.ExecuteNonQuery();            }            catch (Exception ex)            {                Console.WriteLine(ex.Message);            }            finally            {                sqlCon.Close();            }        }


执行查询和删除时都报错了:ORA-00911: invalid character
刚接触oracle
有点急,求有经验的高手帮忙解答一下,谢谢。。。。

[解决办法]
String sqlQueryStr = "select * from SYM_SOFTWARE_COLLECTION where USERNAME='test3';";
String sqlDeleteStr = "delete from SYM_SOFTWARE_COLLECTION where USERNAME='test2';";
双引号里面还有分号。。

读书人网 >C#

热点推荐