sql.java

学校课程管理系统

package com.sevenEleven.javaBean.teacher;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.DriverManager;
public class SQL {
	/**
	 * @uml.property  name="conn"
	 */
	private Connection conn;
	/**
	 * @uml.property  name="smtp"
	 */
	private Statement smtp;
	/**
	 * @uml.property  name="rs"
	 */
	private ResultSet rs;
	
	public SQL(){
		try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
			this.conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=school","sa","sa");
			smtp = this.conn.createStatement();
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (InstantiationException e) {
			e.printStackTrace();
		} catch (Exception e) {
			e.printStackTrace();
		} 
	}
	
	public int ExeUpdate(String strSQL){
		int count = 0;
		try {
			count = smtp.executeUpdate(strSQL);
		} catch (SQLException e) {
			e.printStackTrace();
			return count;
		} catch (Exception e){
			return count;
		}
		return count;
	}
	
	public ResultSet ExeSelect(String strSQL){
		try {
			rs = smtp.executeQuery(strSQL);
		} catch (SQLException e) {
			e.printStackTrace();
			return null;
		} catch (Exception e){
			return null;
		}
		return rs;
	}
	
	public void Close(){
		try {
			if (rs!=null)
			rs.close();
			if (smtp!=null)
			smtp.close();
			if (conn!=null)
			conn.close();
		} catch (SQLException e) {
			e.printStackTrace();
			return;
		} catch (Exception e){
			return;
		}
	}

}