C++Builder开发.pptVIP

1。Datasource 和DBGrid的使用特点 2。静态设置与动态设置 void __fastcall TForm1::FormCreate(TObject *Sender) { ADOQuery1-SQL-Add(select sno,sname from student) ; ADOQuery1-Open(); //ADOQuery1-Active=true; } AnsiString xb=; if(RadioButton1-Checked==1) { xb=男;} if(RadioButton2-Checked==1) { xb=女;} ADOQuery1-SQL-Clear() ; AnsiString an1= select * from student where ; if(Form4-Edit1-Text!=) //如果 Form4-Edit1-Text为空， //就不执行 an1+= sno=+Form4-Edit1-Text+ and //当都为空就显示select * from student where year(csrq)1990 {an1+= sno=+Form4-Edit1-Text+ and;} if(Form4-Edit2-Text!=) {an1+= sname=+Form4-Edit2-Text+ and;} if(xb!=) {an1+= sex=+xb+ and;} if(ComboBox1-Text!=) {an1+= sdept=+ComboBox1-Text+ and;} if(ComboBox2-Text!=请选择) {an1+= year(csrq)=+ComboBox2-Text+ and;} if(ComboBox3-Text!=请选择) {an1+= year(csrq)=+ComboBox3-Text+ and;} an1+= year(csrq)1900 ; ADOQuery1-SQL-Add(an1); //ShowMessage(an1); ADOQuery1-Open() ; DBGrid1-DataSource=DataSource1; // 动态设置数据源，当然也可事先（静态）设置好 刷新按钮 void __fastcall TForm4::Button2Click(TObject *Sender) { Form4-Edit1-Text=; Form4-Edit2-Text=; RadioButton1-Checked=false; RadioButton2-Checked=false; ComboBox1-Text= ; ComboBox2-Text=请选择; ComboBox3-Text=请选择 ; Form4-Refresh() ; } 查询按钮（此处必须输入学号） if(Form5-Edit1-Text==) {ShowMessage(请查询输入要查询的学号); return; } ADOQuery1-SQL-Clear(); AnsiString an1=select sno,sname,sex,sdept,year(csrq) ; an1+= as nn,month(csrq) as ; an1+=“ yy ,day(csrq) as rr from student where ”;//nn,yy,rr的作用 an1+= sno=+Form5-Edit1-Text+; ADOQuery1-SQL-Add(an1); ADOQuery1-Open(); //为各个变量赋值 Form5-Edit1-Text=ADOQuery1-FieldValues[sno]; //取数据库表中字段值的内容，当前查询到的记录，当前指针指向的 Form5-Edit2-Text=ADOQuery1-FieldValues[sname]; AnsiString xb; xb=ADOQuery1-FieldValues[sex]; if(xb==男) {RadioButton1-Checked=true;} if(xb==女) {Radi