package com.mcong;
import java.sql.*;
import java.util.HashMap;
import java.util.Map;
/**
* Created by Smarter on 2017/12/6.
*/
public class BaseConnection {
public static Connection getConnection() {//用这个方法获取mysql的连接
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver");//加载驱动类
conn = DriverManager.
getConnection("jdbc:mysql://host:port/dbname", "usrname", "pwd");//(url数据库的IP地址,user数据库用户名,password数据库密码)
if (!conn.isClosed()) {
System.out.println("connect success!");
}
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
/**
* 增加数据,用不到~
*/
/**
* 删除数据
*/
public static void deletedata(int index, int id) //删除数据函数
{
Connection conn = getConnection();
try {
PreparedStatement psql; //还是用预处理
psql = conn.prepareStatement("delete from dbtable where id=?");
psql.setInt(index, id); //删除id=111115774的值
psql.executeUpdate();
psql.close();
} catch (SQLException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
} finally {
System.out.println("数据库数据删除成功!" + "\n");
}
}
/**
* 更新数据
*
* @param index1
* @param value1
* @param index2
* @param value2
* @throws SQLException
*/
public void updateData(int index1, String value1, int index2, String value2) throws SQLException {
/**
* 获取数据库连接
*/
Connection conn = getConnection();
String sqls = "update bizac set name=? where id=?";
PreparedStatement plsql = conn.prepareStatement(sqls);
plsql.setString(index1, value1);
plsql.setString(index2, value2);
// state.executeUpdate(sql); //将sql语句上传至数据库执行
plsql.executeUpdate();
plsql.close();
conn.close();//关闭通道
}
/**
* 查询数据
*
* @param id
* @throws SQLException 只能查询给定的参数,有需要增加的参数,写在while循环里,最后加到map集合,通过get取
*/
public void queryData(String id) throws SQLException {
Connection conn = getConnection();
String querysqls = "select * from bizacct where id=?";
PreparedStatement plsql = conn.prepareStatement(querysqls);
plsql.setString(1, id);
// state.executeUpdate(sql); //将sql语句上传至数据库执行
ResultSet rs = plsql.executeQuery();
while (rs.next()) {
String ids = rs.getString("id");
String phone = rs.getString("phone");
String status = rs.getString("status");
String login = rs.getString("login");
String intercode = rs.getString("intercode");
String part_type = rs.getString("part_type");
String part_key = rs.getString("part_key");
Map<String, String> params = new HashMap<String, String>();
params.put("id", ids);
params.put("phone", phone);
params.put("status", status);
params.put("login", login);
params.put("intercode", intercode);
params.put("part_type", part_type);
params.put("part_key", part_key);
System.out.println("params ======= " + params);
System.out.println(params.get("id"));
}
plsql.close();
conn.close();//关闭通道
}
public static void main(String[] args) throws SQLException {
BaseConnection baseConnection = new BaseConnection();
// 更新数据库
// baseConnection.updateData(1,"zhangsanssss", 2,"16286547");
// 查询数据库
baseConnection.queryData("16286547");
// 删除数据
// BaseConnection.deletedata(1,111115774);
}
}
参考:https://www.cnblogs.com/zhaotiancheng/p/6250184.html