import java.sql.Connection;
//引java类包
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DUBtil2 {
// 静态状块.特殊:类加载时候执行一次
static {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
//异常处理
e.printStackTrace();
}
}
public static int update(String sql) {
// update连接数据库
Connection conn = null;
PreparedStatement stmt = null;
String url = "jdbc:mysql://127.0.0.1/cms";
// cms为所要连接的数据库名
int rs = 0;
try {
conn = DriverManager.getConnection(url, "root", "root");
//root,root为用户名与密码
stmt = conn.prepareStatement(sql);
//连接准备
rs = stmt.executeUpdate();
// 执行连接
} catch (SQLException e) {
e.printStackTrace();
//异常处理
} finally {
try {
stmt.close();
conn.close();
// 关闭连接
} catch (SQLException e) {
e.printStackTrace();
}
}
return rs;
}
public static Connection getConn() {
//取得连接
Connection conn = null;
String url = "jdbc:mysql://127.0.0.1/cms";
try {
conn = DriverManager.getConnection(url, "root", "root");
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
public static void free(ResultSet rs, Statement stmt, Connection conn) {
// 释放,关闭连接
try {
if (rs != null) {
rs.close();
}
if (stmt != null) {
stmt.close();
}
if (conn != null) {
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DUBtil2 {
}