JSP简单添加,查询功能代码
程序员文章站
2022-05-03 15:34:29
本文实例讲述了jsp简单添加,查询功能。分享给大家供大家参考。具体如下:
jsp技术:
public class isotogb2312
{
public...
本文实例讲述了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程序设计有所帮助。
上一篇: JSP生成WORD文档,EXCEL文档及PDF文档的方法
下一篇: 鲜嫩的龙利鱼的做法有哪些呢