java通过jdbc连接数据库

一，导入mysql包

mysql-connector-java-5.0.8-bin.jar

二，封装DBUtils

建立DBUtils工具类

public class DBUtil {
    private static String url = "jdbc:mysql://localhost:3306/java?&useSSL=true&charset=utf-8";
    private static String user = "root";
    private static String password = "123456";
    private static  String driver = "com.mysql.jdbc.Driver";

    static {
        try {
            Class.forName(driver);
        }catch (Exception e){
            e.printStackTrace();
        }
    }
// 创建连接
    public static Connection getConn() throws Exception{
        Connection conn = DriverManager.getConnection(url,user,password);
        return conn;
    }
// 关闭连接
    public static  void close(ResultSet set, PreparedStatement statement, Connection conn){
        if (set != null){
            try {
                set.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        if (statement != null){
            try {
                statement.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        if (conn != null){
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}

//   单元测试/白盒测试
public static void main(String[] args) {
    try {
        get_Conn();
    } catch (SQLException e) {
        e.printStackTrace();
    }
}
}

注意：运行结束后要关闭

三，实体类

public class User {
    private  int id;
    private String username;
    private String password;


    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    @Override
    public String toString() {
        return "User{" +
                "username='" + username + '\'' +
                ", password='" + password + '\'' +
                '}';
    }
}

四，dao层接口

public interface UserDao {
    List<User> findAll();
    void addUser(String username,String passowrd);
}

五，UserDaoImpl实现类

public class UserDaoImpl implements UserDao {
    Connection conn = null;
    PreparedStatement state = null;
    ResultSet set = null;
    User user = null;
    User user1 = null;

    @Override
    public List<User> findAll() {
        List<User> userList = new ArrayList<>();
        try {
            conn = DBUtil.getConn();
            state = conn.prepareStatement("select * from tb_user");
            set = state.executeQuery();
            while (set.next()){
                user = new User();
                user.setUsername(set.getString("username"));
                user.setPassword(set.getString("password"));
                userList.add(user);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }finally {
            DBUtil.close(set,state,conn);
        }

        return userList;
    }

    @Override
    public void addUser(String username,String password) {
        List<User> userList = new ArrayList<>();
        try {
            conn = DBUtil.getConn();
            state = conn.prepareStatement("insert into tb_user value (?,?)");
            state.setString(1,username);
            state.setString(2,password);
            set = state.executeQuery();

        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

//测试运行
public static void main(String[] args) {
    UserDaoImpl us = new UserDaoImpl();
    us.findAll();
}
}