ORACLE数据库应用JDBC连接

JDCB连接ORACLE数据库代码

Java代码：

1. package com.syxp.dns.common;

3. import java.sql.Connection;

4. import java.sql.DriverManager;

5. import java.sql.PreparedStatement;

6. import java.sql.ResultSet;

7. import java.sql.SQLException;

9. import org.apache.log4j.Logger;

11. /**

12. * 数据库连接类

13. * @author 张君宝

14. *

15. */

16. public class JDBCConnection {

18. //驱动名

19. private static String ORACLE_DRIVER = "oracle.jdbc.driver.OracleDriver";

20. //连接路径

21. private static String ORACLE_URL = "jdbc:oracle:thin:@192.168.1.189:1521:orcl";

22. //用户名

23. private static String ORACLE_USERNAME = "iams";

24. //密码

25. private static String ORACLE_PASSWORD = "Syxp1111";

26. //连接参数

27. private static Connection conn = null;

28. //日志信息

29. private static Logger logger = Logger.getLogger(JDBCConnection.class);

31. /**

32. * 获取数据库连接

33. * @return

34. * @throws ClassNotFoundException

35. * @throws SQLException

36. */

37. public Connection getConnection() throws ClassNotFoundException,SQLException{

38. //加载驱动

39. Class.forName(ORACLE_DRIVER);

40. //得到连接

41. conn = DriverManager.getConnection(ORACLE_URL, ORACLE_USERNAME, ORACLE_PASSWORD);

42. logger.info("成功连接Oracle数据库");

43. return conn;

44. }

46. /**

47. * 关闭数据库连接

48. * @param rs

49. * @param pstmt

50. * @param conn

51. */

52. public void close(ResultSet rs , PreparedStatement pstmt , Connection conn) throws SQLException{

53. if(rs!=null){

54. rs.close();

55. }

56. if(pstmt!=null){

57. pstmt.close();

58. }

59. if(conn!=null&&!conn.isClosed()){

60. conn.close();

61. }

62. logger.info("成功关闭资源");

63. }

65. /**

66. * 测试方法

67. * @param args

68. */

69. public static void main(String[] args) {

70. JDBCConnection jdbcConnection = new JDBCConnection();

71. try {

72. jdbcConnection.getConnection();

73. ResultSet rs = null;

74. PreparedStatement pstmt = null;

75. jdbcConnection.close(rs, pstmt, conn);

76. } catch (ClassNotFoundException e) {

77. // TODO Auto-generated catch block

78. e.printStackTrace();

79. } catch (SQLException e) {

80. // TODO Auto-generated catch block

81. e.printStackTrace();

82. }

83. }

---更多Java学习资料可关注微信公众号：kaigexuetang_com（长按可复制关注)