1、IDEA手动导入jar包(非Maven项目)
1、右上角projectStructure ——》Moudules——》Dependencis
2、点击“+”号 ,选择jar,或者文件夹
2、JDBC链接
//1.加载驱动程序
Class.forName(“com.mysql.jdbc.Driver”);
//2. 获得数据库连接对象
Connection conn = DriverManager.getConnection(URL, USER, PASSWORD);
//3.获取预编译语句的操作对象
Statement stmt = conn.prepareStatement(sql:“select * from table”);
//4.通过预编译语句操作对象获取结果集对象
ResultSet rs = stmt.executeQuery();
while(rs.next()){
System.out.printl(“姓名”+rs.getString(“字段1”));
}