安卓連接服務(wù)器mysql的DBhelper代碼分享
時(shí)間:2021年12月22日
瀏覽:次
private static String driver = "com.mysql.jdbc.Driver";//MySQL 驅(qū)動(dòng)
private static String url = "jdbc:mysql://IP:3306/數(shù)據(jù)庫(kù)";//MYSQL數(shù)據(jù)庫(kù)連接Url
private static String user = "root";//用戶名
private static String password = "root";//密碼
/**
* 連接數(shù)據(jù)庫(kù)
* */
public static Connection getConn(){
Connection conn = null;
try {
Class.forName(driver);//獲取MYSQL驅(qū)動(dòng)
conn = (Connection) DriverManager.getConnection(url, user, password);//獲取連接
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
/**
* 關(guān)閉數(shù)據(jù)庫(kù)
* */
public static void closeAll(Connection conn, PreparedStatement ps){
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (ps != null) {
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
/**
* 關(guān)閉數(shù)據(jù)庫(kù)
* */
public static void closeAll(Connection conn, PreparedStatement ps, ResultSet rs){
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (ps != null) {
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}