完成一個(gè)簡單的基于MVC的數(shù)據(jù)查詢模塊，要求能夠按照name進(jìn)行模糊查詢。
創(chuàng)新互聯(lián)建站是一家集網(wǎng)站建設(shè),肇東企業(yè)網(wǎng)站建設(shè),肇東品牌網(wǎng)站建設(shè),網(wǎng)站定制,肇東網(wǎng)站建設(shè)報(bào)價(jià),網(wǎng)絡(luò)營銷,網(wǎng)絡(luò)優(yōu)化,肇東網(wǎng)站推廣為一體的創(chuàng)新建站企業(yè)，幫助傳統(tǒng)企業(yè)提升企業(yè)形象加強(qiáng)企業(yè)競爭力?？沙浞譂M足這一群體相比中小企業(yè)更為豐富、高端、多元的互聯(lián)網(wǎng)需求。同時(shí)我們時(shí)刻保持專業(yè)、時(shí)尚、前沿，時(shí)刻以成就客戶成長自我，堅(jiān)持不斷學(xué)習(xí)、思考、沉淀、凈化自己，讓我們?yōu)楦嗟钠髽I(yè)打造出實(shí)用型網(wǎng)站。
Index.jsp：
<%@ page import="student.TestBean" %> <%@ page import="java.util.List" %> <%@ page import="java.util.ArrayList" %> <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <% Listlist = (List )request.getAttribute("list"); if(list == null){ list = new ArrayList (); } %> Document
ScoreServlet.java：
重慶分公司
重慶分公司
import student.TestBean;
import student.TestDb;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.sql.SQLException;
import java.util.List;
@WebServlet(name = "/ScoreServlet")
public class ScoreServlet extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String strName = request.getParameter("Name");
if(strName == null)
strName = "";
TestDb testDb = new TestDb();
try {
List list = testDb.findByName(strName);
request.setAttribute("list",list);
request.getRequestDispatcher("index.jsp").forward(request,response);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
TestBean.java：
package student;
public class TestBean {
private int id;
private String name;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
}TestDb.java：
package student;
import student.TestBean;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
public class TestDb {
public List findByName(String Name) throws ClassNotFoundException,SQLException{
List list = new ArrayList();
String url="jdbc:h3:D:/temp/h3/mydb";
Class.forName("org.h3.Driver");
Connection conn = DriverManager.getConnection(url,"sa","");
PreparedStatement pstmt = conn.prepareStatement("select ID,NAME from TEST where name like ?");
pstmt.setString(1,"%"+Name+"%");
ResultSet rs = pstmt.executeQuery(); //執(zhí)行查詢
while(rs.next()){
TestBean record = new TestBean();
record.setId(rs.getInt(1));
record.setName(rs.getString(2));
list.add(record);
}
rs.close();
pstmt.close();
conn.close();
return list;
}
} 以上就是本文的全部內(nèi)容，希望對大家的學(xué)習(xí)有所幫助，也希望大家多多支持創(chuàng)新互聯(lián)。
