basedao.java

来自「这是一个网上基于JAVA的订餐系统」· Java 代码 · 共 49 行

package s2jsp.lg.Dao;

import java.sql.*;

public class BaseDao {

	public final static String Driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";// 获得驱动
	public final static String Url = "jdbc:sqlserver://localhost:1433;DatabaseName=eat;user=sa;password=sa";

	public static Connection getConn() {
		Connection con = null;
		try {
			Class.forName(Driver);
			con = DriverManager.getConnection(Url);

		} catch (ClassNotFoundException ex) {
			ex.getStackTrace();
		} catch (SQLException ex) {
			ex.getStackTrace();
		}
		return con;

	}

	public static void closeAll(ResultSet rSet, PreparedStatement pStatement,
			Connection con) {
		if (rSet != null) {
			try {
				rSet.close();
			} catch (SQLException e) {
			}
		}
		if (pStatement != null) {

			try {
				pStatement.close();
			} catch (SQLException e) {
			}
		}
		if (con != null) {
			try {
				con.close();
			} catch (SQLException e) {
			}
		}
	}

}