111,119
社区成员
发帖
与我相关
我的任务
分享 string sqlstr = "insert into symptom(ID,symptomCode,symptomName) values (HIBERNATE_SEQUENCE.nextval,:symptomCode,:symptomName); ";
string oraclestr = "User ID=CDR;Password=CDR;Data Source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST=127.0.0.1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))";
conn = new OracleConnection(oraclestr);
conn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = sqlstr;
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("symptomCode", OracleType.VarChar, 255).Value = "112";
cmd.Parameters.Add("symptomName", OracleType.VarChar, 255).Value = "cc";
cmd.ExecuteNonQuery();