java连接MySQl数据库实例代码__catch_printStackTrace_Auto-generated_SQLException_Connection_

当前位置: 编程技术>java/j2ee

java连接MySQl数据库实例代码

来源: 互联网发布时间：2014-10-28

本文导语: 代码如下:package com.abc.dao; 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.Dr...

代码如下:

package com.abc.dao;

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();
   }
}
}