• 大小: 7.88MB
    文件类型: .zip
    金币: 1
    下载: 0 次
    发布日期: 2023-10-17
  • 语言: C#
  • 标签: C#  Mysql  

资源简介

基于C#和Mysql的学生信息管理系统,运行.sln文件即可。

资源截图

代码片段和文件信息

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace PWMS
{
    public partial class F_Login : Form
    {
        DataClass.MyMeans MyClass = new PWMS.DataClass.MyMeans();
        
        public F_Login()
        {
            InitializeComponent();
        }

        private void butClose_Click(object sender EventArgs e)
        {
            if ((int)(this.Tag) == 1)
            {
                DataClass.MyMeans.Login_n = 3;
                Application.Exit();
            }
            else
                if ((int)(this.Tag) == 2)
                    this.Close();
        }

        private void butLogin_Click(object sender EventArgs e)
        {
            if (textName.Text != ““ & textPass.Text != ““)
            {
                SqlDataReader temDR = MyClass.getcom(“select * from tb_Login where Name=‘“ + textName.Text.Trim() + “‘ and Pass=‘“ + textPass.Text.Trim() + “‘“);
                bool ifcom = temDR.Read();
                if (ifcom)
                {
                    DataClass.MyMeans.Login_Name = textName.Text.Trim();
                    DataClass.MyMeans.Login_ID = temDR.GetString(0);
                    DataClass.MyMeans.My_con.Close();
                    DataClass.MyMeans.My_con.Dispose();
                    DataClass.MyMeans.Login_n = (int)(this.Tag);
                    this.Close();
                }
                else
                {
                    MessageBox.Show(“用户名或密码错误!“ “提示“ MessageBoxButtons.OK MessageBoxIcon.Information);
                    textName.Text = ““;
                    textPass.Text = ““;
                }
                MyClass.con_close();
            }
            else
                MessageBox.Show(“请将登录信息添写完整!“ “提示“ MessageBoxButtons.OK MessageBoxIcon.Information);
        }

        private void F_Login_Load(object sender EventArgs e)
        {
            try
            {
                MyClass.con_open();  //连接数据库
                MyClass.con_close();
                textName.Text = ““;
                textPass.Text = ““;

            }
            catch
            {
                MessageBox.Show(“数据库连接失败。“ “提示“ MessageBoxButtons.OK MessageBoxIcon.Information);
                Application.Exit();
            }
        }

        private void textName_KeyPress(object sender KeyPressEventArgs e)
        {
            if (e.KeyChar == ‘\r‘)
                textPass.Focus();
        }

        private void textPass_KeyPress(object sender KeyPressEventArgs e)
        {
            if (e.KeyChar == ‘\r‘)
                butLogin.Focus();               
        }

        private void F_Login_Activated(object sender EventArgs e)
        {
            textName.Focus();
        }

    }
}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2016-07-09 17:27  PWMS\
     目录           0  2016-07-09 17:27  PWMS\Database\
     文件     3145728  2012-04-20 14:30  PWMS\Database\db_PWMS.mdf
     文件     2359296  2012-04-20 14:30  PWMS\Database\db_PWMS_log.ldf
     目录           0  2016-07-09 17:27  PWMS\DataClass\
     文件        4452  2012-04-20 13:54  PWMS\DataClass\MyMeans.cs
     文件        3016  2008-03-21 11:00  PWMS\F_Login.cs
     文件        6856  2008-03-11 19:09  PWMS\F_Login.designer.cs
     文件      341697  2008-03-11 19:09  PWMS\F_Login.resx
     文件        7226  2008-03-21 18:43  PWMS\F_Main.cs
     文件       38268  2008-03-21 14:36  PWMS\F_Main.designer.cs
     文件     1001373  2008-03-21 14:36  PWMS\F_Main.resx
     目录           0  2016-07-09 17:27  PWMS\Image\
     文件        2909  2008-02-25 16:06  PWMS\Image\01.png
     文件        3077  2008-02-25 16:06  PWMS\Image\02.PNG
     文件        3241  2008-02-25 16:05  PWMS\Image\03.PNG
     文件        2897  2008-02-25 16:05  PWMS\Image\04.PNG
     文件        3092  2008-02-25 16:05  PWMS\Image\05.PNG
     文件        3525  2008-02-25 16:05  PWMS\Image\06.PNG
     文件        2933  2008-02-25 16:04  PWMS\Image\07.PNG
     文件        3636  2008-02-25 15:53  PWMS\Image\08.PNG
     文件        3042  2008-02-25 15:51  PWMS\Image\09.PNG
     文件       29776  2007-12-11 22:05  PWMS\Image\PEOPLE.jpg
     文件      659936  2008-02-25 15:44  PWMS\Image\主界面.bmp
     文件        1804  2008-02-25 16:08  PWMS\Image\备份.bmp
     文件      223716  2008-02-25 15:44  PWMS\Image\登录.BMP
     目录           0  2016-07-09 17:27  PWMS\InfoAddForm\
     文件       11367  2008-03-11 19:14  PWMS\InfoAddForm\F_Address.Designer.cs
     文件        2354  2008-03-26 14:26  PWMS\InfoAddForm\F_Address.cs
     文件        5814  2008-03-11 19:14  PWMS\InfoAddForm\F_Address.resx
     文件        8024  2008-03-11 19:14  PWMS\InfoAddForm\F_Basic.Designer.cs
............此处省略100个文件信息

评论

共有 条评论