SQL 语句

最新推荐文章于 2018-03-01 11:42:48 发布

Leovany

最新推荐文章于 2018-03-01 11:42:48 发布

阅读量1.2k

点赞数

分类专栏： VisioStudio

本文链接：https://blog.csdn.net/leovnay/article/details/18236069

版权

VisioStudio 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

1、选择语句

string str_sql = "select distinct pt_id,pt_time,m_name,pt_phone from putin where pt_time >='" + P_time_from + "' and pt_time <='" + P_time_to + "' ";

BindingSource bs = dataCon.getBindingSource(str_sql, "putin"); // 使用BindingSource数据源绑定

2、插入语句

sqlStr = "insert into purchase(p_id,l_id,p_producer,p_provider,p_name,p_phone,p_deadline,p_num,p_price,p_time,p_info,p_sign ) values('" + p_id + "','" + l_id + "','" + p_producer + "','" + p_provider + "','" + p_name + "','" + p_phone + "','" + p_deadline + "','" + p_num + "','" + p_price + "','" + p_time + "','" + p_info + "' ," + p_sign + " )";
datacon.getcom(sqlStr);

3、修改语句

string str_sql = "update purchase set p_producer = '" + p_producer + "' , p_provider ='" + p_provider + "' , p_name = '" + p_name + "' , p_phone ='" + p_phone + "' , p_deadline = '" + product_time + "' , p_num = " + p_num + " , p_price = '" + p_price + "' , p_info = '" + p_info + "' where l_id ='" + l_id + "' and p_id ='" + MyClass.Field.p_id + "' ";

dataCon.getcom(str_sql);

4、删除语句

string str_sql = "delete from purchase where p_id = '" + p_id + "'";
dataCon.getcom(str_sql);

5、绑定语句

dataOperate.cboxBind("select distinct l_id from library ", "library", "l_id", cboxId);