能用sql搞定就用sql,不要用程序去搞定,因为这样太慢了,见下项目过程中的两种写法

插入数据很多时间都是浪费在程序与数据库通信上,,,大量数据插入,建议还是加入事务,然后用批处理插入来得快

直接插入多条:

 INSERT
INTO table_name(col_one,col_two)
SELECT 'col1','col2'
UNION
SELECT 'col11','col22'--------这个是sqlserver的语法,用UNION没有顺序
 INSERT
INTO table_name(col_one,col_two)
SELECT 'col1','col2'
UNION all
SELECT 'col11','col22'--------这个是sqlserver的语法,用UNION all才有顺序,能按照自己要求的顺序进行插入
insert into 表名(id,name) 
values(1,'A'),(2,'B'),(3,'C'),-----------------这个是mysql的 
----------------------------------------
程序的SB写法
public DataSet ygzpdj26Xxzp(string name, string mon, int type1, int type2, int type3, int type4, int type5, int type6, int type7, int type8, int type9, int type10, int type11, int type12, int type13, int type14, int type15, int type16, int type17, int type18, int type19, int type20, int type21, int type22, int type23, int type24, int type25, int type26)
        {
            con.Open();           
            string sql1 = "insert into OA_Assess_Score (assessCategory,assessType,assessName,assessMonth,mScore) values ('工作态度','纪律方面','" + name + "','" + mon + "'+'-01','" + type1 + "')";
            string sql2 = "insert into OA_Assess_Score (assessCategory,assessType,assessName,assessMonth,mScore) values ('工作态度','积极方面','" + name + "','" + mon + "'+'-01','" + type2 + "')";
            string sql3 = "insert into OA_Assess_Score (assessCategory,assessType,assessName,assessMonth,mScore) values ('工作态度','责任方面','" + name + "','" + mon + "'+'-01','" + type3 + "')";
            string sql4 = "insert into OA_Assess_Score (assessCategory,assessType,assessName,assessMonth,mScore) values ('工作态度','协作方面','" + name + "','" + mon + "'+'-01','" + type4 + "')";
            string sql5 = "insert into OA_Assess_Score (assessCategory,assessType,assessName,assessMonth,mScore) values ('工作态度','商业保密','" + name + "','" + mon + "'+'-01','" + type5 + "')";
            string sql6 = "insert into OA_Assess_Score (assessCategory,assessType,assessName,assessMonth,mScore) values ('工作态度','个人仪表','" + name + "','" + mon + "'+'-01','" + type6 + "')";
            string sql7 = "insert into OA_Assess_Score (assessCategory,assessType,assessName,assessMonth,mScore) values ('工作业绩','行为响应','" + name + "','" + mon + "'+'-01','" + type7 + "')";
            string sql8 = "insert into OA_Assess_Score (assessCategory,assessType,assessName,assessMonth,mScore) values ('工作业绩','行为计划','" + name + "','" + mon + "'+'-01','" + type8 + "')";
            string sql9 = "insert into OA_Assess_Score (assessCategory,assessType,assessName,assessMonth,mScore) values ('工作业绩','行为沟通','" + name + "','" + mon + "'+'-01','" + type9 + "')";
            string sql10 = "insert into OA_Assess_Score (assessCategory,assessType,assessName,assessMonth,mScore) values ('工作业绩','操作规范','" + name + "','" + mon + "'+'-01','" + type10 + "')";
            string sql11 = "insert into OA_Assess_Score (assessCategory,assessType,assessName,assessMonth,mScore) values ('工作业绩','数量完成','" + name + "','" + mon + "'+'-01','" + type11 + "')";
            string sql12 = "insert into OA_Assess_Score (assessCategory,assessType,assessName,assessMonth,mScore) values ('工作业绩','质量完成','" + name + "','" + mon + "'+'-01','" + type12 + "')";
            string sql13 = "insert into OA_Assess_Score (assessCategory,assessType,assessName,assessMonth,mScore) values ('工作业绩','时间效率','" + name + "','" + mon + "'+'-01','" + type13 + "')";
            string sql14 = "insert into OA_Assess_Score (assessCategory,assessType,assessName,assessMonth,mScore) values ('工作业绩','难度系数','" + name + "','" + mon + "'+'-01','" + type14 + "')";
            string sql15 = "insert into OA_Assess_Score (assessCategory,assessType,assessName,assessMonth,mScore) values ('工作业绩','客户投诉','" + name + "','" + mon + "'+'-01','" + type15 + "')";
            string sql16 = "insert into OA_Assess_Score (assessCategory,assessType,assessName,assessMonth,mScore) values ('工作业绩','汇报进展','" + name + "','" + mon + "'+'-01','" + type16 + "')";
            string sql17 = "insert into OA_Assess_Score (assessCategory,assessType,assessName,assessMonth,mScore) values ('工作业绩','汇报完整','" + name + "','" + mon + "'+'-01','" + type17 + "')";
            string sql18 = "insert into OA_Assess_Score (assessCategory,assessType,assessName,assessMonth,mScore) values ('学习进取','岗内知识','" + name + "','" + mon + "'+'-01','" + type18 + "')";
            string sql19 = "insert into OA_Assess_Score (assessCategory,assessType,assessName,assessMonth,mScore) values ('学习进取','岗外知识','" + name + "','" + mon + "'+'-01','" + type19 + "')";
            string sql20 = "insert into OA_Assess_Score (assessCategory,assessType,assessName,assessMonth,mScore) values ('管理能力','能源管理','" + name + "','" + mon + "'+'-01','" + type20 + "')";
            string sql21 = "insert into OA_Assess_Score (assessCategory,assessType,assessName,assessMonth,mScore) values ('管理能力','设备保养','" + name + "','" + mon + "'+'-01','" + type21 + "')";
            string sql22 = "insert into OA_Assess_Score (assessCategory,assessType,assessName,assessMonth,mScore) values ('管理能力','财务制度','" + name + "','" + mon + "'+'-01','" + type22 + "')";
            string sql23 = "insert into OA_Assess_Score (assessCategory,assessType,assessName,assessMonth,mScore) values ('管理能力','物资管理','" + name + "','" + mon + "'+'-01','" + type23 + "')";
            string sql24 = "insert into OA_Assess_Score (assessCategory,assessType,assessName,assessMonth,mScore) values ('管理能力','安全保障','" + name + "','" + mon + "'+'-01','" + type24 + "')";
            string sql25 = "insert into OA_Assess_Score (assessCategory,assessType,assessName,assessMonth,mScore) values ('附加分数','突出贡献','" + name + "','" + mon + "'+'-01','" + type25 + "')";
            string sql26 = "insert into OA_Assess_Score (assessCategory,assessType,assessName,assessMonth,mScore) values ('附加分数','培养人才','" + name + "','" + mon + "'+'-01','" + type26 + "')";
            String[] sqls = {sql1,sql2,sql3};
            SqlCommand cmd = null;
            DataSet ds = new DataSet();
            for (int i = 0; i < 3; i++)
            {
                cmd = new SqlCommand(sqls[i], con); 
                SqlDataAdapter sda = new SqlDataAdapter(cmd);
                sda.Fill(ds);
            }
            return ds;
            con.Close();
            

        }



觉得写得不错,帮忙打赏下,谢谢!

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值