自定义控件的使用二----DBGlobal.cs部分
点击次数：28 次 发布日期：2008-11-27 01:15:42 作者：源代码网
|
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-----------------------*/ } }<  源代码网供稿. |
