JSP简单添加,查询功能代码
本文实例讲述了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程序设计有所帮助。
本文地址：https://www.stayed.cn/item/15201
转载请注明出处。
本站部分内容来源于网络,如侵犯到您的权益,请 联系我
我的博客
人生若只如初见，何事秋风悲画扇。
我的标签
随笔档案
- 2024-02(2)
- 2023-06(1)
- 2023-05(1)
- 2023-04(14)
- 2023-03(3)
- 2023-01(6)
- 2022-12(5)
- 2022-11(5)
- 2022-07(2)
- 2022-06(4)
- 2022-05(3)
- 2022-03(1)
- 2021-12(6)
- 2021-11(1)
- 2021-10(3)
- 2021-09(5)
- 2021-07(5)
- 2021-02(2)
- 2021-01(7)
- 2020-12(18)
- 2020-11(14)
- 2020-10(12)
- 2020-09(10)
- 2020-08(22)
- 2020-07(2)
- 2020-06(1)
- 2020-04(5)
- 2020-03(9)
- 2020-02(7)
- 2020-01(9)
- 2019-12(8)
- 2019-11(10)
- 2019-10(11)
- 2019-09(17)
- 2019-08(16)
- 2019-07(6)
- 2019-06(3)
- 2019-04(1)
- 2019-03(8)
- 2019-02(5)
- 2019-01(1)
- 2018-11(2)
- 2018-10(3)
- 2018-09(1)
- 2018-08(3)
- 2018-07(3)
- 2018-06(7)
- 2018-04(4)
- 2018-03(5)
- 2018-02(4)
- 2018-01(22)
- 2017-12(3)
- 2017-11(5)
- 2017-10(15)
- 2017-09(26)
- 2017-08(1)
- 2017-07(3)