jsp 实现查询功能

要求：

实现查询功能

1.数据库代码

 1 create database mvce;
 2 use mvce;
 3 create table test2(
 4 id int not null identity,   
 5 tname char(10) not null,
 6 tttype char(20) not null,
 7 tatt char(20) not null,
 8 tkfsname char(10) not null,
 9 tcity char(20) not null,
10 taddress char(50) not null,
11 tbeizhu char(50) not null,
12 )
13 ---------------------------------------------------------
14 insert into test2 values('wanke bai','big','black','vanke','changchun','beihu','king')

数据库code

2.数据

po/User.jsp

 1 package po;
 2 
 3 public class User {
 4     int id;
 5     String tname;
 6       String ttype;
 7       String tatt;
 8       String tkfsname;
 9       String tcity;
10       String taddress;
11       String tbeizhu;
12     public User() {
13         super();
14         // TODO Auto-generated constructor stub
15     }
16     
17     public User(int id, String tname, String ttype, String tatt,
18             String tkfsname, String tcity, String taddress, String tbeizhu) {
19         super();
20         this.id = id;
21         this.tname = tname;
22         this.ttype = ttype;
23         this.tatt = tatt;
24         this.tkfsname = tkfsname;
25         this.tcity = tcity;
26         this.taddress = taddress;
27         this.tbeizhu = tbeizhu;
28     }
29     public int getId() {
30         return id;
31     }
32 
33     public void setId(int id) {
34         this.id = id;
35     }
36 
37     public String getTname() {
38         return tname;
39     }
40 
41     public void setTname(String tname) {
42         this.tname = tname;
43     }
44 
45     public String getTtype() {
46         return ttype;
47     }
48 
49     public void setTtype(String ttype) {
50         this.ttype = ttype;
51     }
52 
53     public String getTatt() {
54         return tatt;
55     }
56 
57     public void setTatt(String tatt) {
58