課程
/后端開發(fā)
/Java
/Java實(shí)現(xiàn)郵箱驗(yàn)證
那個(gè)JDBCUtils工具類如何寫,求大神指點(diǎn)
2017-06-04
源自:Java實(shí)現(xiàn)郵箱驗(yàn)證 4-3
正在回答
這咋整?
謝謝你
版本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.DriverManager;
import java.sql.ResultSet;
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() {
????????????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
????????????} 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()里有點(diǎn)問題,所以我用的是版本2。
瀟湘魅
舉報(bào)
本視頻教程主要介紹如何使用JavaMail進(jìn)行郵箱驗(yàn)證,由淺入深
1 回答JDBCUtils里面getDataSouce()方法
1 回答如圖,請(qǐng)問這個(gè) 如何解決,百度了好久沒搞好
1 回答在mac上如何配置郵箱服務(wù)器呀
2 回答如何通過代碼獲取郵件的發(fā)送狀態(tài)及已讀未讀狀態(tài)
2 回答配置文件怎么寫?。?/p>
Copyright ? 2025 imooc.com All Rights Reserved | 京ICP備12003892號(hào)-11 京公網(wǎng)安備11010802030151號(hào)
購課補(bǔ)貼聯(lián)系客服咨詢優(yōu)惠詳情
慕課網(wǎng)APP您的移動(dòng)學(xué)習(xí)伙伴
掃描二維碼關(guān)注慕課網(wǎng)微信公眾號(hào)
2018-03-19
2017-06-18
謝謝你
2017-06-07
版本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()里有點(diǎn)問題,所以我用的是版本2。