第6章例题A.docx
《第6章例题A.docx》由会员分享,可在线阅读,更多相关《第6章例题A.docx(61页珍藏版)》请在冰豆网上搜索。
![第6章例题A.docx](https://file1.bdocx.com/fileroot1/2023-6/23/09d130e5-4a01-4ce8-8d39-6dd3c71c3079/09d130e5-4a01-4ce8-8d39-6dd3c71c30791.gif)
第6章例题A
Example6_2.jsp1
Example6_3.jsp4
inquire.jsp4
QueryTag.tag5
Example6_4.jsp7
random.jsp8
RandomQuery.tag9
6.4.3条件查询11
6.4.4排序查询16
6.4.5模糊查询20
6.5更新记录23
6.6添加记录29
6.7删除记录33
第6章JSP中使用数据库(例题)
Example6_1.jsp
<%@pagelanguage="java"import="java.util.*"pageEncoding="GB18030"%>
<%@pageimport="java.sql.*"%>
DOCTYPEHTMLPUBLIC"-//W3C//DTDHTML4.01Transitional//EN">
MyJSP'Example6_1.jsp'startingpage
<%
Connectioncon;
Statementsql;
ResultSetrs;
try
{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
}catch(ClassNotFoundExceptione){
out.print(e);
}
try
{
con=DriverManager.getConnection("jdbc:
sqlserver:
//localhost:
1433;DatabaseName=Warehouse","sa","123456");
sql=con.createStatement();
rs=sql.executeQuery("select*fromproductwhereprice>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("madeTime")+" | ");out.print("
"+rs.getFloat("price")+" | ");out.print("
");
}
out.print("");
out.close();
}catch(SQLExceptione){
out.print(e);
}
%>