pom.xml文件中配置依赖
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.0.8</version>
</dependency>
加载驱动
Class.forName(“com.mysql.jdbc.Driver”);
创建连接
Conn=DriverManager.getConnection(url,username,password);
创建命令执行对象
Stmt=Conn.createStatement();
执行命令
添加删除修改
Stmt.executeUpdate(sql);
查询
Rs=Stmt.executeQuery(sql);
Rs2list(list);
public void rs2list(List<E> list) throws Exception{
System.out.println("=====用于重写=====");
}
释放资源
CloseResources();
private void closeResources(){
try {
if(rs!=null){
rs.close();
rs=null;
}
if(stmt!=null){
stmt.close();
stmt=null;
}
if(conn!=null){
conn.close();
conn=null;
}
} catch (Exception e) {
e.printStackTrace();
}
System.out.println("==========close=========");
}
查询需要返回值
Return list;
总体实现
public class BaseDAO<E> {
private static final String DRIVER="com.mysql.jdbc.Driver";
private static final String URL="jdbc:mysql://localhost:3306/myDatabase?characterEncoding=utf8";
private static final String USERNAME="root";
private static final String USERPWD="123";
private static Connection conn=null;
private static Statement stmt=null;
protected static ResultSet rs=null;
static{
try {
Class.forName(DRIVER);
System.out.println("=====加载驱动=====");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
//通用的增删改update方法
public void update(String sql){
// 1、加载驱动
// 2、链接数据
getConn();
// 3、创建命令执行对象 将JAVA中的字符串转化成MYSQL可以识别的SQL语句。
getStmt();
// 4、执行命令
try {
stmt.executeUpdate(sql);
System.out.println("=========sql========="+sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
// 5、释放资源
closeRes();
}
//通用的查询query方法
public List<E> query(String sql){
List<E> list=new ArrayList<>();
getConn();
getStmt();
try {
rs= (ResultSet) stmt.executeQuery(sql);
rs2list(list);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
closeRes();
return list;
}
public void rs2list(List<E> list){
// 用来被重写的类
}
public void getConn(){
try {
conn= (Connection) DriverManager.getConnection(URL,USERNAME,USERPWD);
System.out.println("====连接创建成功=====");
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void getStmt(){
try {
stmt= (Statement) conn.createStatement();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void closeRes(){
try {
if(stmt!=null){
stmt.close();
stmt=null;
}
if(conn!=null){
conn.close();
conn=null;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
System.out.println("====释放资源成功======");
}
}