亚洲在线久爱草,狠狠天天香蕉网,天天搞日日干久草,伊人亚洲日本欧美

為了賬號安全，請及時綁定郵箱和手機立即綁定

JDBCUtils如何寫

那個JDBCUtils工具類如何寫，求大神指點

正在回答

3 回答

http://img1.sycdn.imooc.com//5aaf24dc000104dd07720096.jpg這咋整?

0 回復 有任何疑惑可以回復我~

謝謝你

0 回復 有任何疑惑可以回復我~

版本1：

import java.sql.Connection;

import java.sql.SQLException;

import javax.sql.DataSource;

import com.mchange.v2.c3p0.ComboPooledDataSource;


public class JDBCUtil {

????private static DataSource dataSource = new ComboPooledDataSource();

????public static DataSource getDataSource() {

????????return dataSource;

????}

????public static Connection getConnection() throws SQLException {

????????return dataSource.getConnection();

????}

}

版本2：

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;


public class JDBCUtil1 {

????private static String url = "jdbc:mysql://localhost:3306/regist_web";

????private static String user = "root";

????private static String password = "test123";

????private JDBCUtil1() {}

static {

????????try {

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

????????} catch (ClassNotFoundException e) {

????????// TODO Auto-generated catch block

????????e.printStackTrace();

????????}

}

????public static Connection getConnection() {

????????try {

????????????return DriverManager.getConnection(url, user, password);

????????} catch (SQLException e) {

????????????// TODO Auto-generated catch block

????????????e.printStackTrace();

????????return null;

????????}

????}


????public static void free(ResultSet rs,Statement st,Connection conn) {

????????if(rs != null) {

????????????try {

????????????????rs.close();

????????????} catch (SQLException e) {

????????????????// TODO Auto-generated catch block

????????????e.printStackTrace();

????????????} finally {

????????????????if(st != null) {

????????????????????try {

????????????????????????st.close();

????????????????????} catch (SQLException e) {

????????????????????????// TODO Auto-generated catch block

????????????????????????e.printStackTrace();

????????????????????} finally {

????????????????????????if(conn != null) {

????????????????????????????????try {

????????????????????????????????????conn.close();

????????????????????????????????} catch (SQLException e) {

????????????????????????????????????// TODO Auto-generated catch block

????????????????????????????????????e.printStackTrace();

????????????????????????????????}

????????????????????????}

????????????????}

????????}

????}

}

}

}

視頻中用的是版本1，我用版本1在daoImpl（）里有點問題，所以我用的是版本2。

0 回復 有任何疑惑可以回復我~
#1

瀟湘魅

非常感謝?。。。。。。。?/div>
2018-01-23 回復 有任何疑惑可以回復我~

舉報

0/150
提交
取消

JDBCUtils如何寫

我要回答 關注問題
微信客服

購課補貼
聯系客服咨詢優惠詳情

 幫助反饋 APP下載

慕課網APP
您的移動學習伙伴

 公眾號

掃描二維碼
關注慕課網微信公眾號