phrase.cs

征服ASP.NET 2.0 Ajax 典型应用源码

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
//成语操作类
public class Phrase
{
    private string str;//数据库连接字符串
    public SqlConnection Con;//数据库连接
    public Phrase()
    {
        str = GetConn();//得到数据库连接字符串
        Con = new SqlConnection(str);//数据库连接对象
    }
    protected static string GetConn()
    {
        //数据库的路径
        string path = System.Web.HttpContext.Current.Server.MapPath(System.Web.HttpContext.Current.Request.ApplicationPath);
        //数据库连接字符串
        return "Data Source=.\\SQLEXPRESS;AttachDbFilename=\"" + path + "\\App_Data\\page.mdf\";Integrated Security=True;User Instance=True";
    }
    // 输入查询字符串，返回dataset
    private DataSet GetDS(string sql)
    {
        SqlCommand command = new SqlCommand(sql, Con);//初始化命令对象
        command.CommandText = sql;//赋予语句
        DataSet dt = new DataSet();
        SqlDataAdapter da = new SqlDataAdapter(command);//适配器
        Con.Open();
        da.Fill(dt);//获得数据
        command.Connection.Close();//关闭连接
        return dt;
    }
    //获取数据
    public DataSet GetPhrase(string name)
    {
        return GetDS("SELECT * FROM phrase WHERE [name] LIKE '%" + name + "%'");
    }
    //获取自动完成功能中应该返回的成语名称
    public DataSet GetPhrase2(string name, string count)
    {
        string nameLength = Convert.ToString(name.Length); //输入的长度

        return GetDS("SELECT top " + count + " [name] FROM phrase WHERE left(ltrim([name])," + nameLength + ")='" + name + "'");
    }
    // 执行非查询sql操作
    private void ExecuteSql(string sql)
    {
        Con.Open(); //打开连接
        //命令
        SqlCommand Com = new SqlCommand(sql, Con);
        Com.ExecuteNonQuery();//执行
        Con.Close();//关闭
    }
    //添加
    public void InsertPhrase(string name, string pronunciation, string paraphrase, string derivation, string example)
    {
        //构造插入字符串
        StringBuilder sb = new StringBuilder("insert into phrase(name,pronunciation,paraphrase,derivation,example)values('");
        sb.Append(name + "','" + pronunciation + "','" + paraphrase + "','" + derivation + "','" + example + "') ");
        ExecuteSql(sb.ToString());
    }
}