devbox
小丑西瓜9
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

android连接mysql数据库_安卓联接数据库

作者：小丑西瓜9 | 2024-04-24 16:39:52

赞

踩

安卓联接数据库

在android中我们是可以连接mysql数据库的。连接方式如下:

1.首先我们需要导入mysql驱动jar包下载地址：

链接：https://pan.baidu.com/s/1PV9jV9m3LLjXeLfSE5ChOg 
提取码：3v2q

 2.连接数据库的代码：

  1. package com.demo.take.dao;
  2.  
  3. import android.util.Log;
  4.  
  5.  
  6. import java.sql.Connection;
  7. import java.sql.DriverManager;
  8. import java.sql.ResultSet;
  9. import java.sql.SQLException;
  10. import java.sql.Statement;
  11.  
  12.  
  13. public class DBUtil {
  14.  
  15.     private static String diver = "com.mysql.jdbc.Driver";
  16.     private static String url = "jdbc:mysql://192.168.0.199:3306/school_take?characterEncoding=utf-8";
  17.     private static String user = "root";//用户名
  18.     private static String password = "root";//密码
  19.  
  20.     /*
  21.      * 连接数据库
  22.      * */
  23.     public static Connection getConn() {
  24.         Connection conn = null;
  25.         try {
  26.             Class.forName(diver);
  27.             conn = (Connection) DriverManager.getConnection(url, user, password);//获取连接
  28.             Log.e("getConn", "连接成功");
  29.         } catch (ClassNotFoundException e) {
  30.             Log.e("getConn", e.getMessage(), e);
  31.             e.printStackTrace();
  32.         } catch (SQLException e) {
  33.             Log.e("getConn", e.getMessage(), e);
  34.             e.printStackTrace();
  35.         }
  36.         return conn;
  37.     }
  38.  
  39.     public static void close(Statement state, Connection conn) {
  40.         if (state != null) {
  41.             try {
  42.                 state.close();
  43.             } catch (SQLException e) {
  44.                 e.printStackTrace();
  45.             }
  46.         }
  47.  
  48.         if (conn != null) {
  49.             try {
  50.                 conn.close();
  51.             } catch (SQLException e) {
  52.                 e.printStackTrace();
  53.             }
  54.         }
  55.     }
  56.  
  57.     public static void close(ResultSet rs, Statement state, Connection conn) {
  58.         if (rs != null) {
  59.             try {
  60.                 rs.close();
  61.             } catch (SQLException e) {
  62.                 e.printStackTrace();
  63.             }
  64.         }
  65.  
  66.         if (state != null) {
  67.             try {
  68.                 state.close();
  69.             } catch (SQLException e) {
  70.                 e.printStackTrace();
  71.             }
  72.         }
  73.  
  74.         if (conn != null) {
  75.             try {
  76.                 conn.close();
  77.             } catch (SQLException e) {
  78.                 e.printStackTrace();
  79.             }
  80.         }
  81.     }
  82.  
  83. }

 3.下面给出一个增删改查的类

  1. //用户数据库连接类
  2. public class UserDao {
  3.  
  4.     //新增
  5.     public static boolean add(UserBean bean) {
  6.         String sql = "insert into user(user_name,phone,create_date,password)values('" + bean.getUser_name() + "','" + bean.getPhone() + "','" + bean.getCreate_date() + "','" + bean.getPassword() + "')";
  7.         Connection conn = DBUtil.getConn();
  8.         Statement state = null;
  9.         boolean f = false;
  10.         int a = 0;
  11.         try {
  12.             state = conn.createStatement();
  13.             a = state.executeUpdate(sql);
  14.         } catch (Exception e) {
  15.             Log.e("add->", e.getMessage(), e);
  16.             e.printStackTrace();
  17.         } finally {
  18.             DBUtil.close(state, conn);
  19.         }
  20.         if (a > 0) {
  21.             f = true;
  22.         }
  23.         return f;
  24.     }
  25.  
  26.     //删除
  27.     public static boolean delete(UserBean bean) {
  28.         String sql = "delete from user where id=" + bean.getId();
  29.         Connection conn = DBUtil.getConn();
  30.         Statement state = null;
  31.         boolean f = false;
  32.         int a = 0;
  33.         try {
  34.             state = conn.createStatement();
  35.             a = state.executeUpdate(sql);
  36.         } catch (Exception e) {
  37.             Log.e("delete->", e.getMessage(), e);
  38.             e.printStackTrace();
  39.         } finally {
  40.             DBUtil.close(state, conn);
  41.         }
  42.         if (a > 0) {
  43.             f = true;
  44.         }
  45.         return f;
  46.     }
  47.  
  48.  
  49.     //修改
  50.     public static boolean update(UserBean bean) {
  51.  
  52.         String sql = "update user set " + "user_name='" + bean.getUser_name() + "', phone='" + bean.getPhone() + "', create_date='" + bean.getCreate_date() + "', password='" + bean.getPassword() + "' where id='" + bean.getId() + "'";
  53.         Connection conn = DBUtil.getConn();
  54.         Statement state = null;
  55.         boolean f = false;
  56.         int a = 0;
  57.         try {
  58.             state = conn.createStatement();
  59.             a = state.executeUpdate(sql);
  60.         } catch (Exception e) {
  61.             Log.e("update->", e.getMessage(), e);
  62.             e.printStackTrace();
  63.         } finally {
  64.             DBUtil.close(state, conn);
  65.         }
  66.         if (a > 0) {
  67.             f = true;
  68.         }
  69.         return f;
  70.     }
  71.  
  72.     //获取列表
  73.     public static List<UserBean> getListByPhone(String phone) {
  74.  
  75.         //结果存放集合
  76.         List<UserBean> list = new ArrayList<>();
  77.         //MySQL 语句
  78.         String sql = "select * from user where phone=" + phone;
  79.         Connection conn = DBUtil.getConn();
  80.         Statement state = null;
  81.         ResultSet rs = null;
  82.         boolean f = false;
  83.         int a = 0;
  84.         try {
  85.             state = conn.createStatement();
  86.             rs = state.executeQuery(sql);
  87.             Log.e("getListByPhone->","getListByPhone");
  88.             while (rs.next()) {
  89.                 UserBean bean = new UserBean();
  90.                 bean.setId(rs.getInt("id"));
  91.                 bean.setUser_name(rs.getString("user_name"));
  92.                 bean.setPhone(rs.getString("phone"));
  93.                 bean.setPassword(rs.getString("password"));
  94.                 bean.setCreate_date(rs.getString("create_date"));
  95.                 list.add(bean);
  96.                 Log.e("getListByPhone->",bean.toString());
  97.  
  98.             }
  99.         } catch (Exception e) {
  100.             Log.e("getListByPhone->", e.getMessage(), e);
  101.             e.printStackTrace();
  102.         } finally {
  103.             DBUtil.close(rs, state, conn);
  104.         }
  105.         if (a > 0) {
  106.             f = true;
  107.         }
  108.         return list;
  109.     }
  110.  
  111.     //获取列表
  112.     public static List<UserBean> getList() {
  113.  
  114.         //结果存放集合
  115.         List<UserBean> list = new ArrayList<>();
  116.         //MySQL 语句
  117.         String sql = "select * from user";
  118.         Connection conn = DBUtil.getConn();
  119.         Statement state = null;
  120.         ResultSet rs = null;
  121.         boolean f = false;
  122.         int a = 0;
  123.         try {
  124.             state = conn.createStatement();
  125.             rs = state.executeQuery(sql);
  126.             while (rs.next()) {
  127.                 UserBean bean = new UserBean();
  128.                 bean.setId(rs.getInt("id"));
  129.                 bean.setUser_name(rs.getString("user_name"));
  130.                 bean.setPhone(rs.getString("phone"));
  131.                 bean.setPassword(rs.getString("password"));
  132.                 bean.setCreate_date(rs.getString("create_date"));
  133.                 list.add(bean);
  134.  
  135.             }
  136.         } catch (Exception e) {
  137.             Log.e("update->", e.getMessage(), e);
  138.             e.printStackTrace();
  139.         } finally {
  140.             DBUtil.close(rs, state, conn);
  141.         }
  142.         if (a > 0) {
  143.             f = true;
  144.         }
  145.         return list;
  146.     }
  147.  
  148.  
  149. }

