清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 | /** * 1 在方法中固化连接参数 * * @return 数据库连接 */ public Connection getConnection() { Connection conn = null ; try { Class.forName( "com.mysql.jdbc.Driver" ); conn = DriverManager.getConnection( "jdbc:mysql://localhost:3306/test" , "root" , "" ); return conn; } catch (Exception e) { e.printStackTrace(); } return null ; } /** * 2 通过方法参数方式传递连接参数 * * @return 数据库连接 */ public Connection getConnection(String driver, String url, String user, String password) { Connection conn = null ; try { Class.forName(driver); conn = DriverManager.getConnection(url, user, password); return conn; } catch (Exception e) { e.printStackTrace(); } return null ; } /** * 3 通过properties配置文件的方式灵活配置连接参数,properties中的属性名固化 * * @return 数据库连接 */ public Connection openConnection() { Connection conn = null ; String driver = "" ; String url = "" ; String user = "" ; String password = "" ; Properties props = new Properties(); try { props.load( this .getClass().getClassLoader() .getResourceAsStream( "db.properties" )); url = props.getProperty( "mysql_url" ); driver = props.getProperty( "mysql_driver" ); user = props.getProperty( "mysql_user" ); password = props.getProperty( "mysql_password" ); Class.forName(driver); conn = DriverManager.getConnection(url, user, password); return conn; } catch (Exception e) { e.printStackTrace(); } return null ; } |