剑指jdbc

各数据库的驱动及url

mysql数据库

驱动 ：com.mysql.jdbc.Driver
url : jdbc:mysql://IP地址:3306/数据库名
jar : mysql-connector-java-5.1.25.jar

sqlserver数据库

驱动 ： com.microsoft.jdbc.sqlserver.SQLServerDriver
url : jdbc:microsoft:sqlserver://IP地址:1433;DatabaseName=数据库名
jar : sqljdbc*.jar

oracle数据库

驱动 ：oracle.jdbc.driver.OracleDriver
url : jdbc:oracle:thin://IP地址:1521:数据库名
jar : ojdbc-**.jar

署上博主封装的jdbcDao

public class BaseDAO {

	private static final String JDBC_DRIVER = "驱动";

	private static final String URL = "url";
	private static final String USER = "用户名";
	private static final String PASSWD = "密码";

	private static Connection conn = null;
	private static Statement st = null;
	private static PreparedStatement pst = null;

	static{
		class.forName(JDBC_DRIVER);
	}
	/**
	 * 获得数据库连接
	 * 
	 * @return
	 */
	private Connection getConn() {
		try {
			conn = DriverManager.getConnection(URL, USER, PASSWD);
			conn.setAutoCommit(false);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return conn;
	}
	public Statement getStatement() {
		try {
			st = getConn().createStatement();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return st;
	}
	public PreparedStatement getPrepareStatement(String sql) {
		try {
			pst = getConn().prepareStatement(sql);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return pst;
	}
	public void commit() {
		try {
			conn.commit();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	public void rollback() {
		try {
			conn.rollback();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	public void close() {
		try {
			if (st != null)
				st.close();
			if (pst != null)
				pst.close();
			if (conn != null)
				conn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	public void close(ResultSet rs) {
		try {
			if (rs != null)
				rs.close();
			if (st != null)
				st.close();
			if (pst != null)
				pst.close();
			if (conn != null)
				conn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}

致言

现在做项目基本上都是用框架，博主封装的DAO仅供参考学习，也欢迎大家提出宝贵的意见！