Error in
String p = id_col + " " = first_name + last_name + " " + job; line
package database_console;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.ResultSet;
public class DBConnect {
public static void main(String[] args) {
try {
String host = "jdbc:derby://localhost:1527/Employees";
String uName = "songalia";
String uPass = "relente1";
Connection con = DriverManager.getConnection(host, uName, uPass);
Statement stmt = con.createStatement();
String sql = "SELECT * FROM Workers";
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
int id_col = rs.getInt("ID");
String first_name = rs.getString("First_Name");
String last_name = rs.getString("Last_Name");
String job = rs.getString("Job_Title");
String p = id_col + " " = first_name + last_name + " " + job;
System.out.println(p);
}
}
catch( SQLException err) {
System.out.println( err.getMessage());
}
}
}