jdbc.java

JFreechart 饼图源代码

package com.mwq.database;

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
 * @author mwq
 * 
 */
public class JDBC {

	private static final String DRIVERCLASS = "com.microsoft.jdbc.sqlserver.SQLServerDriver";

	protected final String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=db_FABD05";

	protected final String username = "sa";

	protected final String password = "";

	public Connection conn;

	public Statement stmt;

	public PreparedStatement prpdStmt;

	public CallableStatement cablStmt;

	public ResultSet rs;

	static {
		try {
			Class.forName(DRIVERCLASS);
		} catch (ClassNotFoundException e) {
			System.out.println("------ 在加载数据库驱动时抛出异常，内容如下：");
			e.printStackTrace();
		}
	}

	public boolean openConn() {
		boolean isOpen = true;
		try {
			conn = DriverManager.getConnection(url, username, password);
		} catch (SQLException e) {
			isOpen = false;
			System.out.println("------ 在创建数据库连接时抛出异常，内容如下：");
			e.printStackTrace();
		}
		return isOpen;
	}

	public boolean closeConn() {
		boolean isCommit = true;
		try {
			conn.commit();
		} catch (SQLException e) {
			isCommit = false;
			System.out.println("------ 在提交数据库事务时抛出异常，内容如下：");
			e.printStackTrace();
			try {
				conn.rollback();
			} catch (SQLException e1) {
				System.out.println("------ 在回滚数据库事务时抛出异常，内容如下：");
				e1.printStackTrace();
			}
		} finally {
			try {
				conn.close();
			} catch (SQLException e) {
				System.out.println("------ 在关闭数据库连接时抛出异常，内容如下：");
				e.printStackTrace();
			}
		}
		return isCommit;
	}

}