jdbc数据库连接

来源：互联网发布：阿里云数据盘克隆编辑：程序博客网时间：2024/05/02 02:57

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
* http://www.cnblogs.com/wuyuegb2312/p/3872607.html 不错的jdbc介绍博客
* http://www.cnblogs.com/S-E-P/archive/2010/09/20/2045053.html 通用Dao实现
* http://blog.csdn.net/luxiaoyu_sdc/article/details/7361714 DBUtils不错的总结说明
* @author 01
*
*/
public final class JDBCUtils {
   private static final String Driver = "jdbc.mysql.jdbc.Driver";
   private static final String url = "jdbc:mysql://localhost:3306/dbName";
   private static final String user = "root";
   private static final String password = "root";
   private static Connection conn = null;
   private static PreparedStatement ps = null;     //SQL 语句被预编译并存储在 PreparedStatement 对象中
   private static ResultSet rs = null;

   private JDBCUtils(){

   }
   static{
       try {
           Class.forName(Driver);
       } catch (ClassNotFoundException e) {
           System.out.println("找不到驱动程序类，加载驱动失败");
           e.printStackTrace();
       }
   }


   public static Connection getConnetion(){
       try {
           conn = DriverManager.getConnection(url, user, password);
       } catch (SQLException e) {
           System.out.println("数据库连接失败");
           e.printStackTrace();
       }
       return conn;

   }


   public static void release(Connection conn,PreparedStatement ps,ResultSet rs){
       if(conn!=null){
           try {
               conn.close();
           } catch (SQLException e) {
               e.printStackTrace();
           }
       }

       if(ps!=null){
           try {
               ps.close();
           } catch (SQLException e) {
               e.printStackTrace();
           }
       }

       if(rs!=null){
           try {
               rs.close();

           } catch (SQLException e) {
               e.printStackTrace();
           }
       }
   }

}

使用properties配置文件
注意事项：配置项等号后面值均无双引号””，否则你的程序执行了不会报错，
但是没有任何反映，自动终止。

首先新建一个 jdbc.properties，新建目录为Java 项目下的scr文件夹下。
以记事本格式打开，并写入如下信息：
Driver=com.mysql.jdbc.Driver
url=jdbc\:mysql\://localhost\:3306/myProTest
user=root
password=123456

package com.jdbc;

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;

public class JDBCProperties {
   private static String Driver = null;
   private static String url = null;
   private static String user = null;
   private static String password = null;
   private Connection conn = null;

   static{
       Properties properties = new Properties();
       InputStream is =
               JDBCProperties.class.getResourceAsStream("/jdbc.properties");
       try {
           properties.load(is);
           Driver = properties.getProperty("Driver");
           url = properties.getProperty("url");
           user = properties.getProperty("user");
           password = properties.getProperty("password");
           Class.forName(Driver);
       } catch (IOException e) {
           e.printStackTrace();
       } catch (ClassNotFoundException e) {
           e.printStackTrace();
       }finally{
           if(is!=null){
               try {
                   is.close();
               } catch (IOException e) {
                   e.printStackTrace();
               }
           }
       }

   }

   public Connection getConnection(){
       try {
           conn = DriverManager.getConnection(url, user, password);
           if(conn!=null){
               System.out.println("数据库连接成功");
           }
       } catch (SQLException e) {
           e.printStackTrace();
       }
       return conn;

   }

   public static void main(String[] args) {
       JDBCProperties jdbcp = new JDBCProperties();
       jdbcp.getConnection();

   }

}

0 0