usingSystem.Collections;usingSystem.Collections.Generic;usingUnityEngine;usingMySql.Data.MySqlClient;/*
*文件描述:
*创始人:
*创建时间:
*修改时间:
*版本:1.0
*/publicclassTools{MySqlConnection con =null;//1.连接数据库方法publicMySqlConnectionConncet(){string a ="server=localhost;database=onlineshopping;userid=root;password=root;";
con =newMySqlConnection(a);
con.Open();// Close(con);return con;}//2.增删改方法publicintPublicUpdate(string sql){
con =Conncet();MySqlCommand com =newMySqlCommand(sql, con);int i = com.ExecuteNonQuery();//Close(con);Close();return i;}//3.查询方法publicMySqlDataReaderPublicSelect(string sql){
con =Conncet();MySqlCommand com =newMySqlCommand(sql,con);MySqlDataReader reader = com.ExecuteReader();return reader;}//4.关闭(增删改)publicvoidClose(){if(con!=null){
con.Close();}}//关闭(查询、连接)publicvoidClose(MySqlDataReader reader){if(reader!=null){
reader.Close();}if(con!=null){
con.Close();}}}
publicclassAdminOperation:Tools{//单例privateAdminOperation(){}privatestaticAdminOperation ao =null;publicstaticAdminOperationGetInstance(){if(ao ==null){
ao =newAdminOperation();}return ao;}publicAdminLogin1(string name)//查询管理员是否存在{Admin a =null;string sql ="select name,password from administrator where name='"+ name +"";MySqlDataReader reader =PublicSelect(sql);while(reader.Read()){
a =newAdmin();
a.Name = reader.GetString("name");}Close(reader);//关闭资源return a;}publicintLogin(string name,string password){int a =0;Admin ad =Login1(name);//调用该方法if(ad !=null){string sql ="select name,password from administrator where name='"+ name +"and password='"+ password +"'";
a =PublicUpdate(sql);}return a;}}