java学生信息管理+SqlServer数据库连接

SQL Server连接数据库工具类代码

package jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ResourceBundle;
/**

• JDBC工具类
• @author 谢小涛

*/
public class JDBCUtil {

private static String url="com.microsoft.sqlserver.jdbc.SQLServerDriver";
private static String Driver="jdbc:sqlserver://localhost:1433;databaseName=java连接测试";
private static String user="sa";
private static String passwrod="123456";

private static Connection conn=null;
private static Statement stamt=null;
private static PreparedStatement pstamt=null;
private static ResultSet rs=null;

static {
	try {
		Class.forName(url);
	} catch (ClassNotFoundException e) {		
		e.printStackTrace();
	}
}

public static Connection getConnection() {
	try {
		conn=DriverManager.getConnection(Driver, user, passwrod);
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	return conn;
}

public static void close(Statement stamt,Connection conn) {
	if (stamt !=null) {
		try {
			stamt.close();
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	if (conn!=null) {
		try {
			conn.close();
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}
public static void close(ResultSet rs, Statement stamt,Connection conn) {
	if (stamt !=null) {
		try {
			stamt.close();
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	if (conn!=null) {
		try {
			conn.close();
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	if (rs!&#