//设置默认笔记本 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); }