package com.lj;

import java.sql.*;

public class LianJie {
	
	ResultSet rs = null;
	Statement stmt = null;
	Connection conn = null;

	public void Update(String sql) {
		try{
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;" +
				"DatabaseName=XXKGL","maobin","");
			stmt = conn.createStatement();
			stmt.executeUpdate(sql);	
		}catch(ClassNotFoundException e){
			e.printStackTrace();
		}catch(SQLException e) {
			e.printStackTrace();
		}
		
	}

	public ResultSet select(String sql) {
		try{
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;" +
				"DatabaseName=XXKGL","maobin","");
			stmt = conn.createStatement();
			rs = stmt.executeQuery(sql);
		}catch(ClassNotFoundException e){
			e.printStackTrace();
		}catch(SQLException e) {
			e.printStackTrace();
		}
		
		return rs;
	}
	public void closeConn(){
		
			try{
				if(rs != null){
					rs.close();
				}
				if(stmt != null){
					stmt.close();
				}
				if(conn != null){
					conn.close();
				}
			}catch(SQLException e){
				e.printStackTrace();
			}
		}

}