import java.sql.*;
public class Test01 {
public static void main(String[] args) {
// 注册驱动
Connection conn= null;
Statement statement = null;
ResultSet res = null;
try {
Driver driver = new com.mysql.jdbc.Driver();
DriverManager.registerDriver(driver);
// 2获取数据库连接
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/bjnode?useSSL=false", "root", "123456");
// 3.获取数据操作对象
statement = conn.createStatement();
// 4.执行SQL语句
String sql = "select e.ename as a,e.sal as b ,s.grade " +
"as c from emp e join salgrade s on e.sal between " +
"s.losal and s.hisal";
res = statement.executeQuery(sql);
// 5处理查询结果
while (res.next()) {
String ename = res.getString("a");
double sal = res.getDouble("b");
int grade = res.getInt("c");
System.out.println(ename + " " + sal + " " + grade);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
if (res != null) {
try {
res.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}
//注册驱动方式1
Driver driver = new com.mysql.jdbc.Driver();
DriverManager.registerDriver(driver);
//注册驱动方式2
Class.forName("com.mysql.jdbc.Driver");// 动态方式加载mysql驱动
代码相信大家都会,我是在IDEA的编译环境进行操作的,遇到的问题主要有两个,相信很多新手都可能遇到,一个是jar包的导入问题,如果没导入,会提示com.mysql.jdbc.Driver();无法识别,加载mysql-connector-java-5.1.39-bin.jar包,加载的方法可以参见http://blog.csdn.net/a153375250/article/details/50851049,楼主写的很清晰,当然还有很多其他方法,另外一个就是虽然运行成功但是会有警告,很长一段,原因是 String url = “jdbc:mysql://localhost:3306/bjnode?characterEncoding=utf8&useSSL=false”;的后半句useSSL=false这个设置一定要有,设置了MySQL数据库的查看权限问题,问号?前面的是个人要连接的数据库,特此说明,防止误解,希望对新手有所帮助吧!!