public static int SaveComment(string comment, string tag, string type) { string sql = "insert into NT_Ai_Comment(comment, keyword, type) " + "values('" + comment + "', '" + tag + "', '" + type + "')"; int k = DBLib.GetDefault().ExecuteCommand(sql); return(k); }
private void Init() { string sql = "select count(*) from NT_News"; DataTable data = DBLib.GetDefault().GetTable(sql); if (data.Rows.Count > 0) { label1.Text = "总共" + (int.Parse(data.Rows[0][0].ToString()) / 10) + "页数/1页10条"; //textBox1.Text = page.ToString(); } }
private void button1_Click(object sender, EventArgs e) { try { page = int.Parse(textBox1.Text); string sql = "select tags from nt_news order by id desc offset " + ((page - 1) * 10) + " row fetch next 10 rows only"; DataTable data1 = DBLib.GetDefault().GetTable(sql); List <string> taglist = new List <string>(); string tag = ""; for (int i = 0; i < data1.Rows.Count; i++) { string[] ts = data1.Rows[i][0].ToString().Split(' '); for (int w = 0; w < ts.Length; w++) { tag += ts[w] + " "; taglist.Add(ts[w]); } } this.listView1.View = View.Details; this.listView1.Columns.Add("#", 100, HorizontalAlignment.Left); this.listView1.Columns.Add("关键词", 100, HorizontalAlignment.Center); int index = 1; foreach (string l in taglist) { var item = new ListViewItem(); item.Text = index.ToString(); item.SubItems.Add(l); listView1.BeginUpdate(); listView1.Items.Add(item); listView1.EndUpdate(); index++; } string word = service.participle(tag.Replace(" ", "").Trim()); richTextBox2.Text = word; } catch (Exception E) { } }