how to pass the string array from A jsp to B jsp

Thread view:

Ming伯 - 24 Jun 2006 02:22 GMT

Hi!

Do anyone know pass the string array from A jsp to B jsp? For
example, I want to pass Strresult to query.jsp for operation. How can
I do? THX!

Ming

<%@page contentType="text/html"%>
<%@page pageEncoding="Big5"%>
<%@page import = "java.sql.*"%>
<html>
<head><title>?D???O?d?????G</title></head>
<body>
<form action="query.jsp" method="post">
<%
String Strresult[] = new String[10];
String Test = "";
int i = 0;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con =
DriverManager.getConnection("jdbc:odbc:MT450");
Statement smt = con.createStatement();
String name =
new
String(request.getParameter("name").getBytes("ISO-8859-1"));
String sql = "select Standard from Combinations where Model ='"
+ name + "'";
String color;
ResultSet rs = smt.executeQuery(sql);

while(rs.next()){
Strresult[i]=rs.getString(1);
out.println(Strresult[i++]+"<p>");

}
con.close();
%>
<input type="submit" value="?T?{????">
<input type='hidden' name='name' value='<%= name %>'>
<input type='hidden' name='Test' value='<%= Test %>'>

</form>

</body>
</html>

Reply to this Message

Dražen Gemić - 24 Jun 2006 14:33 GMT

Ming wrote:

> Hi!
>
> Do anyone know pass the string array from A jsp to B jsp? For
> example, I want to pass Strresult to query.jsp for operation. How can
> I do? THX!

Most obvious method is using session. In your example it does not
look like you are submitting anything important, or any user
input, so, it does not seem that first jsp should submit
data to second. If that is the true, then you can use the
request object and, add attribute to it (request.setAttribute()), and
let the first jsp to forward (jsp:forward) request to second (chaining).

DG

Reply to this Message

John O'Conner - 24 Jun 2006 16:49 GMT

> Hi!
>
> Do anyone know pass the string array from A jsp to B jsp? For
> example, I want to pass Strresult to query.jsp for operation. How can
> I do? THX!

What keeps you from sending it the same way that you send "name" or "Test"?

--
John O'Conner

Reply to this Message

Jan Peter Stotz - 24 Jun 2006 16:59 GMT

Ming伯 schrieb:

> String name =
> new
> String(request.getParameter("name").getBytes("ISO-8859-1"));
> String sql = "select Standard from Combinations where Model ='"
> + name + "'";

I would suggest reading one or two articles about "SQL-Injection-attacks"
and how to prevent them (hint: PreparedStatement).

Jan

Reply to this Message

how to pass the string array from A jsp to B jsp

Free Magazines