新浪云 连接mysql数据库_新浪云web项目数据库连接及 封装

【重点】Class.forName("com.mysql.jdbc.Driver");//数据库连接语句声明

conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/bbs","root","root");//本地mysql数据库JDBC连接语句(项目名bbs登录名root密码root)

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

//新浪云mysql数据库JDBC连接语句(云数据库地址和端口固定“w.rdc.sae.sina.com.cn:3307”web应用名称前面要加上app_  然后找到web应用设置类似0ww4ox1l0n的数据库登录名和类似4ik4i5jkwwmxij0lyjl3hmlx3kkyyi1ii10iih23这样的数据库登录密码)

【一】下面是我自己的bbs数据库的封装代码:

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","4ik4i5jkwwmxij0lyjl3hmlx3kkyyi1ii10iih23");

} 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;

}

}