Connection to database in separated class

[ishiro moh]

Hello,
establishing connection in every new class i create is now painful if i want to change some informations in database connection.
What should i do to have a separated class for database connection instead of always copy-past this:

       private static Connection conn; 
	 private static Statement stat; 
	 private static ResultSet rs; 
	 
//---------------------------------------------------------------------------
 public void Connect() {
	 
	 try {
	
		 String driver = "com.mysql.jdbc.Driver";
		 Class.forName(driver);
		 
		 String user = "root"; 
		 String pass = "";
		 
		 String db = "jdbc:mysql://localhost:3306/myApp";
		 conn = DriverManager.getConnection(db, user, pass);
		 stat = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
		 
	 }catch(Exception e) {
		 
	 }		 
 }
 
//---------------------------------------------------------------------------

[Jeff Verdegan]

ishiro moh wrote:
What should i do to have a separated class for database connection instead of always copy-past this:

Define a class. Whatever information you're currently copy/pasting, put it instead into that class. Then replace all those copy pastes with uses of that class.

I really don't understand the question. If you're writing Java code and using JDBC and aware of the idea that repeated code should be put into its own class, I gotta figure you already know everything you need to know.

You know how to define a class, right?
You know how to provide that class with state, either in a constructor or in methods, right?
You know how to use a class to perform services for you and, if appropriate, return results from actions, right?

So what are you having trouble with?

[ishiro moh]

The problem is that it doesnt work

here is the class i created:

package com.connection;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class dbconnect {
	
	private static Connection conn; 
	private static Statement stat; 
	private static ResultSet rs; 
	
	public void dbconnect() {
		
		try {
			
			 String driver = "com.mysql.jdbc.Driver";
			 Class.forName(driver);
			 
			 String user = "root"; 
			 String pass = "";
			 
			 String db = "jdbc:mysql://localhost:3306/users";
			 conn = DriverManager.getConnection(db, user, pass);
			 stat = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
			 
		 }catch(Exception e) {
			 
		 }		 
	 }	 
	 
}

when i call it from another class id doent work

dbconnect connection = new dbconnect();

what i'm doing wrong?

[Henry Wong]

ishiro moh wrote:The problem is that it doesnt work

here is the class i created:

package com.connection;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class dbconnect {
	
	private static Connection conn; 
	private static Statement stat; 
	private static ResultSet rs; 
	
	public void dbconnect() {
		
		try {
			
			 String driver = "com.mysql.jdbc.Driver";
			 Class.forName(driver);
			 
			 String user = "root"; 
			 String pass = "";
			 
			 String db = "jdbc:mysql://localhost:3306/users";
			 conn = DriverManager.getConnection(db, user, pass);
			 stat = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
			 
		 }catch(Exception e) {
			 
		 }		 
	 }	 
	 
}

when i call it from another class id doent work

dbconnect connection = new dbconnect();

what i'm doing wrong?

You need to actually call the method -- all your code does is instantiate a dbconnect object.

Henry

[Campbell Ritchie]

You have made the mistake of creating a method with the same name as the class. If you stick to the conventions about Capital Letters, and remember you mustn’t give a constructor a return type, that will no longer happen.

[Jeff Verdegan]

ishiro moh wrote:The problem is that it doesnt work

Although others have already pointed you in the right direction, please note that ItDoesntWorkIsUseless.(⇐click) You need to TellTheDetails.(⇐click)