using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.OleDb;
using System.Data.SqlClient;
using System.Threading.Tasks;
namespace rch
{
class Program
{
static void Main(string[] args)
{
Console.WriteLine("我的日程管理");
Console.WriteLine("===================================================================");
Console.WriteLine("1 查看日程");
Console.WriteLine("2 录入日程");
Console.WriteLine("3 删除日程");
Console.WriteLine("===================================================================");
Console.WriteLine("按序号选择功能,0号键退出");
Console.WriteLine("===================================================================");
while (true)
{
int index = int.Parse(Console.ReadLine());
if (index==1)
{
getrch();
}
if (index == 2)
{
addrch();
}
if (index ==3)
{
delrch();
}
if (index ==0)
{
Console.WriteLine("退出系统");
}
}
Console.ReadKey();
}
private static void getrch()
{
string connstr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Environment.CurrentDirectory + @"/rch.mdb";
OleDbConnection conn = new OleDbConnection(connstr);
conn.Open();
string sql = "select * from rch";
OleDbCommand command = new OleDbCommand(sql, conn);
OleDbDataReader reader = command.ExecuteReader();
try
{
while (reader.Read())
{
for (int i = 0; i < reader.FieldCount;i++ )
{
Console.Write("{0} ", reader[i]);
}
Console.WriteLine();
}
}
finally
{
reader.Close();
conn.Close();
}
}
private static void addrch()
{
int nResult=0;
string lines="";
string rchname="",rchtime="",address="",content="";
string connstr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Environment.CurrentDirectory + @"/rch.mdb";
OleDbConnection conn = new OleDbConnection(connstr);
conn.Open();
Console.Write("请输入日程:");
lines=Console.ReadLine();
try
{
string[] param=lines.Split(',');
rchname=param[0];
rchtime = param[1];
address = param[2];
content = param[3];
string sql = "insert into rch (rchname, rchtime, address, content) values ('" + rchname +
"','" + rchtime + "','"+ address + "','"+ content + "')";
OleDbCommand command = new OleDbCommand(sql, conn);
nResult = command.ExecuteNonQuery();
}
catch(System.Exception e)
{
Console.WriteLine(e.ToString());
}
finally
{
conn.Close();
}
}
private static void delrch()
{
int nResult=0;
string lines="";
int id=0;
string connstr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Environment.CurrentDirectory + @"/rch.mdb";
OleDbConnection conn = new OleDbConnection(connstr);
conn.Open();
Console.Write("请输入要删除日程的ID:");
lines=Console.ReadLine();
try
{
id = Convert.ToInt32(lines);
string sql = "delete from rch where ID=" + id;
OleDbCommand command = new OleDbCommand(sql, conn);
nResult = command.ExecuteNonQuery();
}
catch(System.Exception e)
{
Console.WriteLine(e.ToString());
}
finally
{
conn.Close();
}
}
}
}
数据库使用Access,见此;
https://blog.csdn.net/bcbobo21cn/article/details/109234496
构建以后如下;
运行情况;
现在一个简单版本控制台循环的日程管理程序可用;可查看,添加,删除日程;