package com.test;

import java.sql.*;

public class Test1 {

	public static void main (String []args){
		
		Connection ct = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		
		try {
			//1.加载驱动，写法固定
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
			//2.连接，1433是SQL Server默认的端口号，getConnection的参数依次填：连接字符串，数据库用户名，密码
			ct = DriverManager.getConnection
					("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=LiangshanHero", "sa", "123");
			//3.执行sql
			/*// 插入
			ps = ct.prepareStatement("insert into hero values(?,?,?,?,?,?)");
			ps.setInt(1, 10);
			ps.setString(2, "name");
			ps.setString(3, "nickname");
			ps.setString(4, "birthPlace");
			ps.setString(5, "female");
			ps.setInt(6, 200);
			int ret = ps.executeUpdate();
			if(ret == 1){
				System.out.println("insert success");
			}
			else {
				System.out.println("insert fail");
			}*/
			//查询
			ps = ct.prepareStatement("select * from hero");
			rs = ps.executeQuery();
			// 返回的是第一条记录之前的游标，所以要先next()一下
			while(rs.next()){
				String heroName = rs.getString("heroName");
				String heroNickname = rs.getString("heroNickname");
				int sal = rs.getInt("salary");
				System.out.println(heroName + " " + heroNickname + " " + sal);
			}
			
		} catch (ClassNotFoundException | SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			// 关闭资源，否则连接会一直存在，占用资源
			try{
				if(ps != null){
					ps.close();
				}
				if(ct != null){
					ct.close();
				}
			}catch(Exception e){
				 
			}
			
		}
	}
}

执行查询的结果：