Navicat数据库连接

Navicat数据库连接

1. Eclipse连接数据库

public class Database {
	 	private static Connection con = null;
	 	public Database() {
	 		try {
		        Class.forName("com.mysql.jdbc.Driver");
		        System.out.println("Success");
		    }catch(Exception e) {
		        System.out.println("error");
		        e.printStackTrace();
		    }
		    try {
		    	con=DriverManager.getConnection( "jdbc:mysql://localhost:3308/software_system?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT","root","");
		        System.out.println("Success");
		//getConnection（）里面的格式为 jdbc:mysql//服务器地址/数据库名？编码方式  ，后面的2个参数分别是登陆用户名和密码
		        Statement stmt=con.createStatement();
		        ResultSet rs=stmt.executeQuery("select * from contact");
		        while(rs.next()) {
		            System.out.println(rs.getString("cid"));
		        }

		    }catch(SQLException e) {
		        
		    }
	}
		public static Connection getCon() {
			return con;
		}
}

2. IDEA连接数据库

public class ConnectionDao {
    public ArrayList<User> getList() throws ClassNotFoundException, SQLException {
        Class.forName("com.mysql.cj.jdbc.Driver");
        String url = "jdbc:mysql://localhost:3308/javaee?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai";
        String username = "root";
        String password = "";
        Connection conn = DriverManager.getConnection(url,username,password);

        String sql = "SELECT * FROM user";
        Statement statement = conn.createStatement();
        ResultSet rs = statement.executeQuery(sql);

        ArrayList<User> users = new ArrayList<>();
        while(rs.next()){
            User user = new User();
            user.setId(rs.getInt("id"));
            user.setNickname(rs.getString("nickname"));
            user.setPassword(rs.getString("password"));
            users.add(user);
        }
        return users;
    }
}