JSP简单添加,查询功能代码

程序员文章站 2023-01-25 16:39:19

本文实例讲述了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程序设计有所帮助。

上一篇： python封装json格式字符串并处理单双引号问题

下一篇： Python制作表白小程序——从代码到打包exe

JSP简单添加,查询功能代码

php调用百度百科api实现查询功能的代码实现,该怎么处理

为IP查询添加GOOGLE地图功能的代码_php技巧

简单的php查询数据库语句实例代码_PHP教程

非常不错的功能强大代码简单的管理菜单美化版_javascript技巧

请全能大神解答，此功能用PHP如何写？JSP代码已有，求翻译或者思路！路过请看看

mysql简单实现查询结果添加序列号的方法

java使用淘宝API读写json实现手机归属地查询功能代码

MySQL与Mongo简单的查询实例代码

C#仿密保卡功能的简单实现代码

MySQL与Mongo简单的查询实例代码