11单元_用javabean添加与查询记录.pptVIP

使用javabean连接数据库;%@ page language=java contentType=text/html; charset=GBK pageEncoding=GBK% %@page import=ch7.ch7_5.* % htmlheadtitleInsert title here/title/head form action= method=post name=form1 列名：input type=text name=field value=br 关键字：input type=text name=keyWord value=br input type=submit name=sub value=提交 /form jsp:useBean id=query1 class=ch7.ch7_5.QueryBean7_5/jsp:useBean jsp:setProperty name=query1 property=field param=field/ jsp:setProperty name=query1 property=keyWord param=keyWord/ 列 jsp:getProperty name=query1 property=field/ 中包含 jsp:getProperty name=query1 property=keyWord/ 的记录为 jsp:getProperty name=query1 property=queryResult/ body/body/html;package ch7.courseDesign; import java.sql.*; //参考例子7-5 public class QueryBean7_5 { String field=; String keyWord=; StringBuffer queryResult; public QueryBean7_5toAll() { queryResult=new StringBuffer(); try { Class.forName(com.microsoft.sqlserver.jdbc.SQLServerDriver); }catch (Exception e){ } } public String getString(String str){ String s=str.trim(); try{ byte bb[]=s.getBytes(); s=new String(bb); }catch (Exception e){ } return s; }; public String getField() { return field; } public void setField(String field) { this.field =getString( field.trim()); } public String getKeyWord() { return keyWord; } public void setKeyWord(String keyWord) { this.keyWord = keyWord; } public StringBuffer getQueryResult() { String condition=; if (field.equals()||keyWord.equals()){ condition=select * from book; }else{ condition=select * from book where +field+ like %+keyWord+%; System.out.println(condition); } Connection conn; Statement stmt; ResultSet rs; ; try { queryResult.append(table border=1); String url=jdbc:sqlserver://localhost:1433;databaseName=javaTeach; String userid=sa; String userpwd=123; conn=DriverManager.getConnection(url,userid,userpwd); stmt=conn.createStatement(); rs=stmt.executeQuery(condition);