testjdbc.java

来自「JDBC连接数据库的简单源码 可以下载后来指点下有什么不足」· Java 代码 · 共 40 行

import java.sql.*;
public class TestJDBC {
public static void main(String[] args) {
     ResultSet rs = null;
     Statement stmt = null;
     Connection conn = null;
     try{
    	 Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
    	 conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=bujianhu","sa","gui");
    	 stmt= conn.createStatement();
    	 rs = stmt.executeQuery("select * from student");
    	 while(rs.next()){
    	 System.out.println(rs.getInt(1));
    	 System.out.print(rs.getString(2));
    	 }
     }catch (ClassNotFoundException e){
    	 e.printStackTrace();
     }catch (SQLException e){
    	 e.printStackTrace();
     }finally{
    	 try {
    		 if(rs!=null){
    			 rs.close();
    			 rs = null;
    		 }
    		 if(stmt!=null){
    			 stmt.close();
    			 stmt = null;
    		 }
    		 if(conn!=null){
    			 conn.close();
    			 conn = null;
    		 }
    	 }catch (SQLException e){
    		 e.printStackTrace();
    	 	}
     	}
	}
}