4.下面是对应的用户实体类

  1. package com.demo.take.bean;
  2.  
  3. import java.io.Serializable;
  4. //用户实体类
  5. public class UserBean implements Serializable {
  6.     //主键
  7.     private int id;
  8.     //用户姓名
  9.     private String user_name;
  10.     //手机号
  11.     private String phone;
  12.     //密码
  13.     private String password;
  14.     //创建时间
  15.     private String create_date;
  16.  
  17.     public String getCreate_date() {
  18.         return create_date;
  19.     }
  20.  
  21.     public void setCreate_date(String create_date) {
  22.         this.create_date = create_date;
  23.     }
  24.  
  25.     public int getId() {
  26.         return id;
  27.     }
  28.  
  29.     public void setId(int id) {
  30.         this.id = id;
  31.     }
  32.  
  33.     public String getUser_name() {
  34.         return user_name;
  35.     }
  36.  
  37.     public void setUser_name(String user_name) {
  38.         this.user_name = user_name;
  39.     }
  40.  
  41.     public String getPhone() {
  42.         return phone;
  43.     }
  44.  
  45.     public void setPhone(String phone) {
  46.         this.phone = phone;
  47.     }
  48.  
  49.     public String getPassword() {
  50.         return password;
  51.     }
  52.  
  53.     public void setPassword(String password) {
  54.         this.password = password;
  55.     }
  56.  
  57.     @Override
  58.     public String toString() {
  59.         return "UserBean{" +
  60.                 "id=" + id +
  61.                 ", user_name='" + user_name + '\'' +
  62.                 ", phone='" + phone + '\'' +
  63.                 ", password='" + password + '\'' +
  64.                 '}';
  65.     }
  66. }

5.然后呢mysql数据库是需要自己去安装的，安装完数据库根据实体类创建对应的表，连接上就可以调用了。如下：

注意 ：1.mysql安装需要安装5版本的，高版本连不上。

            2.android连接mysql需要再子线程中去执行。

项目下载地址：android发布任务小项目-Android文档类资源-CSDN下载

如果有啥不明白可以加qq：332872622

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/小丑西瓜9/article/detail/480480?site
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号