新浪云web項(xiàng)目數(shù)據(jù)庫(kù)連接及 封裝

【重點(diǎn)】Class.forName("com.mysql.jdbc.Driver");//數(shù)據(jù)庫(kù)連接語(yǔ)句聲明

conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/bbs","root","root"); //本地mysql數(shù)據(jù)庫(kù)JDBC連接語(yǔ)句（項(xiàng)目名bbs登錄名root密碼root）

conn = DriverManager.getConnection("jdbc:mysql://w.rdc.sae.sina.com.cn:3307/app_xiaoweibbs","0ww4ox1l0n","4ik4i5jkwwmxij0lyjl3hmlx3kkyyi1ii10iih33");

//新浪云mysql數(shù)據(jù)庫(kù)JDBC連接語(yǔ)句（云數(shù)據(jù)庫(kù)地址和端口固定“w.rdc.sae.sina.com.cn:3307”web應(yīng)用名稱前面要加上app_  然后找到web應(yīng)用設(shè)置類似0ww4ox1l0n的數(shù)據(jù)庫(kù)登錄名和類似4ik4i5jkwwmxij0lyjl3hmlx3kkyyi1ii10iih33這樣的數(shù)據(jù)庫(kù)登錄密碼）

【一】下面是我自己的bbs數(shù)據(jù)庫(kù)的封裝代碼:

package com.bjsxt.bbs;  //包名要記得改掉

import com.mysql.jdbc.Statement;

import java.sql.*;

public class DB {

    public static Connection getConn(){

    Connection conn = null;

try {

Class.forName("com.mysql.jdbc.Driver");

//conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/bbs","root","root");

conn = DriverManager.getConnection("jdbc:mysql://w.rdc.sae.sina.com.cn:3307/app_xiaoweibbs","0ww4ox1l0n","4ik4i5jkwwmxij0lyjl3hmlx3kkyyi1ii10iih33");

} catch (ClassNotFoundException e) {

e.printStackTrace();

}catch (SQLException e) {

e.printStackTrace();

e.printStackTrace();

}

    return conn;

    }

    public static Statement createStmt(Connection conn){

    Statement stmt = null;

    try {

            stmt = (Statement) conn.createStatement();

    } catch (SQLException e){

    e.printStackTrace();

    }

    return stmt;

    }

    public static ResultSet ExceruQuery(Statement stmt,String sql){

    ResultSet rs = null;

             try {

rs = stmt.executeQuery(sql);

} catch (SQLException e) {

e.printStackTrace();

}

    return rs;

    }

    public static int executeUpdate(Connection conn,String sql){

    int ret = 0;

    Statement stmt = null;

    try{

    stmt = (Statement) conn.createStatement();

    ret = stmt.executeUpdate(sql);

    }catch(SQLException e){

    e.printStackTrace();

    } finally {

    close(stmt);

    }

    return ret;

    }

    public static void close(Connection conn){

    if(conn != null){

    try {

conn.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

    }

    conn = null;

    }

    public static void close(Statement stmt){

    if(stmt != null){

    try {

stmt.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

    }

    stmt = null;

    }

    public static void close(ResultSet rs){

    if(rs != null){

    try {

rs.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

    }

    rs = null;

    }

    public static PreparedStatement PreparedStmt(Connection conn,String sql){

    PreparedStatement pstmt =null;

    try {

pstmt = conn.prepareStatement(sql);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

    return pstmt;

    }

    public static PreparedStatement PreparedStmt(Connection conn,String sql,int autoGeneratedKeys){

    PreparedStatement pstmt =null;

    try {

pstmt = conn.prepareStatement(sql,autoGeneratedKeys);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

    return pstmt;

    }

    public static void close(PreparedStatement pstmt){

    if(pstmt != null){

    try {

pstmt.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

    }

    pstmt = null;

    }

}