11-24写搜索的后台代码

 protected void Page_Load(object sender, EventArgs e) -----Page_Load中
        {

if (PreviousPage != null)
            {
                TextBox tb = (TextBox)PreviousPage.FindControl("txtsearch");
                string Selectbiaoti = tb.Text;
                string q = Selectbiaoti;

                DataTable tableHelper = SqlHelper.dataset("select * from tbl_right where biaoti like '%" + q + "%", new SqlParameter("tiaoti", Selectbiaoti)).Tables[0];
                for (int i = 0; i < tableHelper.Rows.Count; i++)
                {
                    divselect.InnerHtml  = tableHelper.Rows[i]["biaoti"].ToString() + "</br>" + tableHelper.Rows[i]["data"].ToString() + "</br>" + tableHelper.Rows[i]["date"].ToString() + "\"/>";
                }
            }

}
-----搜索按钮事件

 protected void ImageBtn1_Click1(object sender, ImageClickEventArgs e)
        {
            Session["ss"] = txtsearch.Text;---用session 保存信息
            Response.Redirect("search.aspx");

        }

--search.aspx  页  Page_Load中

protected void Page_Load(object sender, EventArgs e)
        {

            string Selectbiaoti = Session["ss"].ToString();--传过来的信息
            string q = Selectbiaoti;
            DataTable tableHelper = SqlHelper.dataset("select * from tbl_right where biaoti like '%" + q + "%'", new SqlParameter("tiaoti", Selectbiaoti)).Tables[0];
            for (int i = 0; i < tableHelper.Rows.Count; i++)
            {
                divselect.InnerHtml = tableHelper.Rows[i]["biaoti"].ToString() + "</br>" + tableHelper.Rows[i]["data"].ToString() + "</br>" + tableHelper.Rows[i]["date"].ToString() + "\"/>";
            }

        }

 

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
抱歉,由于篇幅和复杂性的原因,我无法在此处提供完整的后台管理系统的代码。但是,我可以给你提供一些示例代码,以帮助你快速入门。 这里是一个使用Spring Boot和MySQL实现的用户管理系统的示例代码: 1. 创建数据库表 ```sql CREATE TABLE users ( id INT PRIMARY KEY AUTO_INCREMENT, username VARCHAR(50) NOT NULL UNIQUE, password VARCHAR(50) NOT NULL, email VARCHAR(50) NOT NULL UNIQUE, enabled BOOL NOT NULL ); ``` 2. 创建实体类 ```java @Entity @Table(name = "users") public class User { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Long id; @Column(nullable = false, unique = true) private String username; @Column(nullable = false) private String password; @Column(nullable = false, unique = true) private String email; @Column(nullable = false) private Boolean enabled; // getter and setter methods } ``` 3. 创建DAO层 ```java @Repository public interface UserRepository extends JpaRepository<User, Long> { User findByUsername(String username); } ``` 4. 创建Service层 ```java @Service public class UserServiceImpl implements UserService { @Autowired private UserRepository userRepository; @Override public User findByUsername(String username) { return userRepository.findByUsername(username); } @Override public void saveUser(User user) { userRepository.save(user); } } ``` 5. 创建Controller层 ```java @RestController @RequestMapping("/api/users") public class UserController { @Autowired private UserService userService; @GetMapping("/{username}") public User getUserByUsername(@PathVariable String username) { return userService.findByUsername(username); } @PostMapping("") public void createUser(@RequestBody User user) { userService.saveUser(user); } } ``` 以上代码仅供参考,如需完整代码请自行搜索或参考相关教程。希望能对你有所帮助!
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值