package lww.onest;
import java.sql.SQLException;
import lww.onest.util.DBUtil;
public class DBTest {
public static void main(String[] args) {
try {
DBUtil dbUtil = new DBUtil();
dbUtil.showJobs();
} catch (ClassNotFoundException | SQLException e) {
e.printStackTrace();
}
}
}
package lww.onest.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import com.mysql.jdbc.PreparedStatement;
public class DBUtil {
public void showJobs() throws ClassNotFoundException, SQLException {
Class.forName("com.mysql.jdbc.Driver");
String connStr = "jdbc:mysql://localhost:3306/em";
String user = "root";
String pwd = "";
Connection conn = DriverManager.getConnection(connStr, user, pwd);
Statement statement = conn.createStatement();
String sql = "select * from jobs";
ResultSet rs = statement.executeQuery(sql);
while(rs.next()) {
int id = rs.getInt(1);
String name = rs.getString("name");
System.out.println(id + "\t" + name);
}
statement.close();
conn.close();
}
}