源码下载地址:
github下载
代码部分:
<%@ 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>
万水千山总是情,微信关注行不行

网友评论:
赞一个
2020-07-24 16:26:24 回复
网友评论:
学习了
2020-07-24 16:26:24 回复