/// <summary>

        /// 批量写入数据库

        /// </summary>

        /// <param name="urlInfo">Url类</param>

        public void InsertDataSet(List<UrlInfo> urlInfos)

        {

            OracleConnection myConn = new OracleConnection(connStr);

            if (myConn.State != ConnectionState.Open)

            {

                myConn.Open();

            }

            OracleDataAdapter adapter = new OracleDataAdapter();

            adapter.SelectCommand = new OracleCommand("select visitid,mobile,url,startTime,endTime,desIp,desPort,agentIp,agentPort,mobileIp,mobilePort,urlTypeId,comeFrom from cn_visit where 1=0", myConn);

            adapter.InsertCommand = new OracleCommand(@"INSERT INTO cn_visit(visitid,mobile,url,startTime,endTime,desIp,desPort,agentIp,agentPort,mobileIp,mobilePort,urlTypeId,comeFrom)

                                                        VALUES(seq_cn_visitid.Nextval,:mobile,:url,:startTime,:endTime,:desIp,:desPort,:agentIp,:agentPort,:mobileIp,:mobilePort,:urlTypeId,:comeFrom)", myConn);

            adapter.InsertCommand.Parameters.Add(":mobile", OracleType.VarChar, , "mobile");

            adapter.InsertCommand.Parameters.Add(":url", OracleType.VarChar, , "url");

            adapter.InsertCommand.Parameters.Add(":startTime", OracleType.Number, , "startTime");

            adapter.InsertCommand.Parameters.Add(":endTime", OracleType.Number, , "endTime");

            adapter.InsertCommand.Parameters.Add(":desIp", OracleType.VarChar, , "desIp");

            adapter.InsertCommand.Parameters.Add(":desPort", OracleType.Number,, "desPort");

            adapter.InsertCommand.Parameters.Add(":mobileIp", OracleType.VarChar, , "mobileIp");

            adapter.InsertCommand.Parameters.Add(":mobilePort", OracleType.Number, , "mobilePort");

            adapter.InsertCommand.Parameters.Add(":agentIp", OracleType.VarChar, , "agentIp");

            adapter.InsertCommand.Parameters.Add(":agentPort", OracleType.Number, , "agentPort");

            adapter.InsertCommand.Parameters.Add(":urlTypeId", OracleType.Number, , "urlTypeId");

            adapter.InsertCommand.Parameters.Add(":comefrom", OracleType.Number, , "comeFrom");

            adapter.InsertCommand.UpdatedRowSource = UpdateRowSource.None;

            adapter.UpdateBatchSize = ;

            DataSet dataSet = new DataSet();

            try

            {

                adapter.Fill(dataSet);

                for (int i = ; i < urlInfos.Count; i++)

                {

                    DataRow dr = dataSet.Tables[].NewRow();

                    dr["mobile"] = urlInfos[i].Mobile;

                    dr["startTime"] = urlInfos[i].StartTime;

                    dr["endTime"] = urlInfos[i].EndTime;

                    dr["url"] = urlInfos[i].Url;

                    dr["desIp"] = urlInfos[i].DesIp;

                    dr["desPort"] = urlInfos[i].DesPort;

                    dr["mobileIp"] = urlInfos[i].MobileIp;

                    dr["mobilePort"] = urlInfos[i].MobilePort;

                    dr["agentIp"] = urlInfos[i].AgentIp;

                    dr["agentPort"] = urlInfos[i].AgentPort;

                    dr["urlTypeId"] = urlInfos[i].UrlTypeId;

                    dr["comeFrom"] = urlInfos[i].ComeFrom;

                    dataSet.Tables[].Rows.Add(dr);

                }

                adapter.Update(dataSet.Tables[]);

            }

            catch (Exception e)

            {

                log.Info("写入数据库失败，原因是：" + e.ToString());

            }

            if (myConn.State == ConnectionState.Open)

            {

                myConn.Close();

            }

        }