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>

<h1>

请输入数据:

</h1>

<hr>

<!--webbot bot="SaveResults" U-File="fpweb:///_private/form_results.txt"

S-Format="TEXT/CSV" S-Label-Fields="TRUE" -->

<p></p>

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

<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="#000080"><b>地址:

</b></font><input type="text" name="addr" size="84"> </p>

<p>

</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>

<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语句

</TR>

//利用while循环将数据表中的记录列出

while (rs.next())

{

</TR>

}

rs.close(); //关闭ResultSet对象

stmt.close(); //关闭Statement对象

con.close(); //关闭Connection对象

</TABLE>

</CENTER>

</body>

</html>

-----------------------------------------------------------------------------------

留言人：刘晨留言时间：2004-5-17 18:30:38

留言内容：

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="*" />

<h1>

JBuilder Generated JSP

<br>

<hr>

这是第一次使用JSP技术 !!!----2004/3/1--南昌大学软件学院----

</h1>

<br>

<br>

<br>Enter new value : <input name="sample"><br>

<br>

<br>

Value of Bean property is :<jsp:getProperty name="jsp1BeanId" property="sample" />

</form>

</body>

</html>

-----------------------------------------------------------------------------------------------------------

Jsp1Bean.java

package test;

/*aaaaaaa

bbbbbbb

ccccccccc*/

/**

* <p>Title: </p>

* <p>Description: </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>

<FONT SIZE = 5 COLOR = blue>顺序取得数据</FONT>

</CENTER>

<BR>

<HR>

<BR>

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语句

</TR>

//利用while循环将数据表中的记录列出

while (rs.next())

{

</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="*" />

<h1>

JBuilder Generated JSP

</h1>

<br>Enter new value : <input name="sample"><br>

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

用户名：<input type="text" name="username" size="20"></p>

密码：<input type="password" name="password" size="20"></p>

管理

</form>

</body>

</html>

----------------------------------------------------------------------------------------------------------

jsp6:

<%@ page contentType="text/html; charset=GB2312" %>

<html>

<head>

<title>

接收数据

</title>

</head>

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>

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

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

</HEAD>

<BODY>

</CENTER>

<BR>

<HR>

<BR>

</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>

</HEAD>

<BODY>

</CENTER>

<BR>

<HR>

<BR>

<P>您的大名是：

<%= Name %>

</P>

<P>E-Mail帐号为：

<%= E_Mail %>

</P>

</BODY>

</HTML>

-----------------------------------------------------------------------------------

sendRedirect.html:

<HTML>

<HEAD>

</HEAD>

<BODY>

</CENTER>

<BR>

<HR>

<BR>

你输入的信息不完整，请重新输入！

</font>

<br>

</FORM>

</BODY>

</HTML>