学步园

public class test {  
    public static void main(String[] args) {  
        try {  
            String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";     //加载JDBC驱动   
            Class.forName(driverName).newInstance();  
            String url = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=test";//连接本机SQLServer服务器的master库，端口为默认的1433 
            String userName = "sa";     //登录账号  
            String userPwd = "123";     //密码   
            Connection conn = DriverManager.getConnection(url, userName,userPwd);                
            java.sql.Statement stmt =conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);  
            String sql = "select * from table1"; // 表  
            String sql2="INSERT INTO table1 VALUES ('Gates', 'Bill')";  
            stmt.execute(sql2);  
            ResultSet rs = ((java.sql.Statement) stmt).executeQuery(sql);                
            while (rs.next()) {  
                System.out.println(rs.getString(1)+"    "+rs.getString(2)); // 取得第一列和第二列的值  
            }  
            rs.close();  
            stmt.close();  
            conn.close();  
        } catch (Exception e) {  
            e.printStackTrace();   
            System.out.println(e.getMessage());  
        }  
    }  
} 

本文出自 “阿凡达” 博客，请务必保留此出处http://shamrock.blog.51cto.com/2079212/843337