eclipse中用java的代码取出sqlserver的数据

Question

库名：BUSSINESS
表名:VEHICLE_INFO
有三个字段：BusNum，Driver，PhoneNum,怎么写代码将数据取出来

Answer 1

项目一般有框架去实现查询的，如果需要单独做的话可以使用jdbc实现，可参考如下，改下驱动跟数据库配置就好了：

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

public class JdbcUtil {
private static String url = "jdbc:oracle:thin:@test:1521:test";
private static String userName = "test";
private static String pwd = "test";
private static String driverName = "oracle.jdbc.OracleDriver";

static {
    try {
        Class.forName(driverName);
    } catch (ClassNotFoundException e) {
        e.printStackTrace();
    }
}

public static void main(String[] args) throws SQLException {
    Connection connection = null;
    PreparedStatement ps = null;
    ResultSet rs = null;
    String sql = "  select b.id id, b.typename name  from b ";

    try {
        connection = DriverManager.getConnection(url, userName, pwd);
    } catch (SQLException e1) {
        e1.printStackTrace();
    }

    try {
        ps = connection.prepareStatement(sql);
        rs = ps.executeQuery();

        while (rs.next()) {
            int id = rs.getInt("id");
            String typename = rs.getString("name");
            System.out.println(id + ":" + typename);
        }
    } catch (SQLException e) {
        e.printStackTrace();
    } finally {
        if (rs != null) {
            rs.close();
        }

        if (ps != null) {
            ps.close();
        }

        if (connection != null) {
            connection.close();
        }
    }
}

}