string username= this.username_text.Text;
string connectionstring = "Data Source=jma;User ID=test1;Password=123;Unicode=True";
OracleConnection conn = new OracleConnection(connectionstring);
try
{
conn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "select id from Z_USER where username='''username'''";
OracleDataReader ord = cmd.ExecuteReader();
while (ord.Read())
{
MessageBox.Show("查询到数据");
}
}
catch (Exception)
{
MessageBox.Show("error");
throw;
}这个CommandText要怎么写啊?
string connectionstring = "Data Source=jma;User ID=test1;Password=123;Unicode=True";
OracleConnection conn = new OracleConnection(connectionstring);
try
{
conn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "select id from Z_USER where username='''username'''";
OracleDataReader ord = cmd.ExecuteReader();
while (ord.Read())
{
MessageBox.Show("查询到数据");
}
}
catch (Exception)
{
MessageBox.Show("error");
throw;
}这个CommandText要怎么写啊?
cmd. CommandText +=username;
cmd. CommandText +="'";
改成
cmd.CommandText = "select id from Z_USER where username='" + username + "'";