dbmanage.java

一个java项目

package com.xfaccp.htapp.hbm;
import java.sql.*;

import javax.servlet.jsp.jstl.sql.Result;
import javax.servlet.jsp.jstl.sql.ResultSupport;

public class DbManage {
	private static final String DRIVAER="com.microsoft.sqlserver.jdbc.SQLServerDriver";
	private static final String  URL="jdbc:sqlserver://localhost:1433;databaseName=hetb";	
	private static final String USD="sa";
	private static final String PWD="songjun";
	private static Connection getCon()
	{
		Connection con=null;
		try {
			Class.forName(DRIVAER);
			con=DriverManager.getConnection(URL,USD,PWD);
			return con;
		} catch (Exception e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
			return null;
		}

	}
	private static void close()throws Exception
	{
		Connection con=null;
		PreparedStatement pst=null;
		ResultSet rs=null;
		if(rs!=null)
		{
			rs.close();
		}
		if(pst!=null)
		{
			pst.close();
		}
		if(con!=null)
		{
			rs.close();
		}
	}
	public static boolean runnoneResultSet(String sql)
	{
		Connection con=null;
		PreparedStatement pst=null;
		try {
			con=getCon();
			pst=con.prepareStatement(sql);
			pst.executeUpdate();
			return true;
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
			return false;
		}
		finally
		{
			try {
				close();
			} catch (Exception e) {
				// TODO 自动生成 catch 块
				e.printStackTrace();
			}
		}
		
	}
	public static Result runHasResultSet(String sql)
	{
		Connection con=null;
		PreparedStatement pst=null;
		ResultSet rs=null;
		Result result=null;
		
		try {
			con=getCon();
			pst=con.prepareStatement(sql);
			rs=pst.executeQuery();
			result=ResultSupport.toResult(rs);
			return result;
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
			return null;
		}
		finally
		{
			try {
				close();
			} catch (Exception e) {
				// TODO 自动生成 catch 块
				e.printStackTrace();
			}
		}
		
		
	}
	
		
		
		
	

}