需要创建JavaBeen类和jdbc,这里为了方便各位查看就不将JavaBeen类写出来,并将功能放进Util类里。
package com;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.pojo.Emp;
public class DatabaseUntil {
/*
* 1.导入架包 2.加载驱动 3.连接数据库 4.操作数据库
*/
private String userName = "root";
private String password = "123456";
private String url = "jdbc:mysql://localhost:3306/作业?useSSL=true";
private Connection connection;
{
try {
Class.forName("com.mysql.jdbc.Driver");
System.out.println("驱动加载成功");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
System.out.println("驱动加载失败");
}
}
public DatabaseUntil() {
// TODO Auto-generated constructor stub
try {
this.connec