安卓JDBC连接数据库

1. 在AndroidMainfest.xml中添加请求访问网络的权限

<uses-permission android:name=”android.permission.INTERNET”/>

2. 在libs目录下导入jar包
3. 编写工具类

package com.example.mail.manager;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

public class DBLogin {
    private static String driver = "com.mysql.jdbc.Driver";//MySQL 驱动,需导入mysql-connector-java包
    private static final String url = "jdbc:mysql://192.168.175.1/mail?useSSL=false&useUnicode=true&characterEncoding=UTF-8";//MYSQL数据库连接Url
    private static String user = "local";//用户名
    private static String password = "123456";//密码

    private static Connection getConnection() {
        Connection conn = null;
        try {
            Class.forName(driver); //加载mysql驱动
            conn = DriverManager.getConnection(url,user, password);//与数据库建立连接
        } catch (SQLException ex) {
            ex.printStackTrace();
        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        }
        return conn;
    }

    public static boolean login(String id,String pwd) {
        Connection conn = getConnection();
        try {
            Statement st = conn.createStatement();
            String sql0= "select * from manager where manager_id ='" + id + "' and manager_pwd = '"+ pwd +"'";
            ResultSet res = st.executeQuery (sql0);
             if(res.next()){
                 conn.close();
                 st.close();
                 res.close();
                 return true;
               }
            else {
                 conn.close();
                 st.close();
                 res.close();
                 return false;
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return false;
    }

    public static ArrayList<String> getID() {
        Connection conn = getConnection();
        ArrayList<String> arr = new ArrayList<>();
        try {
            Statement st = conn.createStatement();
            String sql= "select username from user";
            ResultSet res = st.executeQuery (sql);

            while(res.next()){
                arr.add(res.getString("username"));
            }
            conn.close();
            st.close();
            res.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return arr;
    }

    public static ArrayList<String> insertUser(String name) {
        Connection conn = getConnection();
        ArrayList<String> arr = new ArrayList<>();
        try {
            Statement st = conn.createStatement();
            String sql= "select username from user";
            String sql1= "insert into user(username,smtp_state) values('"+name+"','1')";
            st.executeUpdate(sql1);
            ResultSet res = st.executeQuery (sql);

            while(res.next()){
                arr.add(res.getString("username"));
            }
            conn.close();
            st.close();
            res.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return arr;
    }

    public static void delele_user(String name){
        Connection conn = getConnection();
        try {
            Statement st = conn.createStatement();
            String sql= "delete from user where username = '"+name+"'";
            st.executeUpdate (sql);
            conn.close();
            st.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public static void on(String name){
        Connection conn = getConnection();
        try {
            Statement st = conn.createStatement();
            String sql= "update user set smtp_state = '1' where username = '"+name+"'";
            st.executeUpdate (sql);
            conn.close();
            st.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public static void off(String name){
        Connection conn = getConnection();
        try {
            Statement st = conn.createStatement();
            String sql= "update user set smtp_state = '0' where username = '"+name+"'";
            st.executeUpdate (sql);
            conn.close();
            st.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}