package com.sccp.StudentMS.DBtools;

import java.beans.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class DBtool {                    
	private static String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=student";

	private static String username = "sa";

	private static String password = "sa";

	private static Connection con = null;

	static PreparedStatement ps = null;

	static ResultSet rs = null;

	public static Connection getConnection() {
		try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
			return con = DriverManager.getConnection(url, username, password);
		} catch (Exception e) {
			e.printStackTrace();
			return null;
		}
	}
public   ResultSet getResult(String sql)
{
	con=getConnection();
	try {//System.out.println("jianlilianjiiezhiqian");
		ps=con.prepareStatement(sql);
		rs=ps.executeQuery();
		return rs;
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		System.out.println("getResult...."+e.toString());
	}
	return null;
	
	
}
public boolean executeSql(String sql)
{
	con=getConnection();
	try {
		ps=con.prepareStatement(sql);
		ps.executeUpdate();
		return  true;		  		
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	return false;
}
}