启动方法
public void start ( ) {
Console. WriteLine ( "程序启动了,这是start方法" ) ;
int res = 0 ;
int i = 1 ;
while ( res == 0 && i <= 3 ) {
i++ ;
res = login ( ) ;
if ( res == 1 )
{
while ( true ) {
String choice= runApp ( ) ;
if ( choice. Equals ( "q" ) ) {
break ;
}
}
}
}
Console. WriteLine ( "离开了循环" ) ;
}
登录方法
public bool login ( )
{
bool reaf= false ;
Console. WriteLine ( "登陆功能,被调用的login方法" ) ;
Console. WriteLine ( "请输入用户名:" ) ;
usr_name = Console. ReadLine ( ) ;
Console. WriteLine ( "请输入密码:" ) ;
string pwd = Console. ReadLine ( ) ;
string sql = "select COUNT(*) from QQUser where QQID=" + usr_name + " and PassWord='" + pwd + "';" ;
SqlCommand cmd = new SqlCommand ( sql, connection) ;
connection. Open ( ) ;
string a = cmd. ExecuteScalar ( ) . ToString ( ) ;
Console. WriteLine ( a) ;
connection. Close ( ) ;
if ( a. Equals ( "1" ) )
{
reaf = true ;
}
else
{
reaf = false ;
}
return reaf;
}
显示主菜单
public void showMenu ( ) {
Console. WriteLine ( "功能菜单showmenu运行中..." ) ;
Console. WriteLine ( "1,添加用户" ) ;
Console. WriteLine ( "2,删除用户" ) ;
Console. WriteLine ( "3,修改用户" ) ;
Console. WriteLine ( "4,查询用户" ) ;
Console. WriteLine ( "q,退出程序" ) ;
}
public String getUserChoice ( ) {
Console. WriteLine ( "请输入需要的功能" ) ;
String res = Console. ReadLine ( ) ;
return res;
}
功能启动
public void funcRun ( String choice) {
Console. WriteLine ( "用户输入的内容是" + choice) ;
switch ( choice) {
case "1" :
addData ( ) ;
break ;
case "2" :
Console. WriteLine ( "22222" ) ;
break ;
case "3" :
Console. WriteLine ( "3333" ) ;
break ;
case "4" :
Console. WriteLine ( "4444" ) ;
break ;
case "q" :
Console. WriteLine ( "退出程序" ) ;
break ;
default :
Console. WriteLine ( "非法输入" ) ;
break ;
}
}
查询方法
public void select_from ( ) {
string sql = "select * from BaseInfo where qqid=" + usr_name + ";" ;
string sql2 = "select count(*) from BaseInfo where qqid=" + usr_name + ";" ;
connection. Open ( ) ;
SqlCommand cmd2 = new SqlCommand ( sql2, connection) ;
int a = Convert. ToInt32 ( cmd2. ExecuteScalar ( ) . ToString ( ) ) ;
if ( a > 0 )
{
SqlCommand cmd = new SqlCommand ( sql, connection) ;
SqlDataReader sdr = cmd. ExecuteReader ( ) ;
while ( sdr. Read ( ) )
{
Console. WriteLine ( "QQ号:" + sdr[ "qqid" ] ) ;
Console. WriteLine ( "昵称:" + sdr[ "nickname" ] ) ;
Console. WriteLine ( "年龄:" + sdr[ "age" ] ) ;
}
}
else
{
Console. WriteLine ( "你没有好友" ) ;
}
connection. Close ( ) ;
}