Hi friend,

code for oracle connectivity with java :

Connection con = null;

String serverName = "localhost";
String portNumber = "1521";
String db = "XE";
String url = "jdbc:oracle:thin:@" + serverName + ":" + portNumber + ":" + db;
String driver = "oracle.jdbc.driver.OracleDriver";
String user = "dashboard";
String pass = "dashboard";

public Connection getConnection(){
try{
Class.forName(driver);
con = DriverManager.getConnection(url, user, pass);
}
catch (ClassNotFoundException e){
System.err.println("Could not load JDBC driver");
System.out.println("Exception: " + e);
e.printStackTrace();
}
catch(SQLException ex){
System.err.println("SQLException information");
while(ex!=null) {
System.err.println ("Error msg: " + ex.getMessage());
System.err.println ("SQLSTATE: " + ex.getSQLState());
System.err.println ("Error code: " + ex.getErrorCode());
ex.printStackTrace();
ex = ex.getNextException(); // For drivers that support chained exceptions
}
}
return con;
}

For login application on JSP visit to :

http://www.roseindia.net/jsp/loginbean.shtml

Thanks