110,536
社区成员
发帖
与我相关
我的任务
分享
private void button1_Click(object sender, EventArgs e)
{
if (this.comboBox1.Text == "查询全部")
{
string ConnectionString = "Data Source=fly;user=fly;password=fly;";//写连接串
OracleConnection conn = new OracleConnection(ConnectionString);//创建一个新连接
conn.Open();
int j = 0;
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from(select * from sms_alarm )";//在这儿写sql语句
OracleDataReader odr = cmd.ExecuteReader();//创建一个OracleDateReader对象
listView1.Items.Clear();
while (odr.Read())//读取数据,如果odr.Read()返回为false的话,就说明到记录集的尾部了
{
listView1.Update();
listView1.Items.Add(odr.GetOracleString(1).ToString(), j);
listView1.Items[j].SubItems.Add(odr.GetInt32(3).ToString());
listView1.Items[j].SubItems.Add(odr.GetOracleString(7).ToString());
listView1.Items[j].SubItems.Add(odr.GetString(2));
listView1.Items[j].SubItems.Add(odr.GetOracleString(8).ToString());
listView1.EndUpdate();
j = j + 1;
}
}
else if(this.comboBox1.Text=="手机号码")
{
string ConnectionString = "Data Source=fly;user=fly;password=fly;";//写连接串
OracleConnection conn = new OracleConnection(ConnectionString);//创建一个新连接
conn.Open();
int j = 0;
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "select PHONE_NO,PHONE_AREA,SMS_CONTENT,ALARM_TIME,REPLY_SMS_CONTENT from sms_alarm where PHONE_NO='" + textBox1.Text + "' ";//在这儿写sql语句
OracleDataReader odr = cmd.ExecuteReader();//创建一个OracleDateReader对象
listView1.Items.Clear();
if (odr.HasRows)
{
while (odr.Read())//读取数据,如果odr.Read()返回为false的话,就说明到记录集的尾部了
{
listView1.Update();
listView1.Items.Add(odr.GetOracleString(1).ToString(), j);
listView1.Items[j].SubItems.Add(odr.GetInt32(3).ToString());
listView1.Items[j].SubItems.Add(odr.GetOracleString(7).ToString());
listView1.Items[j].SubItems.Add(odr.GetString(2));
listView1.Items[j].SubItems.Add(odr.GetOracleString(8).ToString());
listView1.EndUpdate();
j = j + 1;
}
}
else
{
MessageBox.Show("没有该纪录!!","提示",MessageBoxButtons.OK,MessageBoxIcon.Hand);
textBox1.Text = "";
}
}
else if (this.comboBox1.Text == "报警时间(0000-00-00 00:00:00)")
{
string ConnectionString = "Data Source=fly;user=fly;password=fly";//写连接串
OracleConnection conn = new OracleConnection(ConnectionString);//创建一个新连接
conn.Open();
int j = 0;
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "select PHONE_NO,PHONE_AREA,SMS_CONTENT,ALARM_TIME,REPLY_SMS_CONTENT from sms_alarm where ALARM_TIME='" + textBox1.Text + "' ";//在这儿写sql语句
OracleDataReader odr = cmd.ExecuteReader();//创建一个OracleDateReader对象
listView1.Items.Clear();
if (odr.HasRows)
{
while (odr.Read())//读取数据,如果odr.Read()返回为false的话,就说明到记录集的尾部了
{
listView1.Update();
listView1.Items.Add(odr.GetOracleString(1).ToString(), j);
listView1.Items[j].SubItems.Add(odr.GetInt32(3).ToString());
listView1.Items[j].SubItems.Add(odr.GetOracleString(7).ToString());
listView1.Items[j].SubItems.Add(odr.GetString(2));
listView1.Items[j].SubItems.Add(odr.GetOracleString(8).ToString());
listView1.EndUpdate();
j = j + 1;
}
}
else
{
MessageBox.Show("没有该纪录!!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Hand);
textBox1.Text = "";
}
}
else if (this.comboBox1.Text == "报警手机所在地")
{
string ConnectionString = "Data Source=fly;user=fly;password=fly";//写连接串
OracleConnection conn = new OracleConnection(ConnectionString);//创建一个新连接
conn.Open();
int j = 0;
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "select PHONE_NO,PHONE_AREA,SMS_CONTENT,ALARM_TIME,REPLY_SMS_CONTENT from sms_alarm where PHONE_AREA='" + textBox1.Text + "' ";//在这儿写sql语句
OracleDataReader odr = cmd.ExecuteReader();//创建一个OracleDateReader对象
listView1.Items.Clear();
if (odr.HasRows)
{
while (odr.Read())//读取数据,如果odr.Read()返回为false的话,就说明到记录集的尾部了
{
listView1.Update();
listView1.Items.Add(odr.GetOracleString(1).ToString(), j);
listView1.Items[j].SubItems.Add(odr.GetInt32(3).ToString());
listView1.Items[j].SubItems.Add(odr.GetOracleString(7).ToString());
listView1.Items[j].SubItems.Add(odr.GetString(2));
listView1.Items[j].SubItems.Add(odr.GetOracleString(8).ToString());
listView1.EndUpdate();
j = j + 1;
}
}
else
{
MessageBox.Show("没有该纪录!!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Hand);
textBox1.Text = "";
}
}
else if (this.comboBox1.Text == "报警内容关键字")
{
string ConnectionString = "Data Source=fly;user=fly;password=fly";//写连接串
OracleConnection conn = new OracleConnection(ConnectionString);//创建一个新连接
conn.Open();
int j = 0;
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "select PHONE_NO,PHONE_AREA,SMS_CONTENT,ALARM_TIME,REPLY_SMS_CONTENT from sms_alarm where SMS_CONTENT LIKE '%" + textBox1.Text + "%' ";//在这儿写sql语句
OracleDataReader odr = cmd.ExecuteReader();//创建一个OracleDateReader对象
listView1.Items.Clear();
if (odr.HasRows)
{
while (odr.Read())//读取数据,如果odr.Read()返回为false的话,就说明到记录集的尾部了
{
listView1.Update();
listView1.Items.Add(odr.GetOracleString(1).ToString(), j);
listView1.Items[j].SubItems.Add(odr.GetInt32(3).ToString());
listView1.Items[j].SubItems.Add(odr.GetOracleString(7).ToString());
listView1.Items[j].SubItems.Add(odr.GetString(2));
listView1.Items[j].SubItems.Add(odr.GetOracleString(8).ToString());
listView1.EndUpdate();
j = j + 1;
}
}
else
{
MessageBox.Show("没有该纪录!!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Hand);
textBox1.Text = "";
}
}
}