日期:2014-05-20  浏览次数:20726 次

登录
private void button1_Click(object sender, EventArgs e)
  {
  string u = textBox1.Text.ToString();
  string p = textBox2.Text.ToString();
  OracleConnection conn = new OracleConnection(@"Data Source=insure155;User ID=WZH;Unicode=True");
  conn.Open();
  OracleCommand cmd = conn.CreateCommand();
  cmd.CommandText = "select * from insure155 where user='" + u + " '";
  OracleDataReader odr = cmd.ExecuteReader();
  if (odr.Read())
  {
  if (odr["password"].ToString().Trim() == p)
  {
  MessageBox.Show("恭喜您登陆成功!", "登录成功!", MessageBoxButtons.OK, MessageBoxIcon.Information);
  Form1 form1 = new Form1();
  form1.Show();
  }
  else
  MessageBox.Show("密码错误,请重新输入!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Information);
  }
  }

红色那段,数据库连接是成功的。大家不要笑我啊!我新手,想知道程序为什么不对,哪里错了。有好心人回答吗?希望在改程序的时候写上注释,这样可以方便我看懂!!!非常感谢!!!!

------解决方案--------------------

cmd.CommandText = "select * from insure155 where user='" + u + " '";\

============>

cmd.CommandText = "select * from insure155 where [user]='" + u + " '";
------解决方案--------------------
探讨

引用:
cmd.CommandText = "select * from insure155 where user='" + u + " '";\

============>

cmd.CommandText = "select * from insure155 where [user]='" + u + " '";


没用啊!还是不行,cm……