安卓连接MySQL

public class MainActivity extends AppCompatActivity {


    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        new Thread(runnable).start();

    }

    Runnable runnable = new Runnable() {

        private Connection con = null;

        @Override

        public void run() {

            // TODO Auto-generated method stub

            try {

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

                //引用代码此处需要修改，address为数据IP，Port为端口号，DBName为数据名称，UserName为数据库登录账户，Password为数据库登录密码

  con = DriverManager.getConnection("jdbc:mysql://192.168.1.202:3306/b2b", "root", 
 "123");

 } catch (SQLException e) {

                // TODO Auto-generated catch block

                System.out.println(e.getMessage());

            } catch (ClassNotFoundException e) {

                // TODO Auto-generated catch block

                System.out.println(e.getMessage());

            }
            try {

                insert("weishuyong", 12, con);


            } catch (Exception e) {

            }


        }


    };


    private static void insert(String name, int age, Connection con) {



        PreparedStatement pstmt;
        try {
            Statement st = con.createStatement();
            String sql = "select * from alarm_plan_type where id = 1";
            ResultSet res = st.executeQuery(sql);
            if (res == null) {

            } else {
                List<User> users = new ArrayList<>();
                if(res.next()==false);
                do{
                    User user = new User();
                    user.setSexy(res.getString("id"));
                    user.setName(res.getString("type"));
                    user.setId(res.getString("type_name"));

                    users.add(user);
                    Log.i("TAG", user.getId());
                }while (res.next());
                res.close();
                st.close();
                con.close();

            }
        } catch (Exception e) {
            e.printStackTrace();
            Log.d("TAG", "数据库操作异常");

        }
    }
}