Z02的连接类

来源：互联网发布：led改字软件编辑：程序博客网时间：2024/04/30 00:11

package com.pz.util;

import java.sql.*;

public class Database {

private static String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
private static String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=sfxt";
private static String username="sa";
private static String password="13974224803";

private static ThreadLocal connection = new ThreadLocal();

public synchronized static Connection getConnection()throws SQLException {

  Connection con = (Connection)connection.get();
  if (con != null && !con.isClosed()) {
   return con;
  }
  try {
   Class.forName(driver);
   con = DriverManager.getConnection(url, username, password);
   //con.setAutoCommit(false);
   connection.set(con);
   return con;
  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  }
  return null;
}
public static void commit(){     //提交
  Connection con = (Connection)connection.get();
  try {
   con.commit();
  } catch (SQLException e) {
   e.printStackTrace();
  }
}
public static void rollback() {    //回滚
  Connection con = (Connection)connection.get();
  try {
   con.rollback();
  } catch (SQLException e) {
   e.printStackTrace();
  }
}
public synchronized static void releaseConnection(Connection connection) {   //释放
  try {
   if (connection != null && !connection.isClosed())
    connection.close();
  } catch (SQLException e) {
   e.printStackTrace();
  }
  connection = null;
}
public static void main(String[] args) {
  try {
   Database.getConnection();   //getConnection()为本类的同步静态方法
  } catch (SQLException e) {
   e.printStackTrace();
  }
}

}