Java EE (Java Enterprise Edition) General Discussion

Hi,

I am trying to append a variable to a MySql select statement.

Overview: I need to retrieve data from a MySql database with a java variable as a reference and select the data in the database based on that variable.

CODE THAT I CURRENTLY HAVE:

// Declare variables
Connection conn = null;
Statement st = null;
Resultset rs2 = null;
String st2 = null;
String keyid = null;

// Connect to database
try {

      Class.forName("org.gjt.mm.mysql.Driver").newInstance();
      conn = DriverManager.getConnection("jdbc:mysql://" + mysql_host + ":3306/" + mysql_database, mysql_login, mysql_password);
      st = conn.createStatement();
      // Select data in Database with hanging equal sign
      st2 = ("SELECT * FROM table WHERE keyid= ");
      // Append keyid to hanging equal sign of select statement
      rs2 = st.executeQuery(st2 + keyid);

}

This is not working when I try to display the data.