import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBCDemo {
public static void main(String[] args) {
// try {
// //获得要访问数据库的驱动,jdk4.0以后可以自动加载驱动
// Class.forName("com.mysql.jdbc.Driver");
// } catch (ClassNotFoundException ex) {
// System.out.println("驱动没有加载");
// }
//连接数据库
String dburl = "jdbc:mysql://localhost:3306/数据库名";
String user = 用户名t";
String password = "密码";
String sql = "select * from 表名";
try( Connection con = DriverManager.getConnection(dburl,user,password);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(sql);) {
//发送sql语句
// 处理返回结果
while(rs.next()){
int a = rs.getInt("字段名");
String b = rs.getString("字段名");
String c = rs.getString(“字段名");
System.out.println(a + "\t\t" + b + "\t\t" +c);
}
} catch (SQLException ex) {
ex.printStackTrace();
}
}
}