namespace com.oztime.workshop.codebase.db { /// <summary> /// summary description for dbglobal. /// </summary> public class dbglobal { public dbglobal() { // // todo: add constructor logic here // } public static string dsn="dsn"; /*--------------以下内容与用户类相关----------*/ public static string selectuserbyid="select * from users where [email protected]"; public static string selectuserbyname="select * from users where [email protected]"; public static string addnewuser="insert into users(username,password,usersex,useremail,usertitle) values(@username,@password,@usersex,@useremail,@usertitle)"; public static string selectcurrentuserid="select max(userid) from users"; public static string selectuserbynameandpassword="select * from users where username=? and password=?";