JSP模糊查询的问题
更多更新更免费论文网,专业毕业设计论文,课程设计源代码,上机实习报告,实验报告请点击www.lwfree.cn
<% String username=request.getParameter("cx"); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\db.mdb"; Connection con=DriverManager.getConnection(strurl,"","") ; Statement stmt=con.createStatement(); String sql="select * from user where username like '%"+username+"%' "; ResultSet rs=stmt.executeQuery(sql);%><%while(rs.next()){out.println("查询结果∶
");out.println("--------------
");out.println(rs.getString(1));out.println(rs.getString(2));out.println(rs.getString(3));}else{out.println("查询结果∶
");out.println("--------------
");out.println(""+"没有符合条件的记录。。。"+"");}rs.close(); con.close(); stmt.close();%>
