Java的条件查询

[liyankaipoi]

条件查询的具体步骤是什么

[自由自在_Yu]

创建链接--->预编译--->执行查询--->接收结果

public static void getConnect(){
		String username = "root";
		String password = "123";
		String url = "jdbc:mysql://localhost:3306/test";
		String driver = "com.mysql.jdbc.Driver";
		Connection con = null;
		PreparedStatement stat = null;
		ResultSet rs = null;
		try {
			Class.forName(driver).newInstance();
			
			con = DriverManager.getConnection(url,username,password);
			
			String sql = "select * from user where name = ? ";
			
			stat = con.prepareStatement(sql);
			
			stat.setString(1, "11");
			
			rs = stat.executeQuery();
			
			List<Map<String,Object>> list = new ArrayList<Map<String,Object>>();
			ResultSetMetaData data = rs.getMetaData();
			int count = data.getColumnCount();
			while(rs.next()){								
				Map<String, Object> rowData = new HashMap<String, Object>();
				for (int i = 1; i < count; i++) {
					rowData.put(data.getColumnName(i),rs.getObject(i));
				}
				list.add(rowData);
			}
			System.out.println(list);
		} catch (InstantiationException e) {
			e.printStackTrace();
		} catch (IllegalAccessException e) {
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}