Register / Login

Win a copy of Microservices Testing (Live Project) this week in the Spring forum!

Raymond O'Leary

Greenhorn

+ Follow

24 Posts 9 Threads 0 Cows

since Mar 23, 2004

Merit Badge info

Cows and Likes

Cows

Total received

0

In last 30 days

0

Total given

0

Likes

Total received

0

Received in last 30 days

0

Total given

0

Given in last 30 days

0

Forums and Threads

Scavenger Hunt

Ranch Hand Scavenger Hunt

Greenhorn Scavenger Hunt

Recent posts by Raymond O'Leary

JSP coding /counting standards?

hi lads,
Not sure if this is in the correct place......but, I'm just wondering if there are any defined jsp coding and counting standards?
Or should i just stick to a predefined java one?
Would it be difficult to define my own standards?
Is there any rules of thumb I should follow?
Oh and in my code I have SQL statements reading/ writing etc to a database. Is this all done on the database side or in the jsp page?
Having a bit of difficulty finding stuff on the web.
Anyway thanks guys

18 years ago

All working now thanks for the help guys especialyy Avi!
Ray

18 years ago

JDBC and Relational Databases

Storing The ResultSet

All working now thanks for the help guys.
Ray

18 years ago

JDBC and Relational Databases

Storing The ResultSet

Ah its working now.
Thanks for your help buddy.

18 years ago

JDBC and Relational Databases

Storing The ResultSet

Yeah second query works perfectly
I put this in batween the selects, and the value is printed out.

Its this bit here! Does it look correct?
[ CODE]
String ans=null;
while(rs.next())
{
ans = rs.getString(1);
}
rs.close(); [/CODE]
and thanks for pointing out the closed rs1 for me.

18 years ago

JDBC and Relational Databases

Storing The ResultSet

Yeah it returns a value, my problem is putting that value into the string ans and using that value in a further sql statement.

18 years ago

JDBC and Relational Databases

Storing The ResultSet

Hey Guys me again!
Here I'm trying to store the sole result into a string called ans, and use the string in another query. as dar as i can tell the ans string isn't getting any values? Can anybody shed some light on this? Thanks guys.

<% Connection con = null;
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("jdbc :-o racle:thin:@witnt07.wit.ie:1521 :-o rawit","x", "x");
Statement st=con.createStatement();
String UName=(String) session.getAttribute("username");
String strSQL = "SELECT GROUP_ID FROM GROUPVIEW WHERE STUDENT_NUMBER = '" + UName + "'";
ResultSet rs=st.executeQuery(strSQL);
String ans;
while(rs.next())
{
ans=(String)rs.getString(1);
}
rs.close();
Statement st1=con.createStatement();
ResultSet rs1= st1.executeQuery("SELECT * FROM GROUPVIEW WHERE GROUP_ID = '" + ans + "'");
out.println("<font color=midnightblue><H3><B>Project Group Details</b></h3><p>");
out.println("<table border=1 width=400>");
out.println("<TR><td width=50 align=center><b>Group ID</b></td>");
out.println("<td width=50 align=center><b>Student Number</b></td>");
out.println("<td width=50 align=center><b>Student First Name</b></td>");
out.println("<td width=50 align=center><b>Student Last Name</b></td>");
out.println("<td width=50 align=center><b>Student Last Name</b></td>");
while (rs.next())
{
out.println("<TR><td width=50>"+ rs1.getString(1));
out.println("<td width=50>"+ rs1.getString(2));
out.println("<td width=50>"+ rs1.getString(3));
out.println("<td width=50>"+ rs1.getString(4));
out.println("</td><td width=50>"+ rs1.getString(5) +"</td></tr>");
}
rs1.close();
out.println("</table>");
con.close();
}

18 years ago

JDBC and Relational Databases

A simple insert....

All working thanks very much

18 years ago

JDBC and Relational Databases

A simple insert....

Lu you're a genius,
now if you could only tell me why the text in my text area is not goning into the database then I may propose.
I just got rid of the if itself by the way. Is this a bad idea?
CHEERS!!

18 years ago

JDBC and Relational Databases

A simple insert....

....wrecking my head!
Anybody got any clue as to why it isn't working? When I click the submit button the page displayed only contains the text used in the finally bit.
"DisConnecting From Server.... "
It doesn't even get this far:

Here's my full code:

