Java JDBC prepared Statement?
I need to Insert two values into my Table. One value is a passed value called eveType2, the second value is one got from another database table. I have tried
try
{
con = DatabaseUtils.connect(DRIVER, URL);
String sql = "INSERT INTO tblEvent (Event_Name, Meet_ID) VALUES (?) " +
"SELECT eveType2, " +
"ID FROM tblMeet " +
"WHERE Meet_Name='Wembley' ";
ps = con.prepareStatement(sql);
ps.setString(1, eveType2);
ps.executeUpdate();
}
But it wont set the value i am trying to get (ID) from tblMeet. How would i do this?
cheers
|