C#结合数据库实现验证识别ID卡内容的方法
程序员文章站
2024-02-20 23:03:40
本文所述实例为c#结合数据库,来验证所识别的id卡内容,通过本实例代码,用户可以轻松实现对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_keyboard=2,并不能对系统键盘截取,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": flag="0"; 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("provider=microsoft.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对象 con=new oledbconnection("provider=microsoft.jet.oledb.4.0;data source=" + datapath); con.open();//打开连接 //实例化oledbcommand对象 cmd = new oledbcommand("select count(*) from tb_userinfo where cardid='"+txtidcard.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; } } } }
该实例注释完善,便于阅读,读者还可以根据自身需求改善代码,或者添加新的功能以满足自身应用的个性化需求。