/*数据库驱动*/ static final String JDBC_DRIVER="com.mysql.cj.jdbc.Driver"; /*数据库url*/ static final String DB_URL="jdbc:mysql://1.1.1.1:3308/ssss_aa_bb?serverTimezone=GMT%2B8&rewriteBatchedStatements=true&allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8&useSSL=false"; //数据库名与密码 static final String user="root"; static final String pass="12345678"; public static void main(String[] args){ Connection conn=null; Statement stmt=null; try { //注册驱动 Class.forName(JDBC_DRIVER); System.out.println("-----连接数据库----"); //打开连接 conn= DriverManager.getConnection(DB_URL,user,pass); //执行查询user表数据 stmt=conn.createStatement(); String sql; sql="select OBJECT_ID,SYSUSER_NAME from plat_object_sysuser"; ResultSet rs=stmt.executeQuery(sql); //数据输出 while(rs.next()){ int id=rs.getInt("OBJECT_ID" ); String name=rs.getString("SYSUSER_NAME"); System.out.println("ID="+id); System.out.println("用户名="+name); System.out.println(); } //完成并关闭数据库 rs.close(); stmt.close(); conn.close(); System.out.println("查询结束关闭数据库"); } catch (ClassNotFoundException e) { e.printStackTrace(); }catch (SQLException se){ se.printStackTrace(); } }