//设置默认笔记本
public void setDefault(int notebook_no)
{
string sql = "UPDATE `notebook` SET `notebook_default`='0' WHERE `notebook_default`='1';";
string sql1 = "UPDATE `notebook` SET `notebook_default`='1' WHERE `notebook_no`=" + notebook_no + ";";
MysqlBase mysqlbase = new MysqlBase();
mysqlbase.execute(sql);
mysqlbase.execute(sql1);
}
//删除笔记本
public void delete_notebook(int notebook_no)
{
string sql = "DELETE FROM `notebook` WHERE (`notebook_no`='" + notebook_no + "');";
string sql1 = "DELETE FROM `note` WHERE (`notebook_no`='" + notebook_no + "')";
//实例化一个mysql连接基本对象,然后执行
MysqlBase mysqlbase = new MysqlBase();
mysqlbase.execute(sql);
mysqlbase.execute(sql1);
}
//新建笔记
public void newnote(string notename, DateTime createtime, DateTime modifytime, int hasdelete, int notebook, string text, string content, int favourite)
{
string sql = "INSERT INTO `note` (`note_name`,`note_create_time`, `note_modify_time`, `note_has_delete`, `notebook_no`, `note_text`, `note_content`, `note_favourite`) VALUES ('" + notename + "','" + createtime + "','" + modifytime + "','" + hasdelete + "','" + notebook + "','" + text + "','" + content + "','" + favourite + "');";
MysqlBase mysqlbase = new MysqlBase();
mysqlbase.execute(sql);
}
//重命名
public void renameNotebook(int notebook_no, string new_notebook_name)
{
string sql = "UPDATE `notebook` SET `notebook_name`='" + new_notebook_name + "' WHERE (`notebook_no`='" + notebook_no + "');";
Console.WriteLine(sql);
MysqlBase mysqlbase = new MysqlBase();
mysqlbase.execute(sql);
}
//新建笔记本
public void create_notebook(string notebook_name)
{
//构建创建笔记本的sql语句
string sql = "INSERT INTO `notebook` (`notebook_name`, `notebook_default`) VALUES ('" + notebook_name + "','0')";
//实例化一个mysql连接基本对象,然后执行
MysqlBase mysqlbase = new MysqlBase();
mysqlbase.execute(sql);
}