using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using MySql.Data.MySqlClient;
using System.Data;
博客:https://blog.csdn.net/zhangchen124
namespace GroupProject.Judy.until
{
class DBHelper
{
static string url = "server = localhost;port = 3306;user id = root;password
= root;database
= dormdb; charset = utf8";
public static void execute(string sql)
{
MySqlConnection conn = new MySqlConnection(url);
conn.Open();
MySqlCommand cmd = new MySqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();
}
public static DataTable query(string sql)
{
MySqlConnection conn = new MySqlConnection(url);
conn.Open();
MySqlDataAdapter da = new MySqlDataAdapter(sql, conn);
DataTable dt = new DataTable();
da.Fill(dt);
conn.Close();
return dt;
}
}
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using GroupProject.Judy.student;
namespace GroupProject.Judy.until
{
/// <summary>
/// 专门用来生成窗体，来保证窗体的唯一性
/// </summary>
class Factory
{
//学生管理
public static StudentManagerForm smf = new StudentManagerForm();
//添加学生
public static StudentInsertForm sif = new StudentInsertForm();
//学生详情信息
public static StudentViewForm svf = new StudentViewForm();
//学生修改
public static StudentUpdateForm suf = new StudentUpdateForm();
//学生密码重置
public static StudentPassForm spf = new StudentPassForm();
//学生退宿
public static studentEndDorm sed = new studentEndDorm();
public static StudentDormForm sdf = new StudentDormForm();
//public static StudentFindForm sff = new StudentFindForm();
public static StudentInDormForm sinf = new StudentInDormForm();
public static InDormPayMoney idpm = new InDormPayMoney();
public static MoneyInfoForm mif = new MoneyInfoForm();
public static StudentChargeDormForm scdf = new StudentChargeDormForm();
public static ChargeDormPayMoneyForm cdpmf = new ChargeDormPayMoneyForm();
public static StuFindDormView sfdv = new StuFindDormView();
}
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace GroupProject.Judy.until
{
class PageHelper
{
public int pageSize = 3;//每页显示几条数据
public int nowPage = 1;//当前页
public int count = 0;//总条数
public int getBegin()
{
return (nowPage - 1) * pageSize;
}
public int getTotalPage()
{
return this.count % this.pageSize == 0 ? this.count / this.pageSize :
this.count / this.pageSize + 1;
}
}
}