السلام عليكم ورحمة الله وبركاته
لدي برنامج تجريبي كتبته لربط الجافا سرفلت بالاوراكل
لكن اتضح لي انه لم يتم الاتصال بالداتابيس ولا اعلم مالسبب!!
مع العلم اني عملت جميع التعليمات التي وجدتها
الكود:
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import oracle.sql.BLOB;
import oracle.jdbc.driver.*;
public class oo extends HttpServlet {
/** Return the list of numbers that init computed. */
public void doGet(HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException
{
;
String driver = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle:thin:@localhost:1521:mmmqqq";
String username = "system";
String password = "1234";
response.setContentType("text/html");
PrintWriter out = response.getWriter();
String title = "Thanks Alot";
String docType =
"<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 " +
"Transitional//EN\">\n";
out.println(docType +
"<HTML>\n" +
"<HEAD><TITLE>" + title + "</TITLE></HEAD>\n" +
"<BODY >\n"
);
out.println("befor try");
try {
Class.forName(driver);
out.println("Befor Connection !");
Connection connection =DriverManager.getConnection(url,username,password);
out.println("Connection Done!");
Statement statement = connection.createStatement();
out.println("after stmt");
String query="select * from student"; //where CustomerID='"+p1+"'and CompanyName='"+p2+"'and ContactTitle='"+p3+"'";
out.println("after query");
ResultSet resultSet = statement.executeQuery(query);
out.println("after send query");
out.println(resultSet.getString(1));
while(resultSet.next())
{
out.println(resultSet.getString(1));
}
out.println("the end");
} catch(ClassNotFoundException cnfe) {
System.err.println("Error loading driver: " +cnfe);
} catch(SQLException sqle) {
System.err.println("Error connecting: " + sqle);
}
out.println("yyyyy");
out.println("</BODY></HTML>");
}
}في انتظار مساعدتكم
