本文实例讲述了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"> <input type="reset" value="全部重写" name="B2"> </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" /> <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" /> <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简单添加,查询功能代码】相关文章：
★ JSP技术简介
★ JSP一句话后门