月光之城sp1吧 关注:35贴子:929
  • 3回复贴,共1

【有关java】java连接数据库~~~

只看楼主收藏回复

package ll.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBCon {
      
       /**
       * 驱动程序
       */
       private static String driver="com.mysql.jdbc.Driver";
       /**
       * 连接数据库的URL
       */
       private static String url="jdbc:mysql://localhost:3306/onlineexam";
       /**
       * 用户名
       */
       private static String username="root";
       /**
       * 密码
       */
       private static String password="r00tb0x";
       //private static String password="123456";
       /**
       * 数据库连接对象
       */
       private static Connection con;
       /**
       * 获得数据库连接
       * @return 数据库连接,可能
       */
       public static Connection getCon() {
              try {
                     Class.forName(driver);
                     if (con == null || con.isClosed()) {
                            System.out.println("建立新的数据库连接");
                            con = DriverManager.getConnection(url, username, password);
                     }
              } catch (ClassNotFoundException e) {
                     System.out.println("驱动程序找不到,原因:"+ e.getMessage());



1楼2011-01-12 11:51回复
                  } catch (SQLException e) {
                         System.out.println("连接数据库失败,原因:"+ e.getMessage());
                  }
                  DBCon.closeCon();
                  return con;
           }
           /**
           * 关闭数据连接
           */
           public static void closeCon() {
                  try {
                         if (con != null || !con.isClosed()) {
                                con.close();
                                System.out.println("已关闭数据库连接");
                         }
                  } catch (SQLException e) {
                         System.out.println("关闭数据库连接失败,原因:"+ e.getMessage());
                  }
           }
          
    }
    


    2楼2011-01-12 11:51
    回复
      呵呵呵呵呵呵呵呵呵


      3楼2011-01-20 18:21
      回复
        这个还真有点看不懂


        IP属地:北京4楼2011-01-23 14:49
        回复