//java連接MySQl數(shù)據(jù)庫實(shí)例代碼
package com.abc.dao;
/*dkplus專業(yè)搜集和編寫實(shí)用電腦軟件教程，
*搜集各種軟件資源和計(jì)算機(jī)周邊，獨(dú)立制作視頻和ppt和音頻微信公眾號(hào)，
*點(diǎn)擊進(jìn)入 dkplus官方博客 （java網(wǎng)絡(luò)編程http://dkplus.iteye.com），
*微信搜索dkplus關(guān)注公眾號(hào)可獲取海量計(jì)算機(jī)周邊資源。*/
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
 
public class BaseDao {
 public Connection getConn()
 {
 Connection conn=null;
 try {
  Class.forName("com.mysql.jdbc.Driver");
 } catch (ClassNotFoundException e) {
  // TODO Auto-generated catch block
  e.printStackTrace();
 }
 String url="jdbc:mysql://127.0.0.1:3306/user";
 try {
  conn=DriverManager.getConnection(url, "root", "");
 } catch (SQLException e) {
  // TODO Auto-generated catch block
  e.printStackTrace();
 } 
 return conn;
 }
 public void closeAll(ResultSet rs,Statement stat,Connection conn)
 {
 if(rs!=null)
  try {
  rs.close();
  } catch (SQLException e) {
  // TODO Auto-generated catch block
  e.printStackTrace();
  }
 if(stat!=null)
  try {
  stat.close();
  } catch (SQLException e) {
  // TODO Auto-generated catch block
  e.printStackTrace();
  }
 if(conn!=null)
  try {
  conn.close();
  } catch (SQLException e) {
  // TODO Auto-generated catch block
  e.printStackTrace();
  }
 }
}