jdbcconnection mysql_(JDBCConnection.java)数据库连接操作库

package com.tool;

import java.sql.*;

public class JDBConnection {

private final static String dbDriver = "com.mysql.jdbc.Driver";

private final static String url = "jdbc:mysql://localhost:3306/db_database15";

private final static String userName = "username";

private final static String password = "password";

private Connection con = null;

public JDBConnection() {

try {

Class.forName(dbDriver).newInstance(); //加载数据库驱动

} catch (Exception ex) {

System.out.println("数据库加载失败");

}

}

//创建数据库连接

public boolean creatConnection() {

try {

con = DriverManager.getConnection(url, userName, password);

con.setAutoCommit(true);

} catch (SQLException e) {

System.out.println(e.getMessage());

System.out.println("creatConnectionError!");

}

return true;

}

//对数据库的增加、修改和删除的操作

public boolean executeUpdate(String sql) {

if (con == null) {

creatConnection();

}

try {

Statement stmt = con.createStatement();

int iCount = stmt.executeUpdate(sql);

System.out.println(sql);

System.out.println("操作成功，所影响的记录数为" + String.valueOf(iCount));

return true;

} catch (SQLException e) {

System.out.println(e.getMessage());

System.out.println("executeUpdaterError!");

return false;

}

}

//对数据库的查询操作

public ResultSet executeQuery(String sql) {

ResultSet rs;

try {

if (con == null) {

creatConnection();

}

Statement stmt = con.createStatement();

try {

rs = stmt.executeQuery(sql);

} catch (SQLException e) {

System.out.println(e.getMessage());

return null;

}

} catch (SQLException e) {

System.out.println(e.getMessage());

System.out.println("executeQueryError!");

return null;

}

return rs;

}

//关闭数据库的操作

public void closeConnection() {

if (con != null) {

try {

con.close();

} catch (SQLException e) {

e.printStackTrace(); //To change body of catch statement use File | Settings | File Templates.

System.out.println("Failed to close connection!");

} finally {

con = null;

}

}

}

}

分享到：

2008-06-05 09:26

浏览 2126

评论