Java 数据库连接工具类(JDBC)
package\ dao;\nimport\ java.sql.Connection;\nimport\ java.sql.DriverManager;\nimport\ java.sql.SQLException;\npublic\ class\ jdbc\ {\n\tprivate\ static\ Connection\ cn=null;\n\tstatic\ {\n\t\ttry\ {\n\t\t\tClass.forName("com.mysql.cj.jdbc.Driver");\n\t\t}catch\ (ClassNotFoundException\ e)\ {\n\t\t\te.printStackTrace();\n\t\t\tSystem.out.println("检查驱动是否异常");\n\t\t}\n\t}\n\tpublic\ static\ Connection\ open()\ {\n\t\tString\ url\ =\ "jdbc:mysql://localhost:3306";\n\t\tString\ user\ =\ "root";\n\t\tString\ password\ =\ "123456";\n\t\ttry\ {\n\t\t\tcn\ =\ DriverManager.getConnection(url,user,password); // 修改:将创建的Connection对象赋值给cn变量\n\t\t}catch\ (SQLException\ e)\ {\n\t\t\te.printStackTrace();\n\t\t\tSystem.out.println("资源关闭失败");\n\t\t}\n\t\treturn\ cn;\n\t}\n\tpublic\ static\ Connection\ close()\ {\n\t\ttry\ {\n\t\t\tif\ (cn!=null&&cn.isClosed()){\n\t\t\t\tcn.close();\n\t\t\t}\n\t\t}catch\ (SQLException\ e)\ {\n\t\t\te.printStackTrace();\n\t\t\tSystem.out.println("关闭资源失败");\n\t\t}\n\t\treturn\ null;\n\t}\n}
原文地址: https://www.cveoy.top/t/topic/qFhu 著作权归作者所有。请勿转载和采集!