|
|
package com; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class TestJDBC { private Connection con ; private String user = "gpadmin" ; private String password = "123456" ; private String className = "com.pivotal.jdbc.GreenplumDriver " ; private String url = "jdbc:pivotal:greenplum://172.20.4.161:5432;DatabaseName=testDB" ; public static void main(String[] args) { // TODO Auto-generated method stub TestJDBC c = new TestJDBC(); c.Connect(); c.getCon(); c.closed(); } public void Connect() { try { Class. forName(className); System. out.println("加载数据库驱动成功！" ); } catch (ClassNotFoundException e ) { System. out.println("加载数据库驱动失败！" ); e.printStackTrace(); } } /** 创建数据库连接 */ public Connection getCon() { try { con = DriverManager. getConnection(url, user, password); System. out.println("创建数据库连接成功！" ); } catch (SQLException e ) { System. out.print(con ); System. out.println("创建数据库连接失败！" ); con = null; e.printStackTrace(); } return con ; } public void closed() { try { if (con != null) { con.close(); } } catch (SQLException e ) { System. out.println("关闭con对象失败！" ); e.printStackTrace(); } } }
% J7 D1 t% S9 u4 Y" H: d. C
9 v0 H$ {/ }9 ~! B! c* @
% S+ Q8 d. t n r% ? c. G' R* P, C; H% K, y' {7 i9 N
- c, l) t: u& n( s8 S' S) p. Z# |& H- R) N
; a" B* s. U! X( a6 ?3 F4 r
4 ^& V$ Z2 v' k: U( E! T, b& c资源下载地址和密码（百度云盘）： [/hide] 百度网盘信息回帖可见
+ n r5 y% Y) X, Y; ^
1 K2 ?* B! d! d
( u5 i. o5 G: Z" U. d' x
$ Y* Z8 n: Q) `本资源由Java自学网收集整理【www.javazx.com】 |
|
[复制链接]
发表于 2022-7-25 08:30:01