<%@ page language="java" import="java.sql.*, oracle.jdbc.*" contentType= "text/html; charset=windows-1257" %>
<html>
<BODY>
<%
Connection con = null;
try {
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
con = DriverManager.getConnection("jdbc

racle:thin:@witnt07.wit.ie:1521

rawit","x", "x");
if ( ( request.getParameter("submit")).equals("submit") )
{
Statement statement1 = con.createStatement();
String sup=(String) session.getAttribute("username");
String grp = request.getParameter("t1");
String day = request.getParameter("D2");
String month = request.getParameter("D3");
String year = request.getParameter("D4");
String com = request.getParameter("comment");
String strSQL = "INSERT INTO SUPERLOG VALUES(NEXTSUPERLOG.nextval , "+" '"+sup+"' , "+" '"+grp+ "' , "+" '"+ day+"' , " + " '" +month +"' , "+" '"+year+"'," + "'" +com +"')";
String strSQL1 = "commit";
statement1.executeQuery(strSQL);
statement1.executeQuery(strSQL1);
con.close();
out.println("<font color=midnightblue><h3>You're log was added</h3></font>");
}
}
catch (SQLException sqle) {
out.println("SQL Bummer : " + sqle.getMessage());
}

catch (Exception e) {
out.println("Bit of a Bummer : " + e.getMessage());
}
finally {
try
{
if ( con != null )
{
out.println("<BR><BR>");
out.println("DisConnecting From Server.... ");
con.close();
}
}
catch (Exception e)
{
out.println("Bit of a Bummer Disconnecting : " + e.getMessage());
}
}
%>
</CENTER>
</BODY>
</HTML>
[/CODE]
Anybody have any ideas?

18 years ago

JDBC and Relational Databases

Hey there,
So this will work? Cant get the bloody thing to run.
if ( ( request.getParameter("submit")).equals("submit") )
{
Statement statement1 = con.createStatement();
String sup=(String) session.getAttribute("username");
String grp = request.getParameter("t1");
String day = request.getParameter("D2");
String month = request.getParameter("D3");
String year = request.getParameter("D4");
String com = request.getParameter("comment");
String strSQL = "INSERT INTO SUPERLOG VALUES(NEXTSUPERLOG.nextval , "+" '"+sup+"' , "+" '"+grp+ "' , "+" '"+ day+"' , " + " '" +month +"' , "+" '"+year+"'," + "'" +com +"')";
String strSQL1 = "commit";
ResultSet rs1 = statement1.executeQuery(strSQL);
rs1.close();
con.close();
Thanks for the help.

18 years ago

JDBC and Relational Databases

Connection aborted by peer: socket write error

Hey Guys,
I'm trying to run a jsp application inside jbuilder? Everything compiles ok but after this:
Starting tomcat. Check logs/tomcat.log for error messages
2004-03-29 05:51:53 - ContextManager: Adding context Ctx( )
2004-03-29 05:51:54 - Ctx( ): Removing duplicate servlet jsp jsp(org.apache.jasper.servlet.JspServlet/null)
2004-03-29 05:51:54 - Ctx( ): Removing duplicate *.jsp -> jsp(org.apache.jasper.servlet.JspServlet/null)
2004-03-29 05:51:57 - PoolTcpConnector: Starting HttpConnectionHandler on 8080
2004-03-29 05:51:57 - PoolTcpConnector: Starting Ajp12ConnectionHandler on 8081
I just get this!
2004-03-29 05:52:02 - Ctx( ): IOException in: R( + / + null) Connection aborted by peer: socket write error

Its breaking my heart!
Any clues as to why this is happening?
Cheers.

18 years ago

Other IDEs, Version Control

Connection aborted by peer: socket write error

Hey Guys,
I'm trying to run a jsp application inside jbuilder? Everything compiles ok but after this:
Starting tomcat. Check logs/tomcat.log for error messages
2004-03-29 05:51:53 - ContextManager: Adding context Ctx( )
2004-03-29 05:51:54 - Ctx( ): Removing duplicate servlet jsp jsp(org.apache.jasper.servlet.JspServlet/null)
2004-03-29 05:51:54 - Ctx( ): Removing duplicate *.jsp -> jsp(org.apache.jasper.servlet.JspServlet/null)
2004-03-29 05:51:57 - PoolTcpConnector: Starting HttpConnectionHandler on 8080
2004-03-29 05:51:57 - PoolTcpConnector: Starting Ajp12ConnectionHandler on 8081
I just get this!
2004-03-29 05:52:02 - Ctx( ): IOException in: R( + / + null) Connection aborted by peer: socket write error

Its breaking my heart!
Any clues as to why this is happening?
Cheers.

18 years ago

Ok this is what I've got but it still dont work, can anybody shed any light on this? I'm just unsure of the format of some of the statements.

<%@ page language="java" contentType="text/html"
import="java.util.*" import="oracle.jdbc.*" import="java.sql.*"%>
<html>
<body bgColor="WHITE" text = "MIDNIGHTBLUE">
<img src="witlogo.gif" align=left><H2><font color=midnightblue>X</font></H2><hr>
<%
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection con = DriverManager.getConnection("jdbc

racle:thin:@witnt07.wit.ie:1521

rawit","X", "X");
String query = "INSERT INTO SUPERLOG VALUES ('',?,?,?,?,?,?)";
PreparedStatement Stmt = con.prepareStatement(query);

String UName = (String) session.getAttribute("username");
Stmt.setString(1,NEXTSUPERLOG.nextval);
Stmt.setString(2,request.getParameter("UName"));
Stmt.setString(3,request.getParameter("t1"));
Stmt.setString(4,request.getParameter("D2"));
Stmt.setString(5,request.getParameter("D3"));
Stmt.setString(6,request.getParameter("D4"));
Stmt.setString(7,request.getParameter("comment"));
Stmt.executeUpdate();
Stmt.close();
con.close();
%>
<p> <br><p> <br><p> <H3><b>Your Comment Was Successfully Added</b></h3>
</body>
</html>
Thanks Lads

18 years ago

JDBC and Relational Databases

Hey There,
I've put an auto increment into my database for updating some of my tables.
When using preparedStatements I know that you dont put in a question mark in the insert statement, but what does one put in there?
This is the code and assume that the auto incfrement is the first field in the table.
String query = "INSERT INTO SUPERLOG VALUES (?,?,?,?,?,?,?)";
And when doing the -
Stmt.setString(1,"");
-stuff do you leave one blank? Or do you leave it out altogether?
Here is the code...

String query = "INSERT INTO SUPERLOG VALUES (?,?,?,?,?,?,?)";
PreparedStatement Stmt = con.prepareStatement(query);
String UName = (String) session.getAttribute("username");
Stmt.setString(1,"");
Stmt.setString(2,request.getParameter("UName"));
........
Stmt.setString(6,request.getParameter("xxx"));
Thanks guys.

18 years ago

JDBC and Relational Databases