basedao.java

简单的企业宣传的网站

package 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\\SQLEXPRESS:2008;databasename=company";
	public final static String name="sa";
	public final static String pwd="123";
	public Connection getConn()throws ClassNotFoundException,SQLException
	{
		Class.forName(driver);
		Connection conn=DriverManager.getConnection(url,name,pwd);
		return conn;
	}
	public void closeAll(Connection conn,PreparedStatement pstmt,ResultSet rs)
	{
		if(rs!=null)
		{
			try {
				rs.close();
			} catch (SQLException e) {
				// TODO 自动生成 catch 块
				e.printStackTrace();
			}
		}
		if(pstmt!=null)
		{
			try {
				pstmt.close();
			} catch (SQLException e) {
				// TODO 自动生成 catch 块
				e.printStackTrace();
			}
		}
		if(conn!=null)
		{
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO 自动生成 catch 块
				e.printStackTrace();
			}
		}
	}
	public int excuteSQL(String sql,String[]param)
	{
		Connection conn=null;
		PreparedStatement pstmt=null;
		int num=0;
		try {
			conn=this.getConn();
			pstmt=conn.prepareStatement(sql);
			if(param!=null)
			{
				for(int i=0;i<param.length;i++)
				{
					pstmt.setString(i+1, param[i]);
				}
			}
			num=pstmt.executeUpdate();
		} catch (ClassNotFoundException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		return num;
	}
}