hey
can somebody tell me how to print result from my array?
This is my code and i don't know what's wrong...
public void connection() throws ClassNotFoundException, SQLException
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con= DriverManager.getConnection("jdbcdbc:test");
Statement s= con.createStatement();
String query = "SELECT * from table";
ResultSet rs = s.executeQuery(query);
while (rs.next())
{
for (int i=0; i<0; i++)
{
question[i]= rs.getString("columnQustion");
answer1[i]=rs.getString("column1");
answer2[i]=rs.getString("column2");
answer3[i]=rs.getString("column3");
answer4[i]=rs.getString("column4");
}
}
setQandA();
rs.close();
s.close();
con.close();
}
catch (ClassNotFoundException e)
{
e.printStackTrace();
}
catch (SQLException e)
{
}
}
public void setQandA();
{
int i=0;
label1.setText("question number:" + " "+ (i+1));
labelQuestion.setText(question[i]); //
radioButton1.setText(answer1[i]); // when i comment those lines program running
radioButton1.setText(answer2[i]); // otherwise not
radioButton1.setText(answer3[i]); //
radioButton1.setText(answer4[i]); //
}
thanks
can somebody tell me how to print result from my array?
This is my code and i don't know what's wrong...
public void connection() throws ClassNotFoundException, SQLException
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con= DriverManager.getConnection("jdbcdbc:test");
Statement s= con.createStatement();
String query = "SELECT * from table";
ResultSet rs = s.executeQuery(query);
while (rs.next())
{
for (int i=0; i<0; i++)
{
question[i]= rs.getString("columnQustion");
answer1[i]=rs.getString("column1");
answer2[i]=rs.getString("column2");
answer3[i]=rs.getString("column3");
answer4[i]=rs.getString("column4");
}
}
setQandA();
rs.close();
s.close();
con.close();
}
catch (ClassNotFoundException e)
{
e.printStackTrace();
}
catch (SQLException e)
{
}
}
public void setQandA();
{
int i=0;
label1.setText("question number:" + " "+ (i+1));
labelQuestion.setText(question[i]); //
radioButton1.setText(answer1[i]); // when i comment those lines program running
radioButton1.setText(answer2[i]); // otherwise not
radioButton1.setText(answer3[i]); //
radioButton1.setText(answer4[i]); //
}
thanks