%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %> <%request.setCharacterEncoding("gb2312");%> <%@ include file="conn.jsp"%> <% Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); String dq= request.getParameter("dq"); String sql="select * from engineering where unit like '%"+dq+"%' or unita like '%"+dq+"%' or unitb like '%"+dq+"%' or jianyan like '%"+dq+"%' or certificate like '%"+dq+"%'"; ResultSet rs=stmt.executeQuery(sql); %>
|
|||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||