本人菜鸟,往大神们出招相助:
本人写了一个链接mysql数据库的DButils类,在Activity中可以顺利链接,但在Fragment中就无法连接,调试显示连接为空。且显示((MySQLNonTransientConnectionException)e).SQLState=Cannot find local variable 'e'。代码如下,请帮忙呀!DButils类:package com.example.asus.wechat;import android.util.Log;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;/**
* 数据库工具类:连接数据库用、获取数据库数据用
* 相关操作数据库的方法均可写在该类
*/
public class DBUtils { public static Connection connection=null;
private static String driver = "com.mysql.jdbc.Driver";// MySql驱动
private static PreparedStatement pds; private static String user = "root";// 用户名
private static String password = "888888";// 密码
/**
* 连接数据库
* */ public static Connection getConn(String dbName){
connection = null;
try{
Class.forName(driver);// 动态加载类
String ip = "10.0.2.2";// 写成10.0.2.2,不能写成localhost,因为手机的IP是loaclhost
// 尝试建立到给定数据库URL的连接
connection = DriverManager.getConnection("jdbc:mysql://" + ip + ":3306/" + dbName+"?useUnicode=true&characterEncoding=UTF-8&useSSL=false&autoReconnect=true&failOverReadOnly=false",
user, password);
}catch (Exception e){
e.printStackTrace();
}
return connection;
} /**
* 查询
* */ public static HashMap<String, Object> getInfoByName(String name){ HashMap<String, Object> map = new HashMap<>();
// 根据数据库名称,建立连接
Connection connection = getConn("dblearner"); try {
// mysql简单的查询语句。这里是根据MD_CHARGER表的NAME字段来查询某条记录
String sql = "select * from uase where name = ?";
// String sql = "select * from MD_CHARGER";
if (connection != null){// connection不为null表示与数据库建立了连接
PreparedStatement ps = connection.prepareStatement(sql);
if (ps != null){
// 设置上面的sql语句中的?的值为name
ps.setString(1, name);
// 执行sql查询语句并返回结果集
ResultSet rs = ps.executeQuery();
if (rs != null){
int count = rs.getMetaData().getColumnCount();
Log.e("DBUtils","列总数:" + count);
while (rs.next()){
// 注意:下标是从1开始的
for (int i = 1;i <= count;i++){
String field = rs.getMetaData().getColumnName(i);
map.put(field, rs.getString(field));
}
}
connection.close();
ps.close();
return map;
}else {
return null;
}
}else {
return null;
}
}else {
return null;
}
}catch (Exception e){
e.printStackTrace();
Log.e("DBUtils","异常:" + e.getMessage());
return null;
} }}
fragment_11.javapackage com.example.asus.wechat;import android.annotation.SuppressLint;
import android.app.Person;
import android.content.Context;
import android.net.Uri;
import android.os.Bundle;
import android.os.Handler;
import android.os.Message;
import android.support.v4.app.Fragment;
import android.util.Log;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.Button;
import android.widget.EditText;
import android.widget.ListView;
import android.widget.SimpleAdapter;
import android.widget.TextView;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;public class fragment_11 extends Fragment { private static final String ARG_PARAM1 = "param1";
private static final String ARG_PARAM2 = "param2"; private SimpleAdapter mAdpater;
private Button btn_get_data;
private TextView tv_data;
private EditText editText;
private Button ButAdd;
private Button ButSelect;
private EditText editid;
private EditText editname;
private EditText editpassword;
private EditText editsex;
private EditText editphote;
private Button ButDel;
private ListView lv;
private Button ButQue;
private Button ButNext;
private List<Person> lists;
private List<Map<String, Object>> data = new ArrayList<Map<String, Object>>(); // TODO: Rename and change types of parameters
private String mParam1;
private String mParam2; private OnFragmentInteractionListener mListener;
@SuppressLint("HandlerLeak")
private Handler handler = new Handler(){
@Override
public void handleMessage(Message msg) { switch (msg.what){
case 0x11:
String s = (String) msg.obj;
tv_data.setText(s);
break;
case 0x12:
String ss = (String) msg.obj;
tv_data.setText(ss);
break;
} }
}; public fragment_11() {
// Required empty public constructor
} /**
* Use this factory method to create a new instance of
* this fragment using the provided parameters.
*
* @param param1 Parameter 1.
* @param param2 Parameter 2.
* @return A new instance of fragment fragment_11.
*/
// TODO: Rename and change types and number of parameters
public static fragment_11 newInstance(String param1, String param2) {
fragment_11 fragment = new fragment_11();
Bundle args = new Bundle();
args.putString(ARG_PARAM1, param1);
args.putString(ARG_PARAM2, param2);
fragment.setArguments(args);
return fragment;
} @Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
if (getArguments() != null) {
mParam1 = getArguments().getString(ARG_PARAM1);
mParam2 = getArguments().getString(ARG_PARAM2);
}
} @Override
public View onCreateView(LayoutInflater inflater, ViewGroup container,
Bundle savedInstanceState) {
View view = inflater.inflate(R.layout.fragment_11, container, false);
btn_get_data = view.findViewById(R.id.btn_get_data);
tv_data =view. findViewById(R.id.tv_data);
editText=view.findViewById(R.id.editText); return view;
//return inflater.inflate(R.layout.fragment_11, container, false);
} // TODO: Rename method, update argument and hook method into UI event
public void onButtonPressed(Uri uri) {
if (mListener != null) {
mListener.onFragmentInteraction(uri);
}
}
@Override
public void onDetach() {
super.onDetach();
mListener = null;
} /**
* This interface must be implemented by activities that contain this
* fragment to allow an interaction in this fragment to be communicated
* to the activity and potentially other fragments contained in that
* activity.
* <p>
* See the Android Training lesson <a href=
* "http://developer.android.com/training/basics/fragments/communicating.html"
* >Communicating with Other Fragments</a> for more information.
*/
public interface OnFragmentInteractionListener {
// TODO: Update argument type and name
void onFragmentInteraction(Uri uri);
} public void onActivityCreated(Bundle savedInstanceState) {
// TODO Auto-generated method stub
super.onActivityCreated(savedInstanceState);
btn_get_data.setOnClickListener(new View.OnClickListener() { @Override
public void onClick(View v) { new Thread(new Runnable() { @Override
public void run() { HashMap<String, Object> map = DBUtils.getInfoByName(editText.getText().toString());
Message message = handler.obtainMessage();
if (map != null) {
String s = "";
for (String key : map.keySet()) {
s += key + ":" + map.get(key) + "\n"; }
message.what = 0x12;
message.obj = s;
} else {
message.what = 0x11;
message.obj = "查询结果为空";
}
// 发消息通知主线程更新UI
handler.sendMessage(message);
}
}).start(); }
}); }
}
本人写了一个链接mysql数据库的DButils类,在Activity中可以顺利链接,但在Fragment中就无法连接,调试显示连接为空。且显示((MySQLNonTransientConnectionException)e).SQLState=Cannot find local variable 'e'。代码如下,请帮忙呀!DButils类:package com.example.asus.wechat;import android.util.Log;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;/**
* 数据库工具类:连接数据库用、获取数据库数据用
* 相关操作数据库的方法均可写在该类
*/
public class DBUtils { public static Connection connection=null;
private static String driver = "com.mysql.jdbc.Driver";// MySql驱动
private static PreparedStatement pds; private static String user = "root";// 用户名
private static String password = "888888";// 密码
/**
* 连接数据库
* */ public static Connection getConn(String dbName){
connection = null;
try{
Class.forName(driver);// 动态加载类
String ip = "10.0.2.2";// 写成10.0.2.2,不能写成localhost,因为手机的IP是loaclhost
// 尝试建立到给定数据库URL的连接
connection = DriverManager.getConnection("jdbc:mysql://" + ip + ":3306/" + dbName+"?useUnicode=true&characterEncoding=UTF-8&useSSL=false&autoReconnect=true&failOverReadOnly=false",
user, password);
}catch (Exception e){
e.printStackTrace();
}
return connection;
} /**
* 查询
* */ public static HashMap<String, Object> getInfoByName(String name){ HashMap<String, Object> map = new HashMap<>();
// 根据数据库名称,建立连接
Connection connection = getConn("dblearner"); try {
// mysql简单的查询语句。这里是根据MD_CHARGER表的NAME字段来查询某条记录
String sql = "select * from uase where name = ?";
// String sql = "select * from MD_CHARGER";
if (connection != null){// connection不为null表示与数据库建立了连接
PreparedStatement ps = connection.prepareStatement(sql);
if (ps != null){
// 设置上面的sql语句中的?的值为name
ps.setString(1, name);
// 执行sql查询语句并返回结果集
ResultSet rs = ps.executeQuery();
if (rs != null){
int count = rs.getMetaData().getColumnCount();
Log.e("DBUtils","列总数:" + count);
while (rs.next()){
// 注意:下标是从1开始的
for (int i = 1;i <= count;i++){
String field = rs.getMetaData().getColumnName(i);
map.put(field, rs.getString(field));
}
}
connection.close();
ps.close();
return map;
}else {
return null;
}
}else {
return null;
}
}else {
return null;
}
}catch (Exception e){
e.printStackTrace();
Log.e("DBUtils","异常:" + e.getMessage());
return null;
} }}
fragment_11.javapackage com.example.asus.wechat;import android.annotation.SuppressLint;
import android.app.Person;
import android.content.Context;
import android.net.Uri;
import android.os.Bundle;
import android.os.Handler;
import android.os.Message;
import android.support.v4.app.Fragment;
import android.util.Log;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.Button;
import android.widget.EditText;
import android.widget.ListView;
import android.widget.SimpleAdapter;
import android.widget.TextView;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;public class fragment_11 extends Fragment { private static final String ARG_PARAM1 = "param1";
private static final String ARG_PARAM2 = "param2"; private SimpleAdapter mAdpater;
private Button btn_get_data;
private TextView tv_data;
private EditText editText;
private Button ButAdd;
private Button ButSelect;
private EditText editid;
private EditText editname;
private EditText editpassword;
private EditText editsex;
private EditText editphote;
private Button ButDel;
private ListView lv;
private Button ButQue;
private Button ButNext;
private List<Person> lists;
private List<Map<String, Object>> data = new ArrayList<Map<String, Object>>(); // TODO: Rename and change types of parameters
private String mParam1;
private String mParam2; private OnFragmentInteractionListener mListener;
@SuppressLint("HandlerLeak")
private Handler handler = new Handler(){
@Override
public void handleMessage(Message msg) { switch (msg.what){
case 0x11:
String s = (String) msg.obj;
tv_data.setText(s);
break;
case 0x12:
String ss = (String) msg.obj;
tv_data.setText(ss);
break;
} }
}; public fragment_11() {
// Required empty public constructor
} /**
* Use this factory method to create a new instance of
* this fragment using the provided parameters.
*
* @param param1 Parameter 1.
* @param param2 Parameter 2.
* @return A new instance of fragment fragment_11.
*/
// TODO: Rename and change types and number of parameters
public static fragment_11 newInstance(String param1, String param2) {
fragment_11 fragment = new fragment_11();
Bundle args = new Bundle();
args.putString(ARG_PARAM1, param1);
args.putString(ARG_PARAM2, param2);
fragment.setArguments(args);
return fragment;
} @Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
if (getArguments() != null) {
mParam1 = getArguments().getString(ARG_PARAM1);
mParam2 = getArguments().getString(ARG_PARAM2);
}
} @Override
public View onCreateView(LayoutInflater inflater, ViewGroup container,
Bundle savedInstanceState) {
View view = inflater.inflate(R.layout.fragment_11, container, false);
btn_get_data = view.findViewById(R.id.btn_get_data);
tv_data =view. findViewById(R.id.tv_data);
editText=view.findViewById(R.id.editText); return view;
//return inflater.inflate(R.layout.fragment_11, container, false);
} // TODO: Rename method, update argument and hook method into UI event
public void onButtonPressed(Uri uri) {
if (mListener != null) {
mListener.onFragmentInteraction(uri);
}
}
@Override
public void onDetach() {
super.onDetach();
mListener = null;
} /**
* This interface must be implemented by activities that contain this
* fragment to allow an interaction in this fragment to be communicated
* to the activity and potentially other fragments contained in that
* activity.
* <p>
* See the Android Training lesson <a href=
* "http://developer.android.com/training/basics/fragments/communicating.html"
* >Communicating with Other Fragments</a> for more information.
*/
public interface OnFragmentInteractionListener {
// TODO: Update argument type and name
void onFragmentInteraction(Uri uri);
} public void onActivityCreated(Bundle savedInstanceState) {
// TODO Auto-generated method stub
super.onActivityCreated(savedInstanceState);
btn_get_data.setOnClickListener(new View.OnClickListener() { @Override
public void onClick(View v) { new Thread(new Runnable() { @Override
public void run() { HashMap<String, Object> map = DBUtils.getInfoByName(editText.getText().toString());
Message message = handler.obtainMessage();
if (map != null) {
String s = "";
for (String key : map.keySet()) {
s += key + ":" + map.get(key) + "\n"; }
message.what = 0x12;
message.obj = s;
} else {
message.what = 0x11;
message.obj = "查询结果为空";
}
// 发消息通知主线程更新UI
handler.sendMessage(message);
}
}).start(); }
}); }
}
还有Fragment这样写不会崩溃吗?