- 博客(3)
- 资源 (1)
- 问答 (1)
- 收藏
- 关注
原创 mysql主从 从库停了怎么办
CHANGE MASTER TO MASTER_HOST='x.x.x.x', MASTER_USER='user', MASTER_PASSWORD='密码', MASTER_LOG_FILE='对应主库中File名称', MASTER_LOG_POS=对应主库中Position;表明从库需要重置 输入以下指令:RESET REPLICA;注意需要先stop,再执行。2、登录主库,show master status \G。1、重新启动同步,先stop slave。1、从库停止同步,出现。
2024-05-17 13:48:37 2165
npoi导出excel分页功能
private void ToExcel(HttpContext context, string TempletFileName//模版文件, string ReportFileName//导出文件, DataTable dt2)
{
//模板文件
//string TempletFileName = context.Server.MapPath(TempletFileName);
//导出文件
//string ReportFileName = context.Server.MapPath("out.xls");
FileStream file = new FileStream(TempletFileName, FileMode.Open, FileAccess.Read);
HSSFWorkbook hssfworkbook = new HSSFWorkbook(file);
//XSSFWorkbook hssfworkbook = new XSSFWorkbook(file);
//HSSFSheet ws = (HSSFSheet)hssfworkbook.GetSheetAt(0);//GetSheet("Sheet1");
HSSFSheet ws2 = null;
int rowsCount = dt2.Rows.Count;
int columnCount = dt2.Columns.Count;
int num = 60000;
int row = 0;
if (rowsCount > 0)
{
int sheetCount = rowsCount > num ? (int)Math.Ceiling((double)(rowsCount / num)) : 0;
for (int i = 0; i rowsCount - (num * i) ? rowsCount : (i + 1) * num;
NPOI.SS.UserModel.IRow row1 = null;
for (int j = strRows; j < endRows; j++)
{
row++;
int m = 0;
if (i == 0)
{
m = 4;
}
row1 = ws2.CreateRow(row + m);
row1.HeightInPoints = 25;//行高
for (int k = 0; k < columnCount; k++)
{
ICell cell = row1.CreateCell(k);
cell.SetCellValue(dt2.Rows[j][k].ToString());
cell.CellStyle.Alignment = HorizontalAlignment.Center;
}
}
row = 0;
ws2.ForceFormulaRecalculation = true;
using (FileStream fs = new FileStream(ReportFileName, FileMode.Append, FileAccess.Write))
{
hssfworkbook.Write(fs);
}
}
}
2017-11-29
整个网站上下部分内容不变,中间内容变如何解决
2017-03-20
TA创建的收藏夹 TA关注的收藏夹
TA关注的人