第6章例题A.docx

1、第6章例题AExample6_2.jsp 1Example6_3.jsp 4inquire.jsp 4QueryTag.tag 5Example6_4.jsp 7random.jsp 8RandomQuery.tag 96.4.3 条件查询 116.4.4 排序查询 166.4.5模糊查询 206.5 更新记录 236.6 添加记录 296.7 删除记录 33第6章JSP中使用数据库(例题)Example6_1.jsp My JSP Example6_1.jsp starting page 5000); out.print(table border=2); out.print(); out.p

2、rint(+产品号); out.print(+名称); out.print(+生产日期); out.print(+价格); out.print(); while(rs.next() out.print(); out.print(+rs.getString(1)+); out.print(+rs.getString(2)+); out.print(+rs.getDate(madeTime)+); out.print(+rs.getFloat(price)+); out.print(); out.print(); out.close(); catch(SQLException e) out.pri

3、nt(e); % Example6_2.jsp My JSP Example6_1.jsp starting page 5000); out.print(); out.print(); out.print(+产品号) ; out.print(+名称) ; out.print(+生产日期 ) ; out.print(+价格) ; out.print() ; while(rs.next() out.print() ; out. print(+rs.getString(1)+) ; out. print(+rs.getString(2)+) ; out .print(+rs.getDate(made

4、Time)+) ; out .print(+rs.getFloat (price)+) ; out.print () ; out .print () ; con. close() ; catch (SQLException e) out .print (e) ; % 例子3(效果如图6-16所示)图6-16顺序查询Example6_3.jsp My JSP Example6_1.jsp starting page 输入数据源名: 输入表的名字: 输入用户名: (默认是 sa) 输入密码: (默认是123456) inquire.jsp My JSP Example6_1.jsp startin

5、g page inquire:QueryTag dataSource= tableName= user= password=/ 在表查询到记录: QueryTag.tag% StringBuffer result; result=new StringBuffer(); try / Class.forName(sun.jdbc.odbc. JdbcOdbcDriver); Class.forName(com.microsoft.sqlserver.jdbc.SQLServerDriver); catch(Exception e) Connection con; Statement sql; Re

6、sultSet rs; try result.append(); /String uri=jdbc:odbc:+dataSource; /String uri=jdbc:sqlserver:/localhost:1433;DatabaseName=Warehouse; / user=sa; /String password=123; con=DriverManager.getConnection(dataSource,user,password); DatabaseMetaData metadata=con.getMetaData(); ResultSet rs1=metadata.getCo

7、lumns(null,null,tableName,null) ; int 字段个数=0 ; result.append () ; while(rs1.next () 字段个数+; String clumnName=rs1.getString(4); result.append(+clumnName+); result.append(); sql=con.createStatement(); rs=sql.executeQuery(select * from +tableName); while(rs.next() result.append () ; for(int k=1;k=字段个数;k

8、+) result.append (+rs. getString (k) + ) ; result.append () ; result.append () ; con.close() ; catch (SQLException e) result.append (请输入正确的用户名和密码) ; jspContext.setAttribute(queryResult,new String(result); jspContext.setAttribute(biao,tableName);%例子4(效果如图6-17所示)图6-17随机查询 Example6_4.jsp My JSP Example

9、6_1.jsp starting page 随机查询记录. 输入数据库名: 输入表的名字: 输入用户名: (默认是sa) 输入密码:(默认是123) 输入查询的记录数: random.jsp My JSP Example6_1.jsp starting page inquire:RandomQuery databaseName= tableName= user= password= count=/ 在表随机查询到条记录: RandomQuery.tag% Vector vector=new Vector(); StringBuffer result; result=new StringBuff

10、er(); try /Class.forName(com.microsoft.sqlserver.jdbc. SQLServerDriver); /sql 2005 Class.forName(com.microsoft.sqlserver.jdbc.SQLServerDriver); catch(Exception e) Connection con; Statement sql; ResultSet rs; int n=0; try result.append(); /String uri=jdbc:sqlserver:/127.0.0.1:1433:DatabaseName=+datab

11、aseName; String uri=jdbc:sqlserver:/localhost:1433;DatabaseName=+databaseName; con=DriverManager.getConnection(uri,user,password); DatabaseMetaData metadata=con.getMetaData(); ResultSet rs1=metadata.getColumns(null,null,tableName,null); int 字段个数=0 ; result.append () ; while(rs1.next() 字段个数+; String

12、clumnName=rs1.getString(4); result.append(+clumnName+ ) ; result.append () ; sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY); rs=sql.executeQuery(SELECT * FROM +tableName); rs.last(); int rowNumber=rs.getRow(); int number=rowNumber; /获取记录数 for(int i=1;i0) int i=(int) (Math.random()*vector.size() ; /从vector中随机抽取一个元素: int index= (Integer) vector.elementAt (i).intValue () ; rs. absolute (index) ; /游标移到这一行 result.append ( ) ; for(int k=1;k=字段个数; k+) result.append (+rs.getString (k) + ) ;