110,571
社区成员
发帖
与我相关
我的任务
分享
private void button1_Click(object sender, EventArgs e)
{
string User_ID = textBox1.Text;
string User_PWD = textBox2.Text;
string a = textBox3.Text;
int count = 0;
try
{
string ConnectionString = "Data Source=fly;user=fly;password=fly";//写连接串
OracleConnection conn = new OracleConnection(ConnectionString);//创建一个新连接
conn.Open();
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from alarm_user where user_ID='" + User_ID + "'";//在这儿写sql语句
OracleDataReader odr = cmd.ExecuteReader();//创建一个OracleDateReader对象
string pwd = "";
while (odr.Read())//读取数据,如果odr.Read()返回为false的话,就说明到记录集的尾部了
{
count++;
pwd = odr.GetOracleString(1).ToString();
//MessageBox.Show(odr.GetOracleString(1).ToString());//输出字段1,这个数是字段索引,具体怎么使用字段名还有待研究
}
odr.Close();
cmd.Clone();
conn.Close();
if (count == 0)
{
MessageBox.Show("没有此用户");
textBox2.Text = "";
textBox1.Text = "";
this.textBox1.Focus();
}
else
{
if (User_PWD.Equals(pwd))
{
string ConnectionString = "Data Source=fly;user=fly;password=fly";//写连接串
OracleConnection conn1 = new OracleConnection(ConnectionString);//创建一个新连接
conn1.Open();
OracleCommand cmd1 = conn.CreateCommand();
cmd1.CommandText = "update alarm_user set user_pwd='" + a + "'";//在这儿写sql语句
OracleDataReader odr1 = cmd.ExecuteReader();//创建一个OracleDateReader对象
cmd1.Clone();
odr1.Close();
conn1.Close();
MessageBox.Show("修改成功!!");
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
}
else
{
MessageBox.Show("密码错误,请重新输入!");
textBox2.Text = "";
textBox3.Text = "";
this.textBox1.Focus();
}
}
}
catch (Exception ee)
{
MessageBox.Show(ee.Message.ToString());
}
}
private void button1_Click(object sender, EventArgs e)
{
string User_ID = textBox1.Text;
string User_PWD = textBox2.Text;
string a = textBox3.Text;
int count = 0;
try
{
string ConnectionString = "Data Source=fly;user=fly;password=fly";//写连接串
OracleConnection conn = new OracleConnection(ConnectionString);//创建一个新连接
conn.Open();
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from alarm_user where user_ID='" + User_ID + "'";//在这儿写sql语句
OracleDataReader odr = cmd.ExecuteReader();//创建一个OracleDateReader对象
string pwd = "";
while (odr.Read())//读取数据,如果odr.Read()返回为false的话,就说明到记录集的尾部了
{
count++;
pwd = odr.GetOracleString(1).ToString();
//MessageBox.Show(odr.GetOracleString(1).ToString());//输出字段1,这个数是字段索引,具体怎么使用字段名还有待研究
}
odr.Close();
cmd.Clone();
conn.Close();
if (count == 0)
{
MessageBox.Show("没有此用户");
textBox2.Text = "";
textBox1.Text = "";
this.textBox1.Focus();
}
else
{
if (User_PWD.Equals(pwd))
{
conn.Open();
OracleCommand cmd1 = conn.CreateCommand();
cmd1.CommandText = "update alarm_user set user_pwd='" + a + "' where User_ID ='"+User_ID+"'";//在这儿写sql语句 .不知道你的用户表里面的字段是不是这个.
// OracleDataReader odr1 = cmd1.ExecuteReader();//创建一个OracleDateReader对象
int i = cmd1.ExecuteNonQuery();
cmd1.Clone();
odr.Close();
conn.Close();
if(i > 0)
{
MessageBox.Show("修改成功!!");
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
}
}
else
{
MessageBox.Show("密码错误,请重新输入!");
textBox2.Text = "";
textBox3.Text = "";
this.textBox1.Focus();
}
}
}
catch (Exception ee)
{
MessageBox.Show(ee.Message.ToString());
}
}
private void button1_Click(object sender, EventArgs e)
{
string User_ID = textBox1.Text;
string User_PWD = textBox2.Text;
string a = textBox3.Text;
int count = 0;
try
{
string ConnectionString = "Data Source=fly;user=fly;password=fly";//写连接串
OracleConnection conn = new OracleConnection(ConnectionString);//创建一个新连接
conn.Open();
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from alarm_user where user_ID='" + User_ID + "'";//在这儿写sql语句
OracleDataReader odr = cmd.ExecuteReader();//创建一个OracleDateReader对象
string pwd = "";
while (odr.Read())//读取数据,如果odr.Read()返回为false的话,就说明到记录集的尾部了
{
count++;
pwd = odr.GetOracleString(1).ToString();
//MessageBox.Show(odr.GetOracleString(1).ToString());//输出字段1,这个数是字段索引,具体怎么使用字段名还有待研究
}
odr.Close();
cmd.Clone();
conn.Close();
if (count == 0)
{
MessageBox.Show("没有此用户");
textBox2.Text = "";
textBox1.Text = "";
this.textBox1.Focus();
}
else
{
if (User_PWD.Equals(pwd))
{
conn.Open();
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "update alarm_user set user_pwd='" + a + "' where User_ID ='"+User_ID+"'";//在这儿写sql语句 .不知道你的用户表里面的字段是不是这个.
// OracleDataReader odr1 = cmd.ExecuteReader();//创建一个OracleDateReader对象
int i = cmd.ExecuteNonQuery();
cmd.Clone();
odr.Close();
conn.Close();
if(i > 0)
{
MessageBox.Show("修改成功!!");
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
}
}
else
{
MessageBox.Show("密码错误,请重新输入!");
textBox2.Text = "";
textBox3.Text = "";
this.textBox1.Focus();
}
}
}
catch (Exception ee)
{
MessageBox.Show(ee.Message.ToString());
}
}