溫馨提示×
您好，登錄后才能下訂單哦！
點擊 登錄注冊 即表示同意《億速云用戶服務條款》
您好，登錄后才能下訂單哦！
【重點】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","4ik4i5jkwwmxij0lyjl3hmlx3kkyyi1ii10iih33");
//新浪云mysql數據庫JDBC連接語句（云數據庫地址和端口固定“w.rdc.sae.sina.com.cn:3307”web應用名稱前面要加上app_ 然后找到web應用設置類似0ww4ox1l0n的數據庫登錄名和類似4ik4i5jkwwmxij0lyjl3hmlx3kkyyi1ii10iih33這樣的數據庫登錄密碼）
【一】下面是我自己的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","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;
}
}
免責聲明：本站發布的內容（圖片、視頻和文字）以原創、轉載和分享為主，文章觀點不代表本網站立場，如果涉及侵權請聯系站長郵箱：is@yisu.com進行舉報，并提供相關證據，一經查實，將立刻刪除涉嫌侵權內容。
