db.java

来自「简单的日志分析工具」· Java 代码 · 共 66 行

package db; 

import java.sql.Connection; 
import java.sql.DriverManager; 
import java.sql.PreparedStatement;
import java.sql.ResultSet;



public class Db { 
String url = "jdbc:mysql://localhost/rizhi"; //数据源

String username = "root"; 

String password = "root"; 

String drivername = "org.gjt.mm.mysql.Driver"; //驱动

Connection con=null;

public  Db() { 

try { 
Class.forName(drivername); 
con = DriverManager.getConnection(url, username, password); 
//if(con!=null){
    //System.out.println("连接成功!");
   //}else{
   // System.out.println("连接失败!");
  //} 

}
catch (Exception e) { 
e.printStackTrace(); 
} 
} 
public void closeConnection(Connection con){
	try{
		if(con!=null)con.close();
	}catch(Exception e){
		e.printStackTrace();
	}
}

//
public void closePrepStmt(PreparedStatement prepStmt){
	try{
		if(prepStmt!=null) prepStmt.close();
	}catch(Exception e){
		e.printStackTrace();
	}
}

//关闭数据集
public void closeResultSet(ResultSet rs){
	try{
		if(rs!=null) rs.close();
	}catch(Exception e){
		e.printStackTrace();
	}
}


}