java eclipse 串連資料庫全過程

標籤：

1、需要下載一個jar包。地址 http://pan.baidu.com/s/1i50LRId

2、代碼如下：

import java.sql.*;public class Mytest {    public static void main(String[] args){        String sql = "select * from student";        String url = "jdbc:sqlserver://WANGHONGHONG-PC\\SQLSERVER2;DatabaseName=hh";        String username = "sa";        String password = "[email protected]";        Connection conn;        Statement stmt;        ResultSet rs;        try {          Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();          conn = DriverManager.getConnection(url, username, password);          stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);          rs = stmt.executeQuery(sql);          System.out.println(rs.next());          rs.close();          stmt.close();          conn.close();        } catch (InstantiationException e) {          e.printStackTrace();        } catch (IllegalAccessException e) {          e.printStackTrace();        } catch (ClassNotFoundException e) {          e.printStackTrace();        } catch (SQLException e) {          e.printStackTrace();        }      }}

3、效果：

4、又完善一版（添加輸出）

import java.sql.*;public class Mytest {    public static void main(String[] args){        String sql = "select * from student";        String url = "jdbc:sqlserver://WANGHONGHONG-PC\\SQLSERVER2;DatabaseName=hh";        String username = "sa";        String password = "[email protected]";        Connection conn;        Statement stmt;        ResultSet rs;        try {          Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();          conn = DriverManager.getConnection(url, username, password);          stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);          rs = stmt.executeQuery(sql);          while(rs.next()){          System.out.println(rs.getString("name"));          }          rs.close();          stmt.close();          conn.close();        } catch (InstantiationException e) {          e.printStackTrace();        } catch (IllegalAccessException e) {          e.printStackTrace();        } catch (ClassNotFoundException e) {          e.printStackTrace();        } catch (SQLException e) {          e.printStackTrace();        }      }}

 

請各位大神們指點一二

java eclipse 串連資料庫全過程