本文实例讲述了JSP简单添加,查询功能。分享给大家供大家参考。具体如下:
JSP技术:
public class ISOtoGb2312 { public static String convert( String str ) { try { byte> bytesStr=str.getBytes( "ISO-8859-1" ) ; return new String( bytesStr, "gb2312" ) ; } catch( Exception ex) { return str ; } } }
%@ page contentType="text/html; charset=GB2312" %> html> head> title> 输入数据 /title> /head> body bgcolor="#ffffff"> h1> 请输入数据: /h1> hr> form method="POST" action="insert.jsp"> !--webbot bot="SaveResults" U-File="fpweb:///_private/form_results.txt" S-Format="TEXT/CSV" S-Label-Fields="TRUE" --> p> /p> p> /p> p>img border="0" src="img/cisco.gif" width="70" height="81"> font size="5" color="#0000FF">b>学 号: /b>/font>input type="text" name="id" size="25"> img border="0" src="img/cisco.gif" width="70" height="81"> font size="5" color="#0000FF">b>性 别/b>/font>font size="5" color="#0000FF">b>: /b>/font>input type="text" name="sex" size="24">/p> p>img border="0" src="img/cisco.gif" width="70" height="81"> font size="5" color="#000080">b>姓 名: /b>/font>input type="text" name="name" size="25"> img border="0" src="img/cisco.gif" width="70" height="81"> font size="5" color="#0000FF">b>年 龄: /b>/font>input type="text" name="age" size="24">/p> p>img border="0" src="img/cisco.gif" width="70" height="81"> font size="5" color="#000080">b>地 址: /b>/font>input type="text" name="addr" size="84"> /p> p> /p> p> input type="submit" value="提交" name="B1" style="font-size: 14pt; font-weight: bold"> input type="reset" value="全部重写" name="B2" style="font-size: 14pt; font-weight: bold"> /p> /form> /body> /html>
%@ page contentType="text/html; charset=GB2312" %> %@ page import = "java.sql.*"%> %@ page language = "java"%> %@ page import = "test.ISOtoGb2312"%> html> head> title> 添加数据 /title> /head> body bgcolor="#ffffff"> h1> 接收数据,添加到数据库. /h1> % Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //载入驱动程序类别 Connection con = DriverManager.getConnection("jdbc:odbc:zjyds1"); //建立数据库链接 Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); String strSQL; strSQL = "INSERT INTO tab02(id, name, sex, " + "age, addr) Values (" + ISOtoGb2312.convert( request.getParameter("id")) + "," + ISOtoGb2312.convert( request.getParameter("name")) + "," + ISOtoGb2312.convert( request.getParameter("sex")) + "," + ISOtoGb2312.convert( request.getParameter("age")) + "," + ISOtoGb2312.convert( request.getParameter("addr")) + ")"; stmt.executeUpdate(strSQL); ResultSet rs; //建立ResultSet(结果集)对象 rs = stmt.executeQuery("SELECT * FROM tab02"); //执行SQL语句 %> CENTER> TABLE bgcolor=pink> TR bgcolor=silver> TD>B>编号/B>/TD>TD>B>姓 名 /B>/TD>TD>B>性 别/B>/TD>TD>B> 年 龄/B>/TD>TD>B>地 址/B>/TD> /TR> % //利用while循环将数据表中的记录列出 while (rs.next()) { %> TR bgcolor=white> TD>B>%= rs.getString("id") %>/B>/TD> TD>B>%= rs.getString("name") %>/B>/TD> TD>B>%= rs.getString("sex") %>/B>/TD> TD>B>%= rs.getString("age") %>/B>/TD> TD>B>%= rs.getString("addr") %>/B>/TD> /TR> % } rs.close(); //关闭ResultSet对象 stmt.close(); //关闭Statement对象 con.close(); //关闭Connection对象 %> /TABLE> /CENTER> h3>a href="jsp1.jsp">返回/a>/h3> /body> /html>
jsp1:
%@ page contentType="text/html; charset=GB2312" %> %@ page import="com.borland.internetbeans.*,com.borland.dx.dataset.*,com.borland.dx.sql.dataset.*" %> %@ taglib uri="/internetbeans.tld" prefix="ix" %> %@ taglib uri="http://java.sun.com/jstl/sql" prefix="sql" %> html> head> title> jsp1 /title> /head> jsp:useBean id="jsp1BeanId" scope="session" class="test.Jsp1Bean" /> jsp:setProperty name="jsp1BeanId" property="*" /> body bgcolor="#ff00ff"> h1> JBuilder Generated JSP br> hr> 这是第一次使用JSP技术 !!!----2004/3/1--南昌大学软件学院---- /h1> h3>a href="tmp/page_1.htm">另一页/a>/h3> br> h3>a href="jsp2.jsp">下一页/a>/h3> br> h3>a href="DBBean.jsp">数据库/a>/h3> form method="post"> br>Enter new value : input name="sample">br> br> input type="submit" name="Submit" value="Submit"> input type="reset" value="Reset"> br> Value of Bean property is :jsp:getProperty name="jsp1BeanId" property="sample" /> /form> h3>a href="jsp4.jsp">登录/a>/h3> /body> /html>
Jsp1Bean.java
package test; /*aaaaaaa bbbbbbb ccccccccc*/ /** * p>Title: /p> * p>Description: /p> * p>Copyright: Copyright (c) 2004/p> * p>Company: /p> * @author not attributable * @version 1.0 */ public class Jsp1Bean { private String sample = "Start value"; //Access sample property public String getSample() { return sample; } //Access sample property public void setSample(String newValue) { if (newValue!=null) { sample = newValue; } } }
jsp2:
%@ page contentType="text/html; charset=GB2312" %> %@ page import="java.sql.*" %> %@ page language="java" %> HTML> HEAD> TITLE>顺序取得数据/TITLE> /HEAD> BODY> CENTER> FONT SIZE = 5 COLOR = blue>顺序取得数据/FONT> /CENTER> BR> HR> BR> CENTER> % Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //载入驱动程序类别 Connection con = DriverManager.getConnection("jdbc:odbc:zjyds1"); //建立数据库链接 Statement stmt = con.createStatement(); //建立Statement对象 ResultSet rs; //建立ResultSet(结果集)对象 rs = stmt.executeQuery("SELECT * FROM tab01"); //执行SQL语句 %> TABLE bgcolor=pink> TR bgcolor=silver> TD>B>学 号/B>/TD>TD>B>姓 名 /B>/TD>TD>B>性 别 /B>/TD>TD>B>年 龄 /B>/TD>TD>B>地 址/B>/TD> /TR> % //利用while循环将数据表中的记录列出 while (rs.next()) { %> TR bgcolor=white> TD>B>%= rs.getString("id") %>/B>/TD> TD>B>%= rs.getString("name") %>/B>/TD> TD>B>%= rs.getString("sex") %>/B>/TD> TD>B>%= rs.getString("age") %>/B>/TD> TD>B>%= rs.getString("addr") %>/B>/TD> /TR> % } rs.close(); //关闭ResultSet对象 stmt.close(); //关闭Statement对象 con.close(); //关闭Connection对象 %> /TABLE> /CENTER> /BODY> /HTML>
jsp3:
%@ page contentType="text/html; charset=GB2312" %> html> head> title> jsp3 /title> /head> jsp:useBean id="jsp3BeanId" scope="session" class="test.Jsp3Bean" /> jsp:setProperty name="jsp3BeanId" property="*" /> body bgcolor="#ffffc0"> h1> JBuilder Generated JSP /h1> form method="post"> br>Enter new value : input name="sample">br> br>br> input type="submit" name="Submit" value="Submit"> input type="reset" value="Reset"> br> Value of Bean property is :jsp:getProperty name="jsp3BeanId" property="sample" /> /form> /body> /html>
jsp4:
%@ page contentType="text/html; charset=GB2312" %> html> head> title> 登录 /title> /head> body bgcolor="#ffffc0"> form method="POST" action="jsp6.jsp"> p align="center"> 用户名:input type="text" name="username" size="20">/p> p align="center"> 密 码:input type="password" name="password" size="20">/p> p align="center"> input type="radio" value="manage" checked name="select"> 管理 input type="radio" name="select" value="statistic">统计/p> p align="center">input type="submit" value="登 录" name="login"> input type="reset" value="重 写" name="reset">/p> /form> /body> /html>
jsp6:
%@ page contentType="text/html; charset=GB2312" %> html> head> title> 接收数据 /title> /head> body bgcolor="#ffffff"> % String user,pwd,choice; user=request.getParameter("username"); pwd=request.getParameter("password"); choice=request.getParameter("select"); if(choice.equals("manage")){ //user select manage. %> jsp:forward page="jsp7.jsp"> jsp:param name="username" value="%=user%>"/> jsp:param name="password" value="%=pwd%>"/> /jsp:forward> % }else{ //user select statistic %> jsp:forward page="jsp8.jsp"> jsp:param name="username" value="%=user%>"/> jsp:param name="password" value="%=pwd%>"/> /jsp:forward> % } %> /body> /html>
jsp7:
%@ page contentType="text/html; charset=GB2312" %> html> head> title> jsp7 /title> /head> body bgcolor="#ffffff"> h1> 这是管理页 !!! /h1> br> % String user,pwd; user=request.getParameter("username"); pwd=request.getParameter("password"); %> username is: %=user%>br> password is: %=pwd%>br> /body> /html>
jsp8:
%@ page contentType="text/html; charset=GB2312" %> html> head> title> jsp8 /title> /head> body bgcolor="#ffffff"> h1> 这是统计页 !!! /h1> br> % String user,pwd; //user=request.getParameter("username"); user=new String(request.getParameter("username").getBytes("ISO8859_1")); pwd=request.getParameter("password"); %> username is: %=user%>br> password is: %=pwd%>br> /body> /html>
input.html
HTML> HEAD> TITLE>网页引导/TITLE> /HEAD> BODY> CENTER> FONT SIZE = 5 COLOR = blue>网页引导/FONT> /CENTER> BR> HR> BR> FORM action="sendRedirect.jsp" method=post name=form1> P>姓名 : INPUT name=inputName >/P> P>E-Mail : INPUT name=inputE_Mail >/P> INPUT name=submit type=submit value=送出> /FORM> /BODY> /HTML
sendRedirect.jsp:
%@ page contentType="text/html; charset=GB2312" %> %@ page language="java" %> % String Name = request.getParameter("inputName"); String E_Mail = request.getParameter("inputE_Mail"); if(Name.equals("") || E_Mail.equals(""))//检查Name或E_Mail是否完成资料输入 response.sendRedirect("sendRedirect.html"); //若未完成资料输入则将网页导向sendRedirect.html %> HTML> HEAD> TITLE>网页引导/TITLE> /HEAD> BODY> CENTER> FONT SIZE = 5 COLOR = blue>网页引导/FONT> /CENTER> BR> HR> BR> P>您的大名是: %= Name %> /P> P>E-Mail帐号为: %= E_Mail %> /P> p>a href="../jsp1.jsp">返回/a>/p> /BODY> /HTML>
sendRedirect.html:
HTML> HEAD> TITLE>网页引导/TITLE> /HEAD> BODY> CENTER> FONT SIZE = 5 COLOR = blue>网页引导/FONT> /CENTER> BR> HR> BR> FORM action="sendRedirect.jsp" method=post name=form1> font size=5 color=red> 你输入的信息不完整,请重新输入! /font> br> P>姓名 : INPUT name=inputName >/P> P>E-Mail : INPUT name=inputE_Mail >/P> INPUT name=submit type=submit value=送出> /FORM> /BODY> /HTML>
希望本文所述对大家的JSP程序设计有所帮助。