Java基础--JDBC-HashMap
来源:互联网 发布:gis软件开发基础 编辑:程序博客网 时间:2024/05/17 09:22
Java基础--JDBC-HashMap
package com.JDBCTest;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;public class QuerySession {private static final String url = "jdbc:mysql://119.254.106.50:3309/test?useUnicode=true&characterEncoding=utf8";private static final String user = "rw_all_db";private static final String password = "rw_all_db";/** * 获取连接 */public static Connection getConnection() {try {Class.forName("com.mysql.jdbc.Driver");//静态代码块实例化一个Driver对象Connection connection = DriverManager.getConnection(url, user, password);return connection;} catch (Exception e) {e.printStackTrace();return null;}}public static void closeConn(Connection connection,PreparedStatement statement,ResultSet rs) {try {if(rs!=null)rs.close();if(statement!=null)statement.close();if(connection!=null)connection.close();} catch (Exception e) {e.printStackTrace();}}public static List<HashMap<String, Object>> findData(String sql) {Connection connection = null;PreparedStatement statement = null;ResultSet rs = null;List<HashMap<String, Object>> users = null;try {connection = getConnection();statement = connection.prepareStatement(sql);rs = statement.executeQuery();users = new ArrayList<>();HashMap<String, Object> hashMap = null;while (rs.next()) {hashMap = new HashMap<>();hashMap.put("id", rs.getInt("id"));hashMap.put("username", rs.getString("username"));hashMap.put("address", rs.getString("address"));hashMap.put("birthday", rs.getString("birthday"));users.add(hashMap);}return users;} catch (Exception e) {e.printStackTrace();return null;} finally{closeConn(connection, statement, rs);}}public static List<HashMap<String, Object>> searchData(String sql2,String address,String username) {Connection connection = null;PreparedStatement statement = null;ResultSet rs = null;List<HashMap<String, Object>> users = null;try {connection = getConnection();statement = connection.prepareStatement(sql2);statement.setString(1, address);statement.setString(2, "%"+username+"%");rs = statement.executeQuery();users = new ArrayList<>();HashMap<String, Object> hashMap = null;while (rs.next()) {hashMap = new HashMap<>();hashMap.put("id", rs.getInt("id"));hashMap.put("username", rs.getString("username"));hashMap.put("address", rs.getString("address"));hashMap.put("birthday", rs.getString("birthday"));users.add(hashMap);}return users;} catch (Exception e) {e.printStackTrace();return null;} finally{closeConn(connection, statement, rs);}}public static HashMap<String, Object> findDataPK(String sql1,Integer id) {Connection connection = null;PreparedStatement statement = null;ResultSet rs = null;try {connection = getConnection();statement = connection.prepareStatement(sql1);statement.setInt(1, id);rs = statement.executeQuery();HashMap<String, Object> hashMap = null;if (rs.next()) {hashMap = new HashMap<>();hashMap.put("id", rs.getInt("id"));hashMap.put("username", rs.getString("username"));hashMap.put("address", rs.getString("address"));hashMap.put("birthday", rs.getString("birthday"));}return hashMap;} catch (Exception e) {e.printStackTrace();return null;} finally{closeConn(connection, statement, rs);}}public static void main(String[] args) {//String sql = "SELECT id,username,address,birthday FROM user;";//List<HashMap<String, Object>> users = findData(sql);//for (HashMap<String, Object> hashMap : users) {//System.out.println(hashMap.get("id")+"=>"+hashMap.get("username")+"=>"+hashMap.get("address")+"=>"+hashMap.get("birthday"));//}////String sql1 = "SELECT id,username,address,birthday FROM user where id = ?";//HashMap<String, Object> hashMap = findDataPK(sql1, 3);//if (hashMap != null) {//System.out.println(hashMap.get("id")+"=>"+hashMap.get("username")+"=>"+hashMap.get("address")+"=>"+hashMap.get("birthday"));//}String sql2 = "SELECT id,username,address,birthday FROM user where address = ? and username like ?";List<HashMap<String, Object>> users = searchData(sql2, "北京", "a");for (HashMap<String, Object> hashMap : users) {System.out.println(hashMap.get("id")+"=>"+hashMap.get("username")+"=>"+hashMap.get("address")+"=>"+hashMap.get("birthday"));}}}
0 0
- Java基础--JDBC-HashMap
- Java基础-了解HashMap
- java-基础-hashmap剖析
- 【Java基础】深入HashMap
- java基础-hashmap分析
- Java HashMap类基础
- 简谈JAVA基础--HashMap
- java基础之HashMap
- java基础----集合hashMap
- java 基础 集合 HashMap
- Java基础系列---hashmap
- java基础:关于JDBC
- java基础1-jdbc
- JAVA基础12--JDBC
- java基础 jdbc
- java基础-jdbc
- Java基础 — JDBC
- java-jdbc开发基础
- Brackets 是一个免费、开源且跨平台的 HTML/CSS/JavaScript 前端 WEB 集成开发环境 (IDE工具)
- 根据进程名杀死进程
- tinycore5.3配置总结
- 和 Thrift 的一场美丽邂逅
- 工厂方法模式
- Java基础--JDBC-HashMap
- 系统集成项目管理工程师—选择题重要知识点
- centos7 安装docker
- 拦截器实现对用户是否登录及登陆超时的验证
- 2016ICPC北京现场赛打铁退役之旅
- Integer与int的种种比较你知道多少?
- eclipse中的应用提交到github时:Can’t connect to any repository: not authorized
- 安装sql server 时设置sa 密码为空登录的问题
- DSP基础--定点小数运算[转载]