简单的连接mysql的DB类

package cn.netcenter.test;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

 

 

public class DB {

public static Connection getConn(){

Connection conn=null;

try{

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

conn=DriverManager.getConnection("jdbc:mysql://localhost/bbs?user=root&password=112");

}catch(ClassNotFoundException e){

e.printStackTrace();

}catch(SQLException e){

e.printStackTrace();

}

return conn;

}

public static Statement getStatement(Connection conn){

Statement stmt=null;

try{

if(conn!=null)

stmt=conn.createStatement();

}catch(SQLException e){

e.printStackTrace();

}

return stmt;

}

public static ResultSet getResultSet(Statement stmt,String sql){

ResultSet rs=null;

try{

if(stmt !=null){

rs=stmt.executeQuery(sql);

}

}catch(SQLException e){

e.printStackTrace();

}

return rs;

}

/*

public static ResultSet getResultSet(Connection conn,String sql){

Statement stmt=getStatement(conn);

ResultSet rs=getResultSet(stmt,sql);

close(stmt);

return rs;

}*/

public static void close(Connection conn){

try{

if(conn !=null){

conn.close();

conn=null;

}

}catch(Exception e){

e.printStackTrace();

}

}

public static void close(Statement stmt){

try{

if(stmt !=null){

stmt.close();

stmt=null;

}

}catch(Exception e){

e.printStackTrace();

}

}

public static void close(ResultSet rs){

try{

if(rs !=null){

rs.close();

rs=null;

}

}catch(Exception e){

e.printStackTrace();

}

}

}

调用

public static void main(String[] args) {

// TODO Auto-generated method stub

Connection conn=DB.getConn();

Statement stmt=DB.getStatement(conn);

ResultSet rs=DB.getResultSet(stmt, "Select * from article");

try{

while(rs.next()){

System.out.println(rs.getString(2));

}

}catch(SQLException e){

e.printStackTrace();

}finally{

DB.close(rs);

DB.close(stmt);

DB.close(conn);

}

}