JDBC调用数据库 查询操作

package com.cn.test1;
import java.sql.*;
public class okay{
	public static void main(String args[]){
		Connection ct=null;
		PreparedStatement ps=null;
		ResultSet rs=null;
		 try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");//加载驱动
			ct=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=clerk","sa","1");//建立连接
			ps=ct.prepareStatement("select * from emp");
			rs=ps.executeQuery();
			while (rs.next()){
				System.out.println(rs.getString(2)+" "+rs.getFloat(6));
				
			}
		} catch ( Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
				try{
					if(rs!=null){
						rs.close();
						rs=null;
						
					}
					if(ps!=null){
						ps.close();
						ps=null;
					}
					if(ct!=null){
						ct.close();
						ct=null;
					}
				}catch (Exception e){
					e.printStackTrace();
				}
			
		}
 	
	}
}

执行结果：

smith 800.0
ALLEN 1600.0
WARD 1250.0
JONES 2975.0
MARTIN 1250.0
BLAKE 2850.0
CLARK 2450.0
SCOTT 3000.0
king 5000.0
turner 1500.0
adama 1100.0
james 950

sqlserver数据库的emp表如下：

.0