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>

%@ 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>

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;
}
}
}

%@ 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>

%@ 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>

%@ 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>

%@ 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>

%@ 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>

%@ 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>

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

%@ 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>

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>