Results 1 to 3 of 3
Thread: connecttion management
- 01-12-2012, 06:45 PM #1
Member
- Join Date
- Jan 2012
- Posts
- 1
- Rep Power
- 0
connecttion management
package com.tcs.nsep.beta.dao;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.*;
public class Connectionmanager {
static Connection conn;
static String url;
public static Connection getConnection() {
String serverName = "172.24.137.30";
String portNumber = "1521";
String sid = "ora10G";
String url = "jdbc:oracle:thin:@" + serverName + ":" + portNumber + ":"
+ sid;
String username = "";
String password = "";
try {
// load the JDBC-ODBC Bridge driver
Class.forName("oracle.jdbc.driver.OracleDriver");
// connect to db using DriverManager
// System.out.println("The Jdbc URL is " + url);
conn = DriverManager.getConnection(url, username, password);
return conn;
}
catch (ClassNotFoundException cnfex) {
// System.out.println("Class not found !! " + cnfex);
} catch (SQLException sqlex) {
// System.out.println("SQL Exception !! " + sqlex);
sqlex.printStackTrace();
} catch (Exception ex) {
// System.out.println("Exception has occured " + ex);
} finally {
}
return conn;
}
}
- 01-13-2012, 08:55 AM #2
Senior Member
- Join Date
- Jun 2007
- Location
- Bali, Indonesia
- Posts
- 696
- Rep Power
- 6
- 01-13-2012, 09:33 AM #3
Moderator
- Join Date
- Apr 2009
- Posts
- 10,476
- Rep Power
- 16
Similar Threads
-
File management API
By viiids in forum New To JavaReplies: 2Last Post: 12-25-2010, 12:40 AM -
password management
By Stephen Douglas in forum New To JavaReplies: 6Last Post: 07-23-2010, 11:17 AM -
session management
By rakesh_n_mehta in forum Web FrameworksReplies: 7Last Post: 09-22-2009, 07:02 PM -
Need Suggestions on layout management
By rdtindsm in forum AWT / SwingReplies: 2Last Post: 04-26-2009, 06:14 AM -
library management
By jyothi.priyanka in forum New To JavaReplies: 25Last Post: 03-11-2009, 05:11 PM


LinkBack URL
About LinkBacks
Reply With Quote
Bookmarks