.net教程:自定义控件的使用二----dbglobal.cs部分
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-----------------------*/
}
}<