aspose file tools*
The moose likes Java in General and the fly likes JAVA AND DATABASE CONNECTION Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Java » Java in General
Reply locked New topic
Author

JAVA AND DATABASE CONNECTION

suraj sheikh
Greenhorn

Joined: Mar 07, 2008
Posts: 23
hello everyone,

this is the only place i can get help !

Here are the details

I have an html page, then i get the parameters to the servlets.
Then i have a standalone class responsible for data base connection.

Here is the directory structure
c:\my projects\boaintegratedworkflow\src\com\system33\model\MyOracleConnection.java

The source code is :

package com.system33.model;
import java.sql.*;
public class MyOracleConnection {
public String result="uninitialized" ;
public Connection conn=null;
public Connection connectionDriver() {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc racle:thin:@localhost:1521:XE", "system","administrator");
} catch (Exception e) {
e.printStackTrace();
result="error in connection";
}
return conn;
}
public String fetchData() {
try {
Statement stmt = this.connectionDriver().createStatement();
String query="select * from boaiw";
ResultSet rs = stmt.executeQuery(query);
while(rs.next()) {
System.out.println(rs.getString(1));
result=rs.getString(1);
}
} catch (Exception e) {
e.printStackTrace();
//result="error in data return" ;
}
return result;
}
public static void main(String[] args) {
com.system33.model.MyOracleConnection obj=new com.system33.model.MyOracleConnection();
System.out.println(obj.fetchData());
}
}

This is the servlet Code

c:\my projects\boaintegratedworkflow\src\com\system33\model\Submit.java

package com.system33.web;
import com.system33.model.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
public class Submit extends HttpServlet {
public Connection conn;
public void doPost(HttpServletRequest request, HttpServletResponse response) throws IOException,

ServletException {
response.setContentType("text/html");
PrintWriter out=response.getWriter();
out.println("Selection Advice<br>");
out.println("<br> Value of connection ");
com.system33.model.MyOracleConnection obj = new com.system33.model.MyOracleConnection();
out.println("<br> Data Fetched "+obj.fetchData());
out.println("<br> Data Fetched "+obj.connectionDriver());
out.println("<br> This is the new servlet<br>");
}

}

The class file lands in
c:\my projects\boaintegratedworkflow\classes\com\system33\model\MyOracleConnection.class
c:\my projects\boaintegratedworkflow\classes\com\system33\web\Submit.class

And this is not fetching the data, it throws an exception whic i am not able to see as its not being displayed on the page

Please Help me guys ! i need it
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

Please continue the conversationover here.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JAVA AND DATABASE CONNECTION