connectdb.java

学生信息管理系统

package conn;

import java.io.*;
import java.util.*;
import java.sql.*;
import javax.sql.*;
import com.microsoft.jdbc.sqlserver.*;
import com.microsoft.jdbcx.sqlserver.*;

public class ConnectDB
{
	
	private static DataSource dataSource = getDataSource(DBConstants.FILENAME);
	 
	public static DataSource getDataSource(String xmlFileName)
	{
		DataSource dataSource = new SQLServerDataSource();
		ConnXMLParser connXMLParser = new ConnXMLParser();
		try
		{
			connXMLParser.readXML(xmlFileName,dataSource);	
		}
		catch(Exception e)
		{
			e.printStackTrace(); 
		}
		return dataSource;
	}
	
	public static Connection getConnection()
	{
		Connection conn = null;
	
		try
		{
			conn = dataSource.getConnection();	
		}
		catch(Exception e)
		{
			e.printStackTrace(); 
		}
		return conn;
	}
	public static int executeUpdate(String sql)
	{
		int result = 0;
		try
		{
			Connection conn = getConnection();
			Statement stmt =conn.createStatement();
			result = stmt.executeUpdate(sql);	
			conn.close();
		}
		catch(SQLException sqle)
		{
			sqle.printStackTrace();
		}
		return result;
	}	
}