can't return a value from a method / jdbc

[tascoa]

Hello I ahve a problem with returning a String value from "JdbcBean" to Main Class.

JdbcBean:
public class JdbcBean {

Connection conn;

public String getColumn(int sloupecek) {

String sloupec1 = new String();

try {
Class.forName("oracle.jdbc.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@xxx ", "xxx", "xxx");
Statement s = conn.createStatement();
ResultSet r = s.executeQuery("select * from student");

while (r.next()) {
sloupec1 = r.getString(sloupecek);
return sloupec1;
}
r.close();
s.close();
conn.close();
}
catch (ClassNotFoundException cnfe) {
cnfe.printStackTrace();
}
catch (SQLException sqle) {
sqle.printStackTrace();
}
}
}

MainClass:
public class MainPokus {

public static void main(String[] args) {

JdbcBean spojeni = new JdbcBean();

System.out.println(spojeni.getColumn(2));
}
}

Exception:
Error(23,24): can't return a value from method whose result type is void

Have anyone any advice for me?

I am a begginer in Jdbc database get data. :(

Thanks a lot.

[r035198x]

You need to learn the Java basics before trying to connect to databases.
Your method is void but you have return statements inside it.

[tascoa]

I am sorry, the void is wrong, It my mistake. But if I erase void word, the error is the same...

[PhHein]

Learn the basics!
The Java™ Tutorials