62,041
社区成员
发帖
与我相关
我的任务
分享
using System;
using System.Data.OleDb;
using System.Text;
using System.IO;
public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = "Provider=Microsoft.Jet.OleDb.4.0;" + "Data Source=" + Server.MapPath("App_Data/用户.mdb");
conn.Open();
string strSQL = "select distinct email from 邮箱";//从1234表中选择不重复的邮箱地址
OleDbCommand com = new OleDbCommand(strSQL, conn);
OleDbDataReader dr = com.ExecuteReader();
StringBuilder sbQQ = new StringBuilder();
StringBuilder sb126 = new StringBuilder();
StringBuilder sb163 = new StringBuilder();
StringBuilder sbOther = new StringBuilder();
int n1,n2,n3,n4;
n1 = n2 = n3 = n4=0;
while (dr.Read())
{
string email = dr["email"].ToString().Trim();
if (email.Contains("@qq.com"))
{
n1++;
sbQQ.Append(email);
sbQQ.Append(';');
if (n1 == 5)
{
sbQQ.Append("\r\n");
n1 = 0;
}
continue;
}
if (email.Contains("@126.com"))
{
n2++;
sb126.Append(email);
sb126.Append(';');
if (n2 == 5)
{
sb126.Append("\r\n");
n2 = 0;
}
continue;
}
if (email.Contains("@163.com"))
{
n3++;
sb163.Append(email);
sb163.Append(';');
if (n3 == 5)
{
sb163.Append("\r\n");
n3 = 0;
}
continue;
}
{
n4++;
sbOther.Append(email);
sbOther.Append(';');
if (n4 == 5)
{
sbOther.Append("\r\n");
n4 = 0;
}
}
}
dr.Close();
WriteFile(sbQQ,"qq邮箱.txt");
WriteFile(sb126,"126邮箱.txt");
WriteFile(sb163,"163邮箱.txt");
WriteFile(sbOther,"其他邮箱.txt");
}
protected void WriteFile(StringBuilder Xsb,string fileName)
{
FileInfo f = new FileInfo(Server.MapPath("~") + "/"+fileName);
StreamWriter writer = f.AppendText();
writer.Write(Xsb);
writer.Close();
}
}
FileInfo f = new FileInfo("../qq邮箱.txt");
//路径不对!
FileInfo f = new FileInfo(Server.MapPath("~")+"/qq邮箱.txt");
//通过执行sql语句返回一个SqlDataReader
SqlDataReader dr = Sqlhelp.ExecudeterReader("sql语句");
string path126 = "126.txt";
string pathqq= "qq.txt";
//...其他路径
while(dr.Read())
{
if(dr["Email"].ToString().indexOf("@126")!=-1)
{
if(!File.Exist(path))
File.WriteAllText(path, dr["Email"]+";", Encoding.UTF8);
else
File.AppendAllText(path,dr["Email"]+";",Encoding.UTF8);
}
if(dr["Email"].ToString().indexOf("@qq")!=-1)
{
if(!File.Exist(path))
File.WriteAllText(path, dr["Email"]+";", Encoding.UTF8);
else
File.AppendAllText(path,dr["Email"]+";",Encoding.UTF8);
}
//...其他类似
}
//然后在分别读取.txt按;分割
string str = File.ReadAllText(path126, Encoding.UTF8);
string[] result = str.split(';');
StringBuilder sb126 = new StringBuilder();
StringBuilder sbqq = new StringBuilder();
//..其他类似
for(int i=0;i<result.length;i++)
{
if(i%5==0)
sb.append(result[i].ToString()+"</br>");
else
sb.append(result[i].ToString());
}
TextBox126.Text = sb126.ToString();
Textboxqq.Text = sbqq.ToString();
//家里没装vs,没法全部写!
OleDbData md = new OleDbData("select * from 邮箱");
md.ExecuteReader();
StringBuilder sb = new StringBuilder();
int n = 0;
while (md.DR.Read())
{
string email = md.DR["email"].ToString().Trim();
if (email.Contains("@qq.com"))
{
n++;
sb.Append(email);
sb.Append(';');
if (n == 5)
{
sb.Append("\r\n");
n = 0;
}
}
}
md.Close();
FileInfo f = new FileInfo("c:/126邮箱.txt");
StreamWriter writer = f.AppendText();
writer.Write(sb);
writer.Close();
for(int i=1;i<=result.length;i++)
{
if(i%5==0)
sb.append(result[i].ToString()+"</br>");
else
sb.append(result[i].ToString());
}
//上面少写了个
if(dr["Email"].ToString().indexOf("@126")!=-1)
while(dr.Read())
{
if(dr["Email"].ToString().indexOf("@126"))
{
string path = "126.txt";
if(!File.Exist(path))
File.WriteAllText(path, dr["Email"]+";", Encoding.UTF8);
else
File.AppendAllText(path,dr["Email"]+";",Encoding.UTF8);
}
}
//然后在读取126.txt按;分割
string str = File.ReadAllText(path, Encoding.UTF8);
string[] result = str.split(';');
StringBuilder sb = new StringBuilder();
for(int i=0;i<result.length;i++)
{
if(i%5==0)
sb.append(result[i].ToString()+"</br>");
else
sb.append(result[i].ToString());
}