链接:https://pan.baidu.com/s/1UFfqy_mN2tnz8Q4Fclmwqw
提取码:yrk1
复制这段内容后打开百度网盘手机App,操作更方便哦
package bean;
import java.util.HashMap;
import java.util.Iterator;
import java.util.Map;
import java.util.Set;
import zsgc.cha;
public class HashMapTest4
{
public static void main(String[] args)
{
//String [][] tableVales={}; //数据
cha h1 = new cha();
HashMap<String ,String> map = h1.chaxun();
int a= map.size();
String [][] tableVales = new String[a][a];
String [] xxx= new String[a];
int xx=0;
String [] yyy = new String[a];
int yy=0;
Set set = map.entrySet();
for(Iterator iter = set.iterator(); iter.hasNext();)
{
Map.Entry entry = (Map.Entry)iter.next();
String key = (String)entry.getKey();
String value = (String)entry.getValue();
xxx[xx] = key;
yyy[yy] = value;
++xx;
++yy;
System.out.println(key +" " + value);
}
for(int i=0;i<a;i++)
{
tableVales[i][0]=xxx[i];
System.out.println("hahaha"+xxx[i]);
}
for(int y=0;y<a;y++)
{
tableVales[y][1]= yyy[y];
System.out.println("xixixi" + yyy[y]);
}
for(int z=0;z<a;z++)
{
for(int c=0;c<2;c++)
{
System.out.println("jiahnag"+tableVales[z][c]);
}
System.out.println("\n");
}
}
}
package bean;
public class user {
private String name;
private String password;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
package dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class mysql {
public boolean lianjie (String a, String b)
{
boolean aa= false;
int bb = 0;
Connection con = null;
Statement stmt;
ResultSet rs;
final String URL= "jdbc:mysql://localhost:3306/java?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=false";
final String NAME="root";//登录名
final String PASSWORD="123456";//密码
try {
Class.forName("com.mysql.cj.jdbc.Driver");
} catch (ClassNotFoundException e) {
System.out.println("未能成功加载驱动程序,请检查是否导入驱动程序!");
//添加一个println,如果加载驱动异常,检查是否添加驱动,或者添加驱动字符串是否错误
e.printStackTrace();
}
try {
con = DriverManager.getConnection(URL, NAME, PASSWORD);
System.out.println("获取数据库连接成功!");
} catch (SQLException e) {
System.out.println("获取数据库连接失败!");
//添加一个println,如果连接失败,检查连接字符串或者登录名以及密码是否错误
e.printStackTrace();
}
//数据库打开后就要关闭
if(con!=null)
{
try {
stmt = con.createStatement();
rs = stmt.executeQuery("select name,password from user");
while (rs.next()) {
String name = rs.getString(1);
String password = rs.getString(2);
//System.out.println("666");
//System.out.println(a);
//System.out.println(b);
//System.out.println(name);
//System.out.println(password);
if(name.equals(a))
{
if(password.equals (b))
{
bb=1;
}
System.out.println("666");
//bb = 1;
//return aa;
}
}
// 释放相关的资源
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
con=null;
}
}
if(bb==1)
{
aa=true;
}
return aa;
}
}
package dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class mysql1 {
public boolean chaxun(String a, String b)
{
Connection con = null;
Statement stmt;
ResultSet rs;
final String URL= "jdbc:mysql://localhost:3306/java?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=false";
final String NAME="root";//登录名
final String PASSWORD="123456";//密码
try {
Class.forName("com.mysql.cj.jdbc.Driver");
} catch (ClassNotFoundException e) {
System.out.println("未能成功加载驱动程序,请检查是否导入驱动程序!");
//添加一个println,如果加载驱动异常,检查是否添加驱动,或者添加驱动字符串是否错误
e.printStackTrace();
}
try {
con = DriverManager.getConnection(URL, NAME, PASSWORD);
System.out.println("获取数据库连接成功!");
} catch (SQLException e) {
System.out.println("获取数据库连接失败!");
//添加一个println,如果连接失败,检查连接字符串或者登录名以及密码是否错误
e.printSt