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>
輸入數(shù)據(jù)
/title>
/head>
body bgcolor="#ffffff">
h1>
請輸入數(shù)據(jù):
/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>學(xué) 號:
/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>
添加數(shù)據(jù)
/title>
/head>
body bgcolor="#ffffff">
h1>
接收數(shù)據(jù),添加到數(shù)據(jù)庫.
/h1>
%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //載入驅(qū)動程序類別
Connection con = DriverManager.getConnection("jdbc:odbc:zjyds1"); //建立數(shù)據(jù)庫鏈接
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(結(jié)果集)對象
rs = stmt.executeQuery("SELECT * FROM tab02"); //執(zhí)行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循環(huán)將數(shù)據(jù)表中的記錄列出
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(); //關(guān)閉ResultSet對象
stmt.close(); //關(guān)閉Statement對象
con.close(); //關(guān)閉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技術(shù) !!!----2004/3/1--南昌大學(xué)軟件學(xué)院----
/h1>
h3>a href="tmp/page_1.htm">另一頁/a>/h3>
br>
h3>a href="jsp2.jsp">下一頁/a>/h3>
br>
h3>a href="DBBean.jsp">數(shù)據(jù)庫/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>順序取得數(shù)據(jù)/TITLE>
/HEAD>
BODY>
CENTER>
FONT SIZE = 5 COLOR = blue>順序取得數(shù)據(jù)/FONT>
/CENTER>
BR>
HR>
BR>
CENTER>
%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //載入驅(qū)動程序類別
Connection con = DriverManager.getConnection("jdbc:odbc:zjyds1"); //建立數(shù)據(jù)庫鏈接
Statement stmt = con.createStatement(); //建立Statement對象
ResultSet rs; //建立ResultSet(結(jié)果集)對象
rs = stmt.executeQuery("SELECT * FROM tab01"); //執(zhí)行SQL語句
%>
TABLE bgcolor=pink>
TR bgcolor=silver>
TD>B>學(xué) 號/B>/TD>TD>B>姓 名 /B>/TD>TD>B>性 別 /B>/TD>TD>B>年 齡 /B>/TD>TD>B>地 址/B>/TD>
/TR>
%
//利用while循環(huán)將數(shù)據(jù)表中的記錄列出
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(); //關(guān)閉ResultSet對象
stmt.close(); //關(guān)閉Statement對象
con.close(); //關(guān)閉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">統(tǒng)計(jì)/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>
接收數(shù)據(jù)
/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>
這是統(tǒng)計(jì)頁 !!!
/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>網(wǎng)頁引導(dǎo)/TITLE>
/HEAD>
BODY>
CENTER>
FONT SIZE = 5 COLOR = blue>網(wǎng)頁引導(dǎo)/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"); //若未完成資料輸入則將網(wǎng)頁導(dǎo)向sendRedirect.html
%>
HTML>
HEAD>
TITLE>網(wǎng)頁引導(dǎo)/TITLE>
/HEAD>
BODY>
CENTER>
FONT SIZE = 5 COLOR = blue>網(wǎng)頁引導(dǎo)/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>網(wǎng)頁引導(dǎo)/TITLE>
/HEAD>
BODY>
CENTER>
FONT SIZE = 5 COLOR = blue>網(wǎng)頁引導(dǎo)/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>