1 using System;
2 using System.Collections.Generic;
3 using System.Linq;
4 using System.Text;
5 using System.Threading.Tasks;
6 using System.Data;
7 using System.Data.SqlClient;
8
9 namespace yy
10 {
11 class Program
12 {
13 public static void Login()
14 {
15 Console.Write("请输入账号：");
16 string name = Console.ReadLine();
17 Console.Write("请输入密码：");
18 string password = Console.ReadLine();
19 SqlConnection lcon = new SqlConnection("server=.;database=xx;uid=sa;pwd=111111");
20 lcon.Open();
21
22 SqlCommand lcmd = lcon.CreateCommand();
23 lcmd.CommandText = "select * from Login where Uid='"+name+"' and Pwd='"+password+"'";
24 SqlDataReader re=lcmd.ExecuteReader();
25 if (re.HasRows){
26 Console.Write("登录成功！"); }
27 else {
28 Console.Write("账号或密码输入不正确！");
29 }
30
31 lcon.Close();
32
33 }
34 public static void _Stu()
35 {
36 Console.WriteLine("**************************操作记录***************************");
37 Console.WriteLine("请选择：0：增加记录 1：修改记录 2：删除记录 3:读取所有记录 4:读取记录");
38 string xz = Console.ReadLine();
39 switch (xz)
40 {
41 case "0": yy.Class1.create();
42 break;
43 case "1": yy.Class1.updateBysid();
44 break;
45 case "2": yy.Class1.deleteBysid();
46 break;
47 case "3": yy.Class1.Read();
48 break;
49 case "4": yy.Class1.Cha();
50 break;
51 default:
52 Console.WriteLine("输入有误！！");
53 break;
54 }
55
56 }
57
58 static void Main(string[] args)
59 {
60
61 // Login();
62
63 _Stu();
64
65
66 Main(args);
67
68 }
69
70 }
71 }
1 using System;
2 using System.Collections.Generic;
3 using System.Linq;
4 using System.Text;
5 using System.Threading.Tasks;
6 using System.Data;
7 using System.Data.SqlClient;
8 namespace yy
9 {
10 class Class1
11 {
12 public static void create()
13 {
14 Console.WriteLine("**************************增加记录***************************");
15 Console.Write("学号：");
16 string sid = Console.ReadLine();
17 Console.Write("姓名：");
18 string sname = Console.ReadLine();
19 Console.Write("性别：");
20 string ssex = Console.ReadLine();
21 Console.Write("班级：");
22 string sclass = Console.ReadLine();
23
24 SqlConnection scon = new SqlConnection("server=.;database=xx;uid=sa;pwd=111111");
25 scon.Open();
26 SqlCommand scmd = new SqlCommand();
27 scmd.Connection = scon;
28 scmd.CommandText = "insert into _Stu values('" + sid + "','" + sname + "','" + ssex + "','" + sclass + "')";
29
30 scmd.ExecuteNonQuery();
31 Console.WriteLine("OK!");
32
33 scon.Close();
34
35
36 }
37
38 public static void updateBysid()
39 {
40 Console.WriteLine("**************************修改记录***************************");
41 Console.Write("学号：");
42 string id = Console.ReadLine();
43 Console.Write("姓名：");
44 string name = Console.ReadLine();
45 Console.Write("性别：");
46 string sex = Console.ReadLine();
47 Console.Write("班级：");
48 string iclass = Console.ReadLine();
49
50 SqlConnection scon = new SqlConnection("server=.;database=xx;uid=sa;pwd=111111");
51 scon.Open();
52 SqlCommand scmd = new SqlCommand();
53 scmd.Connection = scon;
54 scmd.CommandText = "update _Stu set sname='"+name
55 +"',ssex='"+sex+"',sclass='"+iclass+"' where sid='"+id+"'";
56
57 scmd.ExecuteNonQuery();
58 Console.WriteLine("OK!");
59 scon.Close();
60
61
62 }
63 public static void Read()
64 {
65 Console.WriteLine("**************************读取所有记录***************************");
66 SqlConnection rcon = new SqlConnection("server=.;database=xx;uid=sa;pwd=111111");
67 rcon.Open();
68 SqlCommand rcmd = rcon.CreateCommand();
69 rcmd.CommandText = "select * from _Stu";
70 SqlDataReader re = rcmd.ExecuteReader();
71 while (re.Read())
72 {
73 Console.Write(re[0].ToString()+"\t"+re[1].ToString()+"\t"+re[2].ToString()+"\t"+re[3].ToString()+"\n");
74 }
75
76 rcon.Close();
77
78 }
79 public static void Cha()
80 {
81 Console.WriteLine("**************************查询记录***************************");
82 Console.WriteLine("请输入查询条件：0：按学号 1：按姓名 2：按班级 3：按性别 ");
83 string xz = Console.ReadLine();
84 string tj = "";
85 SqlConnection rcon = new SqlConnection("server=.;database=xx;uid=sa;pwd=111111");
86 rcon.Open();
87 SqlCommand rcmd = rcon.CreateCommand();
88
89 switch (xz)
90 {
91 case "0":
92 Console.Write("请输入需要查询的学号：");
93 tj = Console.ReadLine();
94 rcmd.CommandText = "select * from _Stu where sid='"+tj+"'";
95 break;
96 case "1":
97 Console.Write("请输入需要查询的姓名：");
98 tj = Console.ReadLine();
99 rcmd.CommandText = "select * from _Stu where sname='" + tj + "'";
100 break;
101 case "2":
102 Console.Write("请输入需要查询的班级：");
103 tj = Console.ReadLine();
104 rcmd.CommandText = "select * from _Stu where sclass='" + tj + "'";
105 break;
106 case "3":
107 Console.Write("请输入需要查询的性别：");
108 tj = Console.ReadLine();
109 rcmd.CommandText = "select * from _Stu where ssex='" + tj + "'";
110 break;
111 case "4":
112 hh();
113 break;
114 default:
115 Console.Write("别闹！");
116
117 break;
118 }
119
120 SqlDataReader re = rcmd.ExecuteReader();
121 Console.WriteLine("**************************查询结果***************************");
122 while (re.Read())
123 {
124 Console.Write(re[0].ToString() + "\t" + re[1].ToString() + "\t" + re[2].ToString() + "\t" + re[3].ToString() + "\r\n");
125 }
126
127 rcon.Close();
128
129 }
130 public static void hh()
131 {
132
133 }
134 public static void deleteBysid()
135 {
136 Console.WriteLine("**************************删除记录***************************");
137 Console.Write("请选择：0：学号 1：姓名 2：班级 3：性别");
138 string xz = Console.ReadLine();
139 SqlConnection scon=new SqlConnection("server=.;database=xx;uid=sa;pwd=111111");
140 scon.Open();
141 SqlCommand scmd=new SqlCommand();
142 scmd.Connection=scon;
143 string code=" ";
144 switch (xz)
145 {
146 case "0":
147 Console.Write("学号：");
148 string id = Console.ReadLine();
149 code = "delete from _Stu where sid='" + id + "'";
150 break;
151 case "1":
152 Console.Write("姓名：");
153 string name = Console.ReadLine();
154 code = "delete from _Stu where sname='" + name + "'";
155
156 break;
157
158 case "2":
159 Console.Write("班级：");
160 string iclass = Console.ReadLine();
161 code = "delete from _Stu where scalss='" + iclass + "'";
162
163 break;
164
165 case "3":
166 Console.Write("性别：");
167 string sex = Console.ReadLine();
168 code = "delete from _Stu where ssex='" + sex+ "'";
169 break;
170
171 default:
172 Console.WriteLine("有错误!");
173 break;
174 }
175 scmd.CommandText = code;
176 scmd.ExecuteNonQuery();
177 Console.WriteLine("OK!");
178 scon.Close();
179
180
181
182 }
183
184 }
185 }
浙公网安备 33010602011771号