嘉峪关建设局网站,20m带宽做网站够用吗,wordpress文章更新插件,陕西省建设厅注册中心网站本文所述实例为C#结合数据库#xff0c;来验证所识别的ID卡内容#xff0c;通过本实例代码#xff0c;用户可以轻松实现对ID卡会员信息的验证。该实例代码可实现读取数据库#xff0c;进而逐步实现数据库连接#xff0c;数据库读取#xff0c;ID卡读取#xff0c;ID卡信…本文所述实例为C#结合数据库来验证所识别的ID卡内容通过本实例代码用户可以轻松实现对ID卡会员信息的验证。该实例代码可实现读取数据库进而逐步实现数据库连接数据库读取ID卡读取ID卡信息与数据库内容比对最终返回结果并告之是否验证成功。具体功能代码如下using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.OleDb;using System.Runtime.InteropServices;using System.Diagnostics;using System.Collections;namespace IDCard{public partial class Form1 : Form{public Form1(){InitializeComponent();}public delegate int HookProc(int nCode, int wParam, IntPtr lParam);static int hHook 0;public const int WH_KEYBOARD_LL 13;//LowLevel键盘截获如果是WH_KEYBOARD2并不能对系统键盘截取Acrobat Reader会在你截取之前获得键盘。HookProc KeyBoardHookProcedure;[DllImport(kernel32)]public static extern int Beep(int dwFreq, int dwDuration);//让计算机蜂鸣string DataPath ;//数据库路径OleDbConnection con;//OleDbConnection对象连接数据库OleDbCommand cmd;//OleDbCommand对象执行SQL语句//键盘Hook结构函数[StructLayout(LayoutKind.Sequential)]public class KeyBoardHookStruct{public int vkCode;public int scanCode;public int flags;public int time;public int dwExtraInfo;}[DllImport(user32.dll)]public static extern int SetWindowsHookEx(int idHook, HookProc lpfn, IntPtr hInstance, int threadId);[DllImport(user32.dll, CharSet CharSet.Auto, CallingConvention CallingConvention.StdCall)]//抽掉钩子public static extern bool UnhookWindowsHookEx(int idHook);[DllImport(user32.dll)]//调用下一个钩子public static extern int CallNextHookEx(int idHook, int nCode, int wParam, IntPtr lParam);[DllImport(kernel32.dll)]public static extern IntPtr GetModuleHandle(string name);public string getNum(string code){string flag ;switch (code){case 048:flag0; break;case 049:flag 1; break;case 050:flag 2; break;case 051:flag 3; break;case 052:flag 4; break;case 053:flag 5; break;case 054:flag 6; break;case 055:flag 7; break;case 056:flag 8; break;case 057:flag 9; break;}return flag;}public void Hook_Start(){// 安装键盘钩子if (hHook 0){KeyBoardHookProcedure new HookProc(KeyBoardHookProc);hHook SetWindowsHookEx(WH_KEYBOARD_LL,KeyBoardHookProcedure,GetModuleHandle(Process.GetCurrentProcess().MainModule.ModuleName), 0);//如果设置钩子失败.if (hHook 0){Hook_Clear();}}}//取消钩子事件public void Hook_Clear(){bool retKeyboard true;if (hHook ! 0){retKeyboard UnhookWindowsHookEx(hHook);hHook 0;}//如果去掉钩子失败.if (!retKeyboard) throw new Exception(UnhookWindowsHookEx failed.);}//这里可以添加自己想要的信息处理string NumCode;public int KeyBoardHookProc(int nCode, int wParam, IntPtr lParam){if (nCode 0){if (wParam 0x0104 || wParam 0x0100){KeyBoardHookStruct kbh (KeyBoardHookStruct)Marshal.PtrToStructure(lParam, typeof(KeyBoardHookStruct));int flag kbh.vkCode;switch (flag){case 96:NumCode 0; break;case 97:NumCode 1; break;case 98:NumCode 2; break;case 99:NumCode 3; break;case 100:NumCode 4; break;case 101:NumCode 5; break;case 102:NumCode 6; break;case 103:NumCode 7; break;case 104:NumCode 8; break;case 105:NumCode 9; break;}if (flag 13){if (NumCode.Length ! 0){string c ;string id ;for (int i 0; i NumCode.Length - 3; i 3){string b NumCode.Substring(i, 3);c getNum(b);}id c;if (id.Length 8)//如果卡号为8位{//实例化OleDbConnection对象con new OleDbConnection(ProviderMicrosoft.Jet.OLEDB.4.0;Data source DataPath);con.Open();//打开数据库连接//实例化OleDbCommand对象根据ID卡号检索数据表cmd new OleDbCommand(select * from tb_UserInfo where CardID id , con);OleDbDataReader sdr cmd.ExecuteReader();//实例化OleDbDataReader对象sdr.Read();//读取记录txtShowCardID.Text id;//获取ID卡号txtShowName.Text sdr[UName].ToString();//获取员工姓名cbbShowSex.Text sdr[USex].ToString();//获取员工性别cbbShowDep.Text sdr[UDep].ToString();//获取员工部门con.Close();//关闭数据库连接Beep(3000, 100);//计算机蜂鸣}NumCode ;}}}}return CallNextHookEx(hHook, nCode, wParam, lParam);}private void Form1_Load(object sender, EventArgs e){cbbdep.SelectedIndex 0;//设置部门下拉框的第一项被选中cbbsex.SelectedIndex 0;//设置性别下拉框的第一项被选中//获取数据库路径DataPath Application.StartupPath.ToString();DataPath DataPath.Substring(0, DataPath.LastIndexOf(\\));DataPath DataPath.Substring(0, DataPath.LastIndexOf(\\));DataPath \db.mdb;}private void radioButton1_CheckedChanged(object sender, EventArgs e){if (radioButton1.Checked){groupBox1.Enabled true;Hook_Clear();}}private void radioButton2_CheckedChanged(object sender, EventArgs e){if (radioButton2.Checked){groupBox1.Enabled false;Hook_Start();}}private void button2_Click(object sender, EventArgs e){txtIdcard.Text ;txtName.Text ;}private void button1_Click(object sender, EventArgs e){if (txtIdcard.Text || txtName.Text )//如果没有输入ID卡号和员工姓名{//弹出警告信息if (MessageBox.Show(请将数据填写完整, 警告, MessageBoxButtons.OK, MessageBoxIcon.Error) DialogResult.OK){if (txtIdcard.Text )//如果没有输入ID卡号txtIdcard.Focus();//则光标处在输入ID卡号的文本框if (txtName.Text )//如果没有输入员工姓名txtName.Focus();//则光标处在输入员工姓名的文本框if (txtIdcard.Text txtName.Text )//如果都没输入数据txtIdcard.Focus();//则光标处在输入ID卡号的文本框}}else//如果输入了数据{if (txtIdcard.Text.Trim().Length ! 8)//如果输入的ID卡号不是8位{//弹出警告信息if (MessageBox.Show(ID卡号必须为8位, 警告, MessageBoxButtons.OK, MessageBoxIcon.Error) DialogResult.OK){txtIdcard.Text ;//清空输入ID卡号的文本框txtIdcard.Focus();//让光标处在输入ID卡号的文本框上}}else//如果输入的ID卡号为8位{//实例化OleDbConnection对象connew OleDbConnection(ProviderMicrosoft.Jet.OLEDB.4.0;Data source DataPath);con.Open();//打开连接//实例化OleDbCommand对象cmd new OleDbCommand(select count(*) from tb_UserInfo where CardIDtxtIdcard.Text.Trim(), con);int flag Convert.ToInt32(cmd.ExecuteScalar());//判断是否已经添加过此ID卡号if (flag 0)//如果大于0则说明已经添加过{//弹出警告信息if (MessageBox.Show(ID卡号已经添加过了, 警告, MessageBoxButtons.OK, MessageBoxIcon.Error) DialogResult.OK){button2_Click(sender, e);//清空输入ID卡号和员工姓名的文本框}}else//如果小于0说明没有添加过{//实例化OleDbCommand对象cmd new OleDbCommand(insert into tb_UserInfo(CardID,UName,USex,UDep) values ( txtIdcard.Text.Trim() , txtName.Text.Trim() , cbbsex.Text.Trim() , cbbdep.Text.Trim() ), con);int k cmd.ExecuteNonQuery();//执行insert语句将输入的信息添加到数据库中if (k 0)//如果大于0则操作成功{//弹出提示信息if (MessageBox.Show(添加成功, 提示, MessageBoxButtons.OK, MessageBoxIcon.Information) DialogResult.OK){button2_Click(sender, e);//清空输入ID卡号和员工姓名的文本框}}}con.Close();//关闭数据库连接}}}private void txtIdcard_KeyPress(object sender, KeyPressEventArgs e){if (!(e.KeyChar 9 e.KeyChar 0) e.KeyChar ! \r e.KeyChar ! \b){e.Handled true;}}}}该实例注释完善便于阅读读者还可以根据自身需求改善代码或者添加新的功能以满足自身应用的个性化需求。
相关文章：
