JSP数据库应用开发解读.pptVIP

第6章 JSP中使用数据库 主要内容 数据库应用程序设计的过程 1、Type1的驱动程序 2、Type4驱动程序 三、数据库的连接 四、JDBC中的常用接口 2、DriverManager类 3、Connection接口 4、Statement接口 5、ResultSet接口 6.4 查询记录 (2) 处理查询结果 6.4.1 顺序查询 6.4.2 随机查询 Example6_4.jsp 6.4.3 条件查询 在下面的例子5中，用户通过JSP页面Example6_5.jsp输入查询条件，如果按产品号查询，查询条件提交给byNumber.jsp页面；如果按价格页面。该例子中的Tag文件NumberCondition.tag根据产根据价格查询记录。 谢谢！ 结束 Hi, I am Shamim Begum from University of southern california. Today I will present election: an energy efficient and low latency scheduling technique for wireless sensor networks. I collaborated with shaocheng wang, professor bhaskar and professor helmy in electrical engineering department of university of southern california Here is a wireless sensor network of homogenous active sensors with a far away base station. The network is deployed to monitor some phenomenon to detect any abnormalities in the underlying phenomenon. Examples are chemical plant monitoring, machine fault detection etc in which the underlying phenomena exhibits spatio-temporal correlation. For example, all sensors in the small area r measure the same phenomenon in a spatially correlated environment. Now, requirements of such applications depend on the phases of the application. Typically, during normal phase of operation, we expect the network to be energy efficient, however, when some abnormality occur in the phenomenon it is more important to ensure low latency and high responsiveness than energy efficiency.. 如果product表有n个字段，tableMessage就刚好有n行、每行4列。每行分别含有和相应字段有关的信息，信息的次序为：数据库名，数据库扩展名，表名，字段名。例如，product表有4个字段，那么上述tableMessage刚好有4行，每行有4列，如图6-15所示。 price product dbo Warehouse madeTime product dbo Warehouse name product dbo Warehouse number product dbo Warehouse tableMessage对象调用next方法使游标向下移动一行(游标的初始位置在第1行之前)，然后tableMessage调用getXxx方法可以查看该行中列的信息，其中最重要的信息是第4列，该列上的信息为字段的名字。 在下面的例子3中，有一个负责查询数据库的Tag文件，该Tag文件使用JDBC-ODBC桥接器方式连接数据库、查询表。用户通过JSP页面Example6_3.jsp提供的表单输入数据源以及表的名字，并提交给inquire.jsp页面，然后inquire,jsp页面调用Tag文件查询数据库。Tag文件将查询结