1.安装Mysql的驱动(这个可以去官网下载)
2.将下载好的mysql-connector-java.jar包复制放入项目中的lib文件夹中
右键选择添加为库:
sh
3.MYSQL数据库建立数据库
4.连接数据库
public class DBOpenHelper {
private static String diver = "com.mysql.jdbc.Driver";
private static String url = "jdbc:mysql://本机IP:3306/数据库?characterEncoding=utf-8";
private static String user = "root";//用户名
private static String password = "???";//密码
/*
* 连接数据库
* */
public static Connection getConn(){
Connection conn = null;
try {
Class.forName(diver);
conn = (Connection) DriverManager.getConnection(url,user,password);//获取连接
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
}
//连接数据库进行操作需要在主线程操作
new Thread(new Runnable() {
@Override
public void run() {
Connection conn = null;
conn =(Connection) DBOpenHelper.getConn();
String sql = "?????";//SQL语句
Statement st;
try {
st = (Statement) conn.createStatement();
ResultSet rs = st.executeQuery(sql);
while (rs.next()){
//此部分为数据操作
// 注意:下标是从1开始的
for (int i = 1; i <= count; i++) {
String field = rs.getMetaData().getColumnName(3);
map.put(field, rs.getString(field));
}
}
}
st.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}).start();