打印功能:

Question

老师要求把查询的结果打印出来,请问我用jBuilder怎么做??我一点思路都没有!

Answer 1

//这是我机器上有的例子，就是连接数据库，检索数据，打印出来！
/**
 * kimi
 */package test;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;/**
 * @author kimi
 * 
 */
public class TestCsdn {    /**
     * @param args
     * @throws SQLException
     */
    public static void main(String[] args) {
        try {
            start();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }    private static void start() throws SQLException {
        Connection conn = testDataBefore();
        Statement st = conn.createStatement();
        ResultSet rs = st.executeQuery("select id,username,age from tableName");
        while(rs.next()) {
            System.out.println("id:"+rs.getObject(1));
            System.out.println("username:"+rs.getObject(2));
            System.out.println("age:"+rs.getObject(3));
        }
    }    static Connection testDataBefore() {
        Connection conn = null;
        try {
            Class.forName("oracle.jdbc.OracleDriver");
            String url = "jdbc:oracle:thin:@172.16.16.174:1521:atom";//这里要配你自己的url            conn = DriverManager.getConnection(
                url,
                "atomuser",
                "atomuser");        } catch (SQLException e) {            try {
                conn.rollback();
            } catch (SQLException e1) {                e1.printStackTrace();
            }
        } catch (ClassNotFoundException e) {
            try {
                conn.rollback();
            } catch (SQLException e1) {                e1.printStackTrace();
            }
        }
        return conn;
    }
}