jdbc mysql分层_Java JDBC连接数库简单 分层操作

这个包的只负责实现数据库的操作

不采取其他操作

package com.zhidisoft.dao;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import com.zhidisoft.entity.Dog;

//用来实现数据库的操作 连接、释放数据库 通用的增删改查

public class DatabaseAction {

Dog dog = new Dog();

Connection conn = null;

// 连接数据库 张三

public Connection getConnection() {

String url = "jdbc:mysql://localhost:3306/test?"

+ "user=root&password=root&useUnicode=true&characterEncoding=UTF8";

try {

Class.forName("com.mysql.jdbc.Driver");

conn = DriverManager.getConnection(url);

} catch (ClassNotFoundException | SQLException e) {

e.printStackTrace();

} // 动态加载mysql驱动

return conn;

}

// 向数据库插入信息

public int zhuce(Dog dog) {

conn = this.getConnection();

String sql = "insert into dogs () values(" + dog.getNumber() + ",'" + dog.getName() + "','" + dog.getSex()

+ "'," + dog.getAge() + ",'" + dog.getStrain() + "','" + dog.getBingqingzhuangtai() + "')";

Statement st;

int result = 0;

try {

st = conn.createStatement();

result = st.executeUpdate(sql);

} catch (SQLException e) {