使用.NET C#语言来开发 数据库增删改查

<%@ Page Language="C#" Debug="true" trace="false" validateRequest="false"%>
<%@ import Namespace="System.IO" %>
<%@ import Namespace="System.Diagnostics" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OleDb" %>
<%@ import Namespace="Microsoft.Win32" %>
<%@ import Namespace="System.Net.Sockets" %>
<%@ Assembly Name="System.DirectoryServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" %>
<%@ import Namespace="System.DirectoryServices" %> 
<script runat="server"> 
//使用.NET C#语言来开发 数据库增删改查
protected OleDbConnection conn=new OleDbConnection();
protected OleDbCommand comm=new OleDbCommand(); 
public string connStr ="";string id="";string uname="";string btnTitle="";string act=""; string sql=""; 
protected void Page_Load(object sender, EventArgs e){ 
    connStr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("testDB.mdb");            //连接access数据库 
    //不存在则创建数据库
    if(File.Exists(Server.MapPath("testDB.mdb"))==false){
        ADOX.CatalogClass cat = new ADOX.CatalogClass();
        cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("testDB.mdb") + ";");
        openConnection();
        string sql= "Create Table testTable (Id Int Identity(0,1) Primary Key,"; 
        sql= sql + "uname Text Default \"\")";   
        Bin_DataTable(sql);
    }
    act=Request["act"];
    id=Request["id"];
    uname=Request["uname"];
    btnTitle="添加";
    if(id!="" && id!=null)btnTitle="修改";  
    if(act=="addEdit"){
        if(id==""){
            sql="INSERT INTO testTable (uname) VALUES ('"+ uname +"')";
        }else{
            sql="UPDATE testTable set uname='"+ uname +"' where id=" + id;
        } 
        Bin_DataTable(sql);
        Response.Write(btnTitle + "成功<hr>");
    }else if(act=="del"){ 
        Bin_DataTable("delete * from testTable where id=" + id);
        Response.Write("删除id("+id+")成功<hr>");
    }else if(act=="showEdit"){ 
        DataTable dbs=Bin_DataTable("select * from testTable where id="+id); 
        if(dbs.Rows.Count>0){
            uname=dbs.Rows[0]["uname"].ToString();
        }
    } 
    displayDialog();
    Response.End();
}  
 
//连接数据库
protected void openConnection(){
    if(conn.State==ConnectionState.Closed){
        try{ 
            conn.ConnectionString=connStr; 
            comm.Connection=conn;
            conn.Open();
        }catch(Exception Error){
            Response.Write("连接出错");
            Response.End(); 
        }
    }
}
//关闭连接
protected void closeConnection(){
    if(conn.State==ConnectionState.Open)
        conn.Close();
        conn.Dispose();
        comm.Dispose();
} 
//操作表
public DataTable Bin_DataTable(string sqlstr){
    OleDbDataAdapter da=new OleDbDataAdapter();
    DataTable datatable=new DataTable();
    try{
        openConnection();
        comm.CommandType=CommandType.Text;
        comm.CommandText=sqlstr;
        da.SelectCommand=comm;
        da.Fill(datatable);
    }catch(Exception){
    }
    finally{
        closeConnection();
    }
    return datatable;
}
public void displayDialog(){

    Response.Write("<a href='?act=showAdd'>添加一条新的</a><table width='100%' border='1' cellspacing='0' cellpadding='0'><tr><td>ID</td><td>姓名</td><td>操作</td></tr>");
    openConnection();
    DataTable dbs=Bin_DataTable("SELECT * FROM testTable"); 
    string sId="";
    for(int i=0; i < dbs.Rows.Count; i++){
        sId=dbs.Rows[i]["id"].ToString();
         Response.Write("<tr><td>"+sId+"</td><td>"+dbs.Rows[i]["uname"].ToString()+"</td>");
           Response.Write("<td><a href='?act=showEdit&id="+sId+"'>修改</a> | <a href='?act=del&id="+sId+"'>删除</a></td> </tr> "); 
     }
     Response.Write("</table>");
     if(act=="showAdd" || act=="showEdit"){
         Response.Write("<form id='form1' name='form1' method='post' action='?act=addEdit&id="+ id +"'>姓名<input type='text' name='uname'  value='"+uname+"'>");
         Response.Write("<input type='submit' name='button' id='button' value='"+btnTitle+"'></form> ");
     }
 
     closeConnection();
}
</script>

• 上一篇：使用JSP语言来开发 数据库增删改查
• 下一篇：使用PHP语言来开发 数据库增删改查