using System;

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 userid=@userid";
        public static string SelectUserByName="select * from users where username=@username";
        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=?";
        
        /*-----------------End-----------------------*/

    }
}