using System.Data.OleDb;
public partial class 新闻隔断 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\新闻采集.mdb");
con.Open();
OleDbCommand cmd = new OleDbCommand("select * from c1 where len(内容)>150 order by ID asc", con); //查询所有的表tb_pic记录
OleDbDataReader dr = cmd.ExecuteReader();
while (dr.Read()) //读取所有记录
{
string leirong = dr["内容"].ToString().Trim();
string word1 ="";
string word ="";
string id = dr["id"].ToString();
if (leirong.Length > 0)
{
for (i = 0;i * 150 < leirong.Length; i++)
{
word = leirong.Substring(i * 150, 150);
if (word.Length > 0)
{
OleDbCommand cmd02 = new OleDbCommand("insert into c2(内容) Values('" + word + "')", con);
cmd02.ExecuteNonQuery();
}
OleDbCommand cmd04 = new OleDbCommand("update daochu set pp='" + pp2 + "',pageurl='" + pageurl + "' where id =" + j + "", con);
cmd04.ExecuteNonQuery();
}
}
}
}
}
本站仅提供存储服务,所有内容均由用户发布,如发现有害或侵权内容,请
点击举报。