62,614
社区成员
发帖
与我相关
我的任务
分享
package database20;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Gradation {
static Connection con;
static Statement sql;
static ResultSet res;
public Connection getConnection() { // 连接数据库
try {// 加载数据库驱动类
Class.forName("com.mysql.jdbc.Driver");
// System.out.println("数据库驱动加载成功");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
try {
con = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=false", "root",
"qwer1234");
// System.out.println("数据库连接成功");
} catch (SQLException e) {
e.printStackTrace();
// TODO: handle exception
}
return con;// 返回Connection对象
}
public static void main(String[] args) {
database20.Gradation c = new database20.Gradation();// 创建本类对象
con = c.getConnection();// 与数据库建立连接
try {
sql = con.createStatement();// 实例化Statement对象
// 执行SQL语句,返回结果集
res = sql.executeQuery("select * from tb_emp");
while (res.next()) {
String id = res.getString("编号");// 获取列名是id字段值
String name = res.getString("姓名");
String sex = res.getString("性别");
String birthday = res.getString("生日");
System.out.println("编号:" + id);
System.out.println("姓名:" + name);
System.out.println("性别:" + sex);
System.out.println("生日:" + birthday);
}
} catch (Exception e) {
e.printStackTrace();
// TODO: handle exception
}
}
}