本文实例讲述了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="/UploadFiles/2021-04-02/cisco.gif"><%@ 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> </HTMLsendRedirect.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程序设计有所帮助。
华山资源网 Design By www.eoogi.com
广告合作:本站广告合作请联系QQ:858582 申请时备注:广告合作(否则不回)
免责声明:本站资源来自互联网收集,仅供用于学习和交流,请遵循相关法律法规,本站一切资源不代表本站立场,如有侵权、后门、不妥请联系本站删除!
免责声明:本站资源来自互联网收集,仅供用于学习和交流,请遵循相关法律法规,本站一切资源不代表本站立场,如有侵权、后门、不妥请联系本站删除!
华山资源网 Design By www.eoogi.com
暂无评论...
更新日志
2024年12月23日
2024年12月23日
- 小骆驼-《草原狼2(蓝光CD)》[原抓WAV+CUE]
- 群星《欢迎来到我身边 电影原声专辑》[320K/MP3][105.02MB]
- 群星《欢迎来到我身边 电影原声专辑》[FLAC/分轨][480.9MB]
- 雷婷《梦里蓝天HQⅡ》 2023头版限量编号低速原抓[WAV+CUE][463M]
- 群星《2024好听新歌42》AI调整音效【WAV分轨】
- 王思雨-《思念陪着鸿雁飞》WAV
- 王思雨《喜马拉雅HQ》头版限量编号[WAV+CUE]
- 李健《无时无刻》[WAV+CUE][590M]
- 陈奕迅《酝酿》[WAV分轨][502M]
- 卓依婷《化蝶》2CD[WAV+CUE][1.1G]
- 群星《吉他王(黑胶CD)》[WAV+CUE]
- 齐秦《穿乐(穿越)》[WAV+CUE]
- 发烧珍品《数位CD音响测试-动向效果(九)》【WAV+CUE】
- 邝美云《邝美云精装歌集》[DSF][1.6G]
- 吕方《爱一回伤一回》[WAV+CUE][454M]