java 傳回局部變量_我想把java中的局部變量的傳回值傳回出來

packagecom.test;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;publicclassconmysql{p...

package com.test;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class conmysql {

public static void consql(String s,String col){

String cost;

try {

Class.forName("com.mysql.jdbc.Driver");

} catch (ClassNotFoundException e1) {

e1.printStackTrace();

}

//連結資料庫

try {

Connection con=DriverManager.getConnection("jdbc:mysql://192.168.1.250:3306/shop","fmrom","fmrom");

if(!con.isClosed()){

Statement st=con.createStatement();

ResultSet rs=st.executeQuery(s);

while(rs.next()){

cost = rs.getString(col);

System.out.print("資料庫中的價格："+cost+" ");

}

}

con.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

我想把cost的值return出來，并且在其他的類中還能調用consql(String s,String col)這個方法，改怎麼做啊

展開