(1)前言
我们做编程的人员,是必须得和数据打交道,和数据打交道,就必须有数据查询的功能,有数据查询的功能,就少不了模糊查找这个共能的模块,我所用的数据库是Mysql,废话不多说了,请看下文。
(2)数据库的设计
(3) Model中的login实体类
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace Model
{
/// <summary>
/// login的实体类
/// </summary>
public class login
{
/// <summary>
/// 用户的ID
/// </summary>
public string UserId { get; set; }
/// <summary>
/// 用户名
/// </summary>
public string UserName { get; set; }
/// <summary>
/// 用户的密码
/// </summary>
public string Password { get; set; }
/// <summary>
/// 用于测试
/// </summary>
public string Msg { get; set; }
}
}
(3)UI前端的设计代码
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Select.aspx.cs" Inherits="Ajax.Select" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:TextBox ID="txtSelect" runat="server"></asp:TextBox>
<asp:Button ID="btnSelect" runat="server" Text="Button" OnClick="btnSelect_Click" />
<br />
<br />
<asp:GridView ID="GridView1" runat="server"></asp:GridView>
</div>
</form>
</body>
</html>
(4)前端设计的效果
(5)UI端的后台代码
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Data;
using System.Web.UI.WebControls;
using Model;
using BLL;
using MySql.Data.MySqlClient;
namespace Ajax
{
public partial class Select : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
select();
}
//SelectBLL cb = new SelectBLL();
//login login = new login();
protected void btnSelect_Click(object sender, EventArgs e)
{
//调用select的方法显示数据
select();
}
/// <summary>
/// GridView1控件数据显示的方法
/// </summary>
public void select()
{
string strCon = "Database=login;DataSource=localhost;Port=3306;UserId=root;Password=;Charset=utf8;TreatTinyAsBoolean=false;Allow User Variables=True;";
MySqlConnection mysqlcon = new MySqlConnection(strCon);
string mysqlStr = "select * from login where UserName like'%" + txtSelect.Text.ToString().Trim() + "%' or Password like '%" + txtSelect.Text.ToString().Trim() + "%' or UserId like '%"+txtSelect.Text.ToString().Trim()+"%'";
MySqlCommand cmd = new MySqlCommand(mysqlStr, mysqlcon);
MySqlDataAdapter sda = new MySqlDataAdapter();
DataSet ds = new DataSet();
sda.SelectCommand = cmd;
sda.Fill(ds, "login");
//绑定GridView1控件
GridView1.DataSource = ds;
GridView1.DataBind();
}
}
}
(6)运行时的效果
(7)简答易懂,希望能够帮助到技术有困惑的编程爱好者,如果觉得可以的话,记得帮我点个赞