show_leave.aspx.cs

(开头部分) 3KB

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;

public partial class show_leave : System.Web.UI.Page
{
    OleDbConnection con;
    protected void Page_Load(object sender, EventArgs e)
    {
        string str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("DB_51Aspx/db.mdb");
        con = new OleDbConnection(str);
       
        try
        {
            con.Open();
            if (!IsPostBack)
            {
                bind();
                string ID = Request.QueryString["id"];
                string sqlstr = "update [leave_word] set [Hits] = [Hits] + 1 where [id] =" + ID;
                OleDbCommand cmd = new OleDbCommand(sqlstr, con);
                cmd.ExecuteNonQuery();
                con.Close();
            }
        }
        catch
        {
            Response.Write("<script>alert('链接数据库失败!')</script>");
        }

    }
    public void bind()
    {
        if (Request.QueryString["id"] == null)
        {
            Response.Redirect("msg.aspx?type=4");
            return;
        }
        string ID = Request.QueryString["id"];


        string re_SqlStr = "select count(*) from [restore] where [leave_word_id]=" + ID;
        OleDbCommand re_cmd = new OleDbCommand(re_SqlStr, con);
        OleDbDataReader re_dr = re_cmd.ExecuteReader();
        re_dr.Read();
        re_nb.Text = re_dr[0].ToString();


        string SqlStr = "select 'a'&id as nid, leave_word_name as title,leave_word_content,leave_time as Ttime,author as UserName from [leave_word] where [id]=" + ID;
        SqlStr += " Union select 'b'&id as nid, '' as title,restore_content,restore_time as Ttime,restore_user as UserName  from [restore] where [leave_word_id]=" + ID;

        OleDbDataAdapter gr_da = new OleDbDataAdapter(SqlStr, con);
后面还有 45 行代码,解锁后查看完整代码

24 小时内免费解锁 3 个项目,之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用,每次 10 算力,解读结果公开显示在下面。

还没有人解读过这个文件。