private void button1_Click(object sender, EventArgs e)
{
string username = textBox2.Text;//注意,当时 顺序有点错 别盲目复制
string password = textBox1.Text;//注意
OracleConnection conn = new OracleConnection(@"Data Source=ORCL;User ID=scott;Password=1234");
conn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "Select * from qq1 where pname=:pname and pwd=:pwd";
cmd.Parameters.Add(new OracleParameter(":pname", username));
cmd.Parameters.Add(new OracleParameter(":pwd", password));
OracleDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
MessageBox.Show("登陆成功");
}
else
MessageBox.Show("用户名或者密码错误");
conn.Close();
}
这里是加了一个button用作登录的命令,还有两个textbox用作登录名和密码