JSP程序设计实验指导书 JSP
程序设计实验指导书
适用专业:计算机科学与技术 制定人:梁晟 教研室:
计算机专业教研室
贵阳计算机科学系
2007年9月
实验一
【实验目的】
Netbeans 下 Jsp 编程
(1) (2) (3) (4)
熟悉 Jsp 的语法 掌握 Jsp 开发步骤 熟练掌握 Netbeans 开发环境 开发简单的登录模块
【实验内容: 】 实现简单的用户
登陆功能,不要求连接数据库. 【参考代码: 】 输入以下代码: Index.jsp <%@page contentType="text/html; charset=GBK"%>
Check.jsp <%@ page contentType="text/html; charset=GBK" %> <% String name=request.getParameter("name"); String pass=request.getParameter("pass"); if(name==null)name=""; if(pass==null)pass=""; if(name.equals("jkx")&;&;pass.equals("jkx")) { %>
xml:namespace prefix = jsp />
<% } else { %>
<% } %> Welcome.jsp <%@ page contentType="text/html; charset=GBK" %>
Welcome to China!
Error.jsp <%@ page contentType="text/html; charset=GBK" %>
实验二 实验二 JDBC 编程
【实验目的】 (1) 熟悉 Sqlserver2000 常见操作 (2) 熟悉使用 JDBC 操作数据库 【实验要求】 进行 JDBC 编程,实现数据
查询功能. 【参考代码: 】 编写下列程序调试:
<%@ page contentType="text/html;charset=GB2312" %> <%@ page import="java.sql.*" %> <% Connection con; Statement sql; ResultSet rs; try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } catch(ClassNotFoundException e){} try { con=DriverManager.getConnection("jdbc:odbc:sun","sa",""); sql=con.createStatement(); rs=sql.executeQuery("SELECT * FROM students"); out.print("
"); 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.getInt("数学成绩")+" | "); out.print(""+rs.getInt("英语成绩")+" | "); out.print(""+rs.getInt("物理成绩")+" | "); out.print("
") ; } out.print("
"); con.close();
} catch(SQLException
e1) {} %> Example5_2.jsp: <%@ page contentType="text/html;charset=GB2312" %> <%@ page import="java.sql.*" %> <% Connection con; Statement sql; ResultSet rs; try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } catch(ClassNotFoundException e){} try { con=DriverManager.getConnection("jdbc:odbc:sun","sa",""); sql=con.createStatement(); rs=sql.executeQuery("SELECT * FROM students WHERE 英语成绩 >= 80 "); out.print("
"); out.print(""); out.print(""+""); out.print(" | "+"英语成绩"); out.print(" |
"); while(rs.next()) { out.print(""); out.print(""+rs.getString(2)+" | "); out.print(""+rs.getInt("英语成绩")+" | "); out.print("
") ; } out.print("
"); con.close(); } catch(SQLException e1) {} %> Example5_3.jsp: <%@ page contentType="text/html;charset=GB2312" %> <%@ page import="java.sql.*" %>
<% String name,number; int math,physics,english; Connection con; Statement
sql; ResultSet rs; try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } catch(ClassNot