JSP简单添加,查询功能代码
本文实例讲述了JSP简单添加,查询功能。分享给大家供大家参考。具体如下：
JSP技术:
publicclassISOtoGb2312
{
publicstaticStringconvert(Stringstr)
{
try
{
byte<>bytesStr=str.getBytes("ISO-8859-1");
returnnewString(bytesStr,"gb2312");
}
catch(Exceptionex)
{
returnstr;
}
}
}
<%@pagecontentType="text/html;charset=GB2312"%> <html> <head> <title> 输入数据 </title> </head> <bodybgcolor="#ffffff"> <h1> 请输入数据: </h1> <hr> <formmethod="POST"action="insert.jsp"> <!--webbotbot="SaveResults"U-File="fpweb:///_private/form_results.txt" S-Format="TEXT/CSV"S-Label-Fields="TRUE"--> <p></p> <p></p> <p><imgborder="0"src="img/cisco.gif"width="70"height="81"> <fontsize="5"color="#0000FF"><b>学号: </b></font><inputtype="text"name="id"size="25"><imgborder="0"src="img/cisco.gif"width="70"height="81"> <fontsize="5"color="#0000FF"><b>性别</b></font><fontsize="5"color="#0000FF"><b>: </b></font><inputtype="text"name="sex"size="24"></p> <p><imgborder="0"src="img/cisco.gif"width="70"height="81"> <fontsize="5"color="#000080"><b>姓名: </b></font><inputtype="text"name="name"size="25"><imgborder="0"src="img/cisco.gif"width="70"height="81"> <fontsize="5"color="#0000FF"><b>年龄:</b></font><inputtype="text"name="age"size="24"></p> <p><imgborder="0"src="img/cisco.gif"width="70"height="81"> <fontsize="5"color="#000080"><b>地址: </b></font><inputtype="text"name="addr"size="84"></p> <p></p> <p> <inputtype="submit"value="提交"name="B1"style="font-size:14pt;font-weight:bold"> <inputtype="reset"value="全部重写"name="B2"style="font-size:14pt;font-weight:bold"> </p> </form> </body> </html>
<%@pagecontentType="text/html;charset=GB2312"%>
<%@pageimport="java.sql.*"%>
<%@pagelanguage="java"%>
<%@pageimport="test.ISOtoGb2312"%>
<html>
<head>
<title>
添加数据
</title>
</head>
<bodybgcolor="#ffffff">
<h1>
接收数据,添加到数据库.
</h1>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//载入驱动程序类别
Connectioncon=DriverManager.getConnection("jdbc:odbc:zjyds1");//建立数据库链接
Statementstmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
StringstrSQL;
strSQL="INSERTINTOtab02(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);
ResultSetrs;//建立ResultSet(结果集)对象
rs=stmt.executeQuery("SELECT*FROMtab02");//执行SQL语句
%>
<CENTER>
<TABLEbgcolor=pink>
<TRbgcolor=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())
{
%>
<TRbgcolor=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><ahref="jsp1.jsp">返回</a></h3>
</body>
</html>
jsp1:
<%@pagecontentType="text/html;charset=GB2312"%> <%@pageimport="com.borland.internetbeans.*,com.borland.dx.dataset.*,com.borland.dx.sql.dataset.*"%> <%@tagliburi="/internetbeans.tld"prefix="ix"%> <%@tagliburi="http://java.sun.com/jstl/sql"prefix="sql"%> <html> <head> <title> jsp1 </title> </head> <jsp:useBeanid="jsp1BeanId"scope="session"class="test.Jsp1Bean"/> <jsp:setPropertyname="jsp1BeanId"property="*"/> <bodybgcolor="#ff00ff"> <h1> JBuilderGeneratedJSP <br> <hr> 这是第一次使用JSP技术!!!----2004/3/1--南昌大学软件学院---- </h1> <h3><ahref="tmp/page_1.htm">另一页</a></h3> <br> <h3><ahref="jsp2.jsp">下一页</a></h3> <br> <h3><ahref="DBBean.jsp">数据库</a></h3> <formmethod="post"> <br>Enternewvalue:<inputname="sample"><br> <br> <inputtype="submit"name="Submit"value="Submit"> <inputtype="reset"value="Reset"> <br> ValueofBeanpropertyis:<jsp:getPropertyname="jsp1BeanId"property="sample"/> </form> <h3><ahref="jsp4.jsp">登录</a></h3> </body> </html>
Jsp1Bean.java
packagetest;
/*aaaaaaa
bbbbbbb
ccccccccc*/
/**
*<p>Title:</p>
*<p>Description:</p>
*<p>Copyright:Copyright(c)2004</p>
*<p>Company:</p>
*@authornotattributable
*@version1.0
*/
publicclassJsp1Bean{
privateStringsample="Startvalue";
//Accesssampleproperty
publicStringgetSample(){
returnsample;
}
//Accesssampleproperty
publicvoidsetSample(StringnewValue){
if(newValue!=null){
sample=newValue;
}
}
}
jsp2:
<%@pagecontentType="text/html;charset=GB2312"%>
<%@pageimport="java.sql.*"%>
<%@pagelanguage="java"%>
<HTML>
<HEAD>
<TITLE>顺序取得数据</TITLE>
</HEAD>
<BODY>
<CENTER>
<FONTSIZE=5COLOR=blue>顺序取得数据</FONT>
</CENTER>
<BR>
<HR>
<BR>
<CENTER>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//载入驱动程序类别
Connectioncon=DriverManager.getConnection("jdbc:odbc:zjyds1");//建立数据库链接
Statementstmt=con.createStatement();//建立Statement对象
ResultSetrs;//建立ResultSet(结果集)对象
rs=stmt.executeQuery("SELECT*FROMtab01");//执行SQL语句
%>
<TABLEbgcolor=pink>
<TRbgcolor=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())
{
%>
<TRbgcolor=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:
<%@pagecontentType="text/html;charset=GB2312"%> <html> <head> <title> jsp3 </title> </head> <jsp:useBeanid="jsp3BeanId"scope="session"class="test.Jsp3Bean"/> <jsp:setPropertyname="jsp3BeanId"property="*"/> <bodybgcolor="#ffffc0"> <h1> JBuilderGeneratedJSP </h1> <formmethod="post"> <br>Enternewvalue:<inputname="sample"><br> <br><br> <inputtype="submit"name="Submit"value="Submit"> <inputtype="reset"value="Reset"> <br> ValueofBeanpropertyis:<jsp:getPropertyname="jsp3BeanId"property="sample"/> </form> </body> </html>
jsp4:
<%@pagecontentType="text/html;charset=GB2312"%> <html> <head> <title> 登录 </title> </head> <bodybgcolor="#ffffc0"> <formmethod="POST"action="jsp6.jsp"> <palign="center"> 用户名：<inputtype="text"name="username"size="20"></p> <palign="center"> 密码：<inputtype="password"name="password"size="20"></p> <palign="center"> <inputtype="radio"value="manage"checkedname="select"> 管理 <inputtype="radio"name="select"value="statistic">统计</p> <palign="center"><inputtype="submit"value="登录"name="login"> <inputtype="reset"value="重写"name="reset"></p> </form> </body> </html>
jsp6:
<%@pagecontentType="text/html;charset=GB2312"%>
<html>
<head>
<title>
接收数据
</title>
</head>
<bodybgcolor="#ffffff">
<%
Stringuser,pwd,choice;
user=request.getParameter("username");
pwd=request.getParameter("password");
choice=request.getParameter("select");
if(choice.equals("manage")){
//userselectmanage.
%>
<jsp:forwardpage="jsp7.jsp">
<jsp:paramname="username"value="<%=user%>"/>
<jsp:paramname="password"value="<%=pwd%>"/>
</jsp:forward>
<%
}else{
//userselectstatistic
%>
<jsp:forwardpage="jsp8.jsp">
<jsp:paramname="username"value="<%=user%>"/>
<jsp:paramname="password"value="<%=pwd%>"/>
</jsp:forward>
<%
}
%>
</body>
</html>
jsp7:
<%@pagecontentType="text/html;charset=GB2312"%>
<html>
<head>
<title>
jsp7
</title>
</head>
<bodybgcolor="#ffffff">
<h1>
这是管理页!!!
</h1>
<br>
<%
Stringuser,pwd;
user=request.getParameter("username");
pwd=request.getParameter("password");
%>
usernameis:<%=user%><br>
passwordis:<%=pwd%><br>
</body>
</html>
jsp8:
<%@pagecontentType="text/html;charset=GB2312"%>
<html>
<head>
<title>
jsp8
</title>
</head>
<bodybgcolor="#ffffff">
<h1>
这是统计页!!!
</h1>
<br>
<%
Stringuser,pwd;
//user=request.getParameter("username");
user=newString(request.getParameter("username").getBytes("ISO8859_1"));
pwd=request.getParameter("password");
%>
usernameis:<%=user%><br>
passwordis:<%=pwd%><br>
</body>
</html>
input.html
<HTML> <HEAD> <TITLE>网页引导</TITLE> </HEAD> <BODY> <CENTER> <FONTSIZE=5COLOR=blue>网页引导</FONT> </CENTER> <BR> <HR> <BR> <FORMaction="sendRedirect.jsp"method=postname=form1> <P>姓名:<INPUTname=inputName></P> <P>E-Mail:<INPUTname=inputE_Mail></P> <INPUTname=submittype=submitvalue=送出> </FORM> </BODY> </HTML
sendRedirect.jsp:
<%@pagecontentType="text/html;charset=GB2312"%>
<%@pagelanguage="java"%>
<%
StringName=request.getParameter("inputName");
StringE_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>
<FONTSIZE=5COLOR=blue>网页引导</FONT>
</CENTER>
<BR>
<HR>
<BR>
<P>您的大名是：
<%=Name%>
</P>
<P>E-Mail帐号为：
<%=E_Mail%>
</P>
<p><ahref="../jsp1.jsp">返回</a></p>
</BODY>
</HTML>
sendRedirect.html:
<HTML> <HEAD> <TITLE>网页引导</TITLE> </HEAD> <BODY> <CENTER> <FONTSIZE=5COLOR=blue>网页引导</FONT> </CENTER> <BR> <HR> <BR> <FORMaction="sendRedirect.jsp"method=postname=form1> <fontsize=5color=red> 你输入的信息不完整，请重新输入！ </font> <br> <P>姓名:<INPUTname=inputName></P> <P>E-Mail:<INPUTname=inputE_Mail></P> <INPUTname=submittype=submitvalue=送出> </FORM> </BODY> </HTML>
希望本文所述对大家的JSP程序设计有所帮助。