连接epet数据库并查询epet中的数据

import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class SelectMain {
	private static final String DRIVER_CLASS = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
	private static final String URL = "jdbc:sqlserver://localhost:1433;databaseName = epet";
	private static final String USERNAME = "sa";
	private static final String PASSWORD = "sa";
	private static final String USERNAE = null;
	static {
		try {
			Class.forName(DRIVER_CLASS);
			System.out.println("获取驱动成功！");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	public Connection getConnection() throws Exception{
		Connection conn = DriverManager.getConnection(URL,USERNAME,PASSWORD);
		return conn;
		
	}
    public static void main(String[] args) {
	     DBUtil db = new DBUtil();
    	try {
			
    		Connection conn = db.getConnection();
			Statement stmt = conn.createStatement();//创建执行sql语句的对象
    		ResultSet rst = stmt.executeQuery("select * from dog");//把查询的数据放在结果集ResultSet中
			System.out.println("显示信息：");
			while(rst.next()) {//结果集中有一个next()方法 可以指向每一条数据
				System.out.print(rst.getInt(1)+"\t");//可以获取列信息，但是注意数据类型
				System.out.print(rst.getString(2)+"\t");
				System.out.print(rst.getInt(3) + "\t");//数字表示第几列
				System.out.print(rst.getInt("love")+"\t");//如果括号中存放的是字符串，表示的是
				System.out.println(rst.getString(5));
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	
    }
}