abc.cs

一个留言本的源程序

// C# Document
using System;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
namespace hxt
{

public class mydbclass
{
  private int pagesize=Int32.Parse(ConfigurationSettings.AppSettings["每页显示条数"]);
  private string strconn="provider=microsoft.jet.oledb.4.0;data source="+ConfigurationSettings.AppSettings["数据库路径"];
  private OleDbConnection conn=null;
  private OleDbCommand comm=null;
  public mydbclass()
  {
   conn=new OleDbConnection(strconn);
  }
  public void insertdata(string nicheng,string qq,string youjian,string zhuye,string touxiang,string ip,string biaoti,string liuyan)
  {
   string insertsql="insert into liuyan (nicheng,qq,youjian,zhuye,touxiang,ip,biaoti,liuyan,shijian) values (?,?,?,?,?,?,?,?,?)";
   comm=new OleDbCommand(insertsql,conn);
   comm.Parameters.Add("",OleDbType.VarChar).Value=nicheng;
   comm.Parameters.Add("@qq",OleDbType.VarChar,20).Value=qq;
   comm.Parameters.Add("@youjian",OleDbType.VarChar,50).Value=youjian;
   comm.Parameters.Add("@zhuye",OleDbType.VarChar,30).Value=zhuye;
   comm.Parameters.Add("@touxiang",OleDbType.VarChar,3).Value=touxiang;
   comm.Parameters.Add("@ip",OleDbType.VarChar,20).Value=ip;
   comm.Parameters.Add("@biaoti",OleDbType.VarChar,200).Value=biaoti;
   comm.Parameters.Add("@liuyan",OleDbType.LongVarChar).Value=liuyan;
   comm.Parameters.Add("@shijian",OleDbType.Date).Value=DateTime.Now;
   conn.Open();
   comm.ExecuteNonQuery();
   conn.Close();
  }
  public int gettotalnumber()
  {
    comm=new OleDbCommand("select count(*) from liuyan",conn);
    conn.Open();
	int a= (int)comm.ExecuteScalar();
	conn.Close();
	return a;
  }
  public int gettotalpage(int totalnumber)
  {
   if(totalnumber % pagesize==0)
   return totalnumber/pagesize;
   else
   return totalnumber/pagesize+1;
  }
  public DataTable getcurrentpagedata(int pagenumber)
  {
    comm=new OleDbCommand("select * from liuyan order by shijian desc",conn);
	OleDbDataAdapter da=new OleDbDataAdapter(comm);
	DataSet ds=new DataSet();
	da.Fill(ds,(pagenumber-1)*pagesize,pagesize,"abc");
    return ds.Tables["abc"];
  }
}

}