using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace 数据库test
{
class Program
{
static void Main(string[] args)
{
Console.WriteLine("请输入连接的数据库名:");
while (true)
{
string dbname = Console.ReadLine();
string connstr = "server=.;database=" + dbname + ";Integrated Security=SSPI";
using (SqlConnection conn = new SqlConnection(connstr))//连接数据库
{
try
{
conn.Open();
while (true)
{
Console.WriteLine("请输入操作序号:");
Console.WriteLine("1.查询所有数据");
Console.WriteLine("2.添加数据");
Console.WriteLine("3.修改数据");
Console.WriteLine("4.查看单行数据");
Console.WriteLine("5.删除数据");
Console.WriteLine("6.退出");
string caozuobianhao = Console.ReadLine();
using (SqlCommand cmd = conn.CreateCommand())//SqlCommand输入sql语句
{
if (caozuobianhao == "1")//查询所有数据
{
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("---------------------------------------------------");
string sqlstr = "select * from BrowserType";
DataSet ds = new DataSet();//数据集
SqlDataAdapter da = new SqlDataAdapter(sqlstr,conn);
da.Fill(ds);//填充
DataTable table = ds.Tables[0];//建表
Console.WriteLine("id type comment");
for (int i = 0; i < table.Rows.Count; i++)//遍历行
{
DataRow row = table.Rows[i];
string id = Convert.ToString(row["id"]);
string dbtype = Convert.ToString(row["type"]);
string dbcomment = Convert.ToString(row["comment"]);
Console.WriteLine(id+" "+dbtype+" "+dbcomment);
}
Console.WriteLine("---------------------------------------------------");
Console.WriteLine();
Console.WriteLine();
}
else if (caozuobianhao == "2")
{
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("---------------------------------------------------");
Console.WriteLine("请输入浏览器类型:");
string type = Console.ReadLine();
Console.WriteLine("请输入浏览器类型说明:");
string comment = Console.ReadLine();
cmd.CommandText = "Insert into BrowserType(type,comment) values('" + type + "','" + comment + "')";//插入数据
cmd.ExecuteNonQuery();
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("---------------------------------------------------");
Console.WriteLine("插入成功!");
Console.WriteLine("---------------------------------------------------");
Console.WriteLine();
Console.WriteLine();
}
else if (caozuobianhao == "3")
{
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("---------------------------------------------------");
Console.WriteLine("请输入浏览器编号:");
string id = Console.ReadLine();
cmd.CommandText = "select * from BrowserType where id=" + id;//查询
using (SqlDataReader reader = cmd.ExecuteReader())//单行数据查询
{
if (reader.Read())
{
Console.WriteLine("id type comment");
int dbid = reader.GetInt32(reader.GetOrdinal("id"));//取数据库中的值
string dbtype = reader.GetString(reader.GetOrdinal("type"));
string dbcomment = reader.GetString(reader.GetOrdinal("comment"));
Console.WriteLine(dbid + " " + dbtype + " " + dbcomment);
}
else
{
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("---------------------------------------------------");
Console.WriteLine("编号不存在!");
Console.WriteLine("---------------------------------------------------");
Console.WriteLine();
Console.WriteLine();
continue;
}
}
Console.WriteLine("请输入浏览器类型:");
string type = Console.ReadLine();
Console.WriteLine("请输入浏览器类型说明:");
string comment = Console.ReadLine();
cmd.CommandText = "update BrowserType set type = '" + type + "',comment = '" + comment + "' where ID = " + id;//修改
cmd.ExecuteNonQuery();
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("---------------------------------------------------");
Console.WriteLine("修改成功!");
Console.WriteLine("---------------------------------------------------");
Console.WriteLine();
Console.WriteLine();
}
else if (caozuobianhao == "4")
{
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("---------------------------------------------------");
Console.WriteLine("请输入浏览器编号:");
string id = Console.ReadLine();
cmd.CommandText = "select * from BrowserType where id=" + id;//读取数据库,一种只读模式,只向前的
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
Console.WriteLine("id type comment");
int dbid = reader.GetInt32(reader.GetOrdinal("id"));
string dbtype = reader.GetString(reader.GetOrdinal("type"));
string dbcomment = reader.GetString(reader.GetOrdinal("comment"));
Console.WriteLine(dbid + " " + dbtype + " " + dbcomment);
}
else
{
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("---------------------------------------------------");
Console.WriteLine("查询编号不存在!");
Console.WriteLine("---------------------------------------------------");
Console.WriteLine();
Console.WriteLine();
}
}
}
else if (caozuobianhao == "5")
{
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("---------------------------------------------------");
Console.WriteLine("请输入浏览器编号:");
string id = Console.ReadLine();
cmd.CommandText = "select * from BrowserType where id=" + id;
using (SqlDataReader reader = cmd.ExecuteReader())//单行数据查询
{
if (reader.Read())
{
Console.WriteLine("id type comment");
int dbid = reader.GetInt32(reader.GetOrdinal("id"));
string dbtype = reader.GetString(reader.GetOrdinal("type"));
string dbcomment = reader.GetString(reader.GetOrdinal("comment"));
Console.WriteLine(dbid + " " + dbtype + " " + dbcomment);
}
else
{
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("---------------------------------------------------");
Console.WriteLine("编号不存在!");
Console.WriteLine("---------------------------------------------------");
Console.WriteLine();
Console.WriteLine();
continue;
}
}
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("---------------------------------------------------");
Console.WriteLine("是否删除y/n");
string s = Console.ReadLine();
if (s.Equals("y") || s.Equals("Y"))
{
cmd.CommandText = "delete from BrowserType where id = " + id;//删除
cmd.ExecuteNonQuery();
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("---------------------------------------------------");
Console.WriteLine("删除成功!");
Console.WriteLine("---------------------------------------------------");
Console.WriteLine();
Console.WriteLine();
}
else
{
continue;
}
}
else if (caozuobianhao == "6")
{
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("---------------------------------------------------");
Console.WriteLine("退出成功!");
Console.WriteLine("---------------------------------------------------");
Console.WriteLine();
Console.WriteLine();
break;
}
else
{
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("---------------------------------------------------");
Console.WriteLine("无此编号!");
Console.WriteLine("---------------------------------------------------");
Console.WriteLine();
Console.WriteLine();
continue;
}
}
}
conn.Close();
break;
}
catch (Exception)
{
Console.WriteLine("连接失败!");
Console.WriteLine("请重新输入数据库名:");
}
}
}
Console.ReadKey();
}
}
}
转载于:https://blog.51cto.com/ymj1989/1365055