JDBC连接数据库代码

package com.zhao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class TestJDBC {
 public static void main(String[] args) {
  String url = "jdbc:sqlserver://127.0.0.1:1433;databaseName=zhao";
  String sql = "select * from student";
  Connection con = null;
  Statement sta = null;
  ResultSet rs = null;
  try {
   Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
   con = DriverManager.getConnection(url, "sa", "");
   sta = con.createStatement();
   rs = sta.executeQuery(sql);
   while (rs.next()){
    int i = 1;
    String stuName = rs.getString(i++);
    int stuNo = rs.getInt(i++);
    int age = rs.getInt(i++);
    int stuID = rs.getInt(i++);
    String stuAddress = rs.getString(i++);
    System.out.println(stuName + " " + stuNo + " " + age + " " + stuID + " " + stuAddress +"");
   }
  } catch (ClassNotFoundException e) {
   System.out.println("connection fail!");
   e.printStackTrace();
  } catch (SQLException e) {
   System.out.println("connection exception!");
   e.printStackTrace();
  } finally {
   try {
    if (rs != null){
     rs.close();
     rs = null;
    }
    if (sta != null){
     sta.close();
     sta = null;
    }
    if (con != null){
     con.close();
     con = null;
    }
   } catch (Exception e2) {
   }
   
  }
 }
}

转载于:https://www.cnblogs.com/sunshine2011/archive/2011/08/31/2160752.html