主頁(yè) > 知識(shí)庫(kù) > JSP簡(jiǎn)單添加,查詢(xún)功能代碼

JSP簡(jiǎn)單添加,查詢(xún)功能代碼
熱門(mén)標(biāo)簽：四川保險(xiǎn)智能外呼系統(tǒng)商家 北票市地圖標(biāo)注 電銷(xiāo)機(jī)器人是有一些什么技術(shù) 高德地圖標(biāo)注樣式 杭州ai語(yǔ)音電銷(xiāo)機(jī)器人功能 商洛電銷(xiāo) 杭州語(yǔ)音電銷(xiāo)機(jī)器人軟件 電銷(xiāo)機(jī)器人好賣(mài)么 地圖標(biāo)注線上教程

本文實(shí)例講述了JSP簡(jiǎn)單添加,查詢(xún)功能。分享給大家供大家參考。具體如下：

JSP技術(shù):

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>
請(qǐng)輸入數(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é) 號(hào):
/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="全部重寫(xiě)" 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ù)庫(kù).
/h1>
%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //載入驅(qū)動(dòng)程序類(lèi)別
Connection con = DriverManager.getConnection("jdbc:odbc:zjyds1"); //建立數(shù)據(jù)庫(kù)鏈接
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é)果集)對(duì)象
rs = stmt.executeQuery("SELECT * FROM tab02"); //執(zhí)行SQL語(yǔ)句
%>
CENTER>
TABLE bgcolor=pink>
TR bgcolor=silver>
TD>B>編號(hào)/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對(duì)象
stmt.close(); //關(guān)閉Statement對(duì)象
con.close(); //關(guān)閉Connection對(duì)象
%>
/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技術(shù) !!!----2004/3/1--南昌大學(xué)軟件學(xué)院----
/h1>
h3>a href="tmp/page_1.htm">另一頁(yè)/a>/h3>
br>
h3>a href="jsp2.jsp">下一頁(yè)/a>/h3>
br>
h3>a href="DBBean.jsp">數(shù)據(jù)庫(kù)/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>順序取得數(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ū)動(dòng)程序類(lèi)別
Connection con = DriverManager.getConnection("jdbc:odbc:zjyds1"); //建立數(shù)據(jù)庫(kù)鏈接
Statement stmt = con.createStatement(); //建立Statement對(duì)象
ResultSet rs; //建立ResultSet(結(jié)果集)對(duì)象
rs = stmt.executeQuery("SELECT * FROM tab01"); //執(zhí)行SQL語(yǔ)句
%>
TABLE bgcolor=pink>
TR bgcolor=silver>
TD>B>學(xué) 號(hào)/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對(duì)象
stmt.close(); //關(guān)閉Statement對(duì)象
con.close(); //關(guān)閉Connection對(duì)象
%>
/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">統(tǒng)計(jì)/p>
p align="center">input type="submit" value="登 錄" name="login">
input type="reset" value="重 寫(xiě)" name="reset">/p>
/form>
/body>
/html>

jsp6:

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

jsp7:

%@ page contentType="text/html; charset=GB2312" %>
html>
head>
title>
jsp7
/title>
/head>
body bgcolor="#ffffff">
h1>
這是管理頁(yè) !!!
/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>
這是統(tǒng)計(jì)頁(yè) !!!
/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>網(wǎng)頁(yè)引導(dǎo)/TITLE>
/HEAD>
BODY>
CENTER>
FONT SIZE = 5 COLOR = blue>網(wǎng)頁(yè)引導(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

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"); //若未完成資料輸入則將網(wǎng)頁(yè)導(dǎo)向sendRedirect.html
%>
HTML>
HEAD>
TITLE>網(wǎng)頁(yè)引導(dǎo)/TITLE>
/HEAD>
BODY>
CENTER>
FONT SIZE = 5 COLOR = blue>網(wǎng)頁(yè)引導(dǎo)/FONT>
/CENTER>
BR>
HR>
BR>
P>您的大名是：
%= Name %>
/P>
P>E-Mail帳號(hào)為：
%= E_Mail %>
/P>
p>a href="../jsp1.jsp">返回/a>/p>
/BODY>
/HTML>

sendRedirect.html:

HTML>
HEAD>
TITLE>網(wǎng)頁(yè)引導(dǎo)/TITLE>
/HEAD>
BODY>
CENTER>
FONT SIZE = 5 COLOR = blue>網(wǎng)頁(yè)引導(dǎo)/FONT>
/CENTER>
BR>
HR>
BR>
FORM action="sendRedirect.jsp" method=post name=form1>
font size=5 color=red>
你輸入的信息不完整，請(qǐng)重新輸入！
/font>
br>
P>姓名 : INPUT name=inputName >/P>
P>E-Mail : INPUT name=inputE_Mail >/P>
INPUT name=submit type=submit value=送出>
/FORM>
/BODY>
/HTML>

希望本文所述對(duì)大家的JSP程序設(shè)計(jì)有所幫助。

您可能感興趣的文章:
  • jsp分頁(yè)顯示的實(shí)現(xiàn)代碼
  • JSP分頁(yè)顯示的實(shí)例代碼
  • 一個(gè)實(shí)用的JSP分頁(yè)代碼
  • JSP實(shí)現(xiàn)的簡(jiǎn)單分頁(yè)示例
  • jsp hibernate的分頁(yè)代碼
  • JSP自定義分頁(yè)標(biāo)簽TAG全過(guò)程
  • JSP實(shí)現(xiàn)的簡(jiǎn)單分頁(yè)顯示效果代碼
  • jsp實(shí)現(xiàn)頁(yè)面分頁(yè)功能代碼
  • jsp操作MySQL實(shí)現(xiàn)查詢(xún)/插入/刪除功能示例
  • JSP實(shí)現(xiàn)帶查詢(xún)條件的通用分頁(yè)組件

標(biāo)簽：宿州 紅河 云浮 青島 江西 貴州 丹東 西藏

巨人網(wǎng)絡(luò)通訊聲明：本文標(biāo)題《JSP簡(jiǎn)單添加,查詢(xún)功能代碼》，本文關(guān)鍵詞  JSP,簡(jiǎn)單,添加,查詢(xún)功能,；如發(fā)現(xiàn)本文內(nèi)容存在版權(quán)問(wèn)題，煩請(qǐng)?zhí)峁┫嚓P(guān)信息告之我們，我們將及時(shí)溝通與處理。本站內(nèi)容系統(tǒng)采集于網(wǎng)絡(luò)，涉及言論、版權(quán)與本站無(wú)關(guān)。
  • 相關(guān)文章
  • 下面列出與本文章《JSP簡(jiǎn)單添加,查詢(xún)功能代碼》相關(guān)的同類(lèi)信息！
  • 本頁(yè)收集關(guān)于JSP簡(jiǎn)單添加,查詢(xún)功能代碼的相關(guān)信息資訊供網(wǎng)民參考！

    • 四合一精品企业网站建设

    多一个网站就为企业多增加一条营销渠道

    ¥888元限时抢购

    QQ立即咨询快速购买

    企业400电话

    智能AI客服机器人
    ￥15000

    在线订购

    合计11份范本：公司章程+合伙协议+出资协议+合作协议+股权转让协议+增资扩股协议+股权激励+股东会决议+董事会决议

    推薦文章