开启掘金成长之旅！这是我参与「掘金日新计划 · 12 月更文挑战」的第13天，点击查看活动详情
创建Student表，表结构如下:
package dao;
import java.sql.*;
public class DAOTest {
public static void main(String[] args) throws SQLException {
Connection con = DAOUtils.getConnection();
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select * from jdbc1.`javaee-jdbc`");
while(rs.next()){
System.out.println(rs.getString("name"));
System.out.println(rs.getString("university"));
System.out.println(rs.getString("sex"));
System.out.println(rs.getString("department"));
System.out.println(rs.getString("birthday"));
System.out.println(rs.getString("grade"));
}
con.close();
}
}
class DAOTest02 {
private static DriverManager DAOUtil;
public static void main(String[] args) throws SQLException {
Connection con = DAOUtils.getConnection();
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select * from jdbc1.`javaee-jdbc`");
while(rs.next()){
System.out.println(rs.getString("sid"));
System.out.println(rs.getString("university"));
}
con.close();
}
package dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DAOUtils {
private static final String url ="jdbc:mysql://localhost:3306/jdbc1?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2B8";
private static final String userName = "root";
private static final String password = "root";
private static java.sql.Connection con = null;
//加载驱动
public static void loadDriver(){
try {
Class.forName("com.mysql.cj.jdbc.Driver");
System.out.println("Driver ok");
} catch (ClassNotFoundException e) {
System.out.println("com.mysql.cj.jdbc.Driver");
e.printStackTrace();
}
}
//连接数据库
public static Connection getConnection()throws SQLException {
try {
if(con == null)
con = DriverManager.getConnection(url, userName, password);
} catch (SQLException e) {
System.out.println(e.getMessage());
System.out.println("getConnectionError!");
}
return con;
}
//关闭数据库
public static void close() {
try {
if (con != null&&! con.isClosed()){
con.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
配置步骤： 第一步：拷贝整合 junit 的必备 jar 包到 lib 目录
第二步：使用@RunWith 注解替换原有运行器
第三步：使用@ContextConfiguration 指定 spring 配置文件的位置
第四步：使用@Autowired 给测试类中的变量注入数据
开启掘金成长之旅！这是我参与「掘金日新计划 · 12 月更文挑战」的第13天，点击查看活动详情
