1,工程目录结构:导入
mysql-connector-java-5.0.8-bin.jar
(在工程目录中双击该jar包中的.java文件可以查看其源代码,不过没啥意义,只针对mysql数据库)
查看源码的前提是有src文件,该jar包的源码包已上传
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public static void main(String[] args) throws Exception {
// TODO Auto-generated method stub
String sql = "SELECT * FROM stu";
//注册驱动
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
//获取连接Connection
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");
//获得执行SQL语句的对象Statement
Statement stmt = conn.createStatement();
//执行SQL语句,返回结果集
ResultSet rs = stmt.executeQuery(sql);
//处理结果集(显示在控制台)
while(rs.next()){
System.out.print(rs.getObject(1));
System.out.print(rs.getObject(2));
System.out.print(rs.getObject(3));
System.out.println(rs.getObject(4));
System.out.println("------------------------");
}
//关闭连接,释放资源
rs.close();
stmt.close();
conn.close();
}