CODEWITHSUNDEEP
javajdbc
user663724
user663724

Reputation:

Can I use the same connection object when calling within Methods?

I have got a program this way:

public void MethodOne()
{
    String sqlquery = "select * from vendor_items where category_id = 1 ";
    PreparedStatement consildatedPst = connection.prepareStatement(sqlquery);
    ResultSet consilatedReslset = consildatedpst.executeQuery();
    while(consilatedReslset.next())
    {
        String name = consilatedReslset.getString("name");
        if(name!=null)
        {
            MethodTwo();
        }
    }
}

public void MethodTwo(String name)
{
    String sqlquery2 = "select ename from Vendor where name=?";
    PreparedStatement otherPst = connection.prepareStatement(sqlquery2);
    otherPst.setString(1,name);
}

This is the way connection is established (Later I will go for Connection Pooling).

public class DBConnection {

    public static Connection getDBConnection() {
        String sURL="jdbc:mysql://localhost:3306/oms";
        String sUserName="root";
        String sPwd="";
        Connection conn = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection(sURL, sUserName,sPwd);
            return conn;
            } catch (SQLException e) {
            e.printStackTrace();
            } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        return conn;
    }

}

My question is Can I use the same connection object when calling within Methods??

Upvotes: 0

Views: 411

Answers (2)

user207421
user207421

Reputation: 310913

Only if you aren't using the connection in multiple threads or nesting your own methods. In other words, no. Use a new connection per method. To avoid overhead use a connection pool.

Upvotes: 0

inigoD
inigoD

Reputation: 1741

Yes, you can.

When you do:

connection.prepareStatement(sqlquery2);

It creates a new statement object using the same connection. So the ResultSets that you obtain from them will belong to different Statements and will be different and there will be NO PROBLEM for you.

In short: Different Statements manage different ResultSets. If you get 2 ResultSets from the same Statement when you get the second one the first one will be dropped but if you have 2 Statements you can manage 2 ResulSets without problem (while the connection is open, of course)

Upvotes: 1

Related Questions