注册 登录
编程论坛 Oracle论坛

ResultSet rset=stmt.executeQuery("select employee_id as 1 from employees&qu

发布于 2009-10-21 18:06, 1370 次点击
以上select语句该怎么写?
ResultSet rset=stmt.executeQuery("select employee_id from employees");提示无效索引
ResultSet rset=stmt.executeQuery("select employee_id  as "1" from employees");编译无法通过
ResultSet rset=stmt.executeQuery("select employee_id  as 1 from emloyees");有无效字符 1 提示未找到 from 关键字


//源程序如下:
//JDeveloper编译


package project2;
import java.sql.*;
import javax.swing.table.*;
import javax.swing.*;
import java.util.Vector;

public class Class2 {
    public static void main(String args[]) throws SQLException{
        DriverManager.registerDriver(
            new oracle.jdbc.driver.OracleDriver());
        Connection conn=DriverManager.getConnection(
                            "jdbc:oracle:thin:@127.0.0.1:1521:XE","hr","***");
        Statement stmt=conn.createStatement();
        ResultSet rset=stmt.executeQuery("select employee_id as 1 from employees");
        DisplayResult(rset);
        rset.close();
        stmt.close();
        conn.close();
    }
public static void DisplayResult(ResultSet rset)
throws SQLException{
    JFrame frame=new JFrame();
    DefaultTableModel tableModel=new DefaultTableModel();
    JTable table=new JTable(tableModel);
    JScrollPane resultPan=new JScrollPane(table);
    ResultSetMetaData md=rset.getMetaData();
    Vector col_names=new Vector();
    int no_cols=md.getColumnCount();
    for(int i=0;i<no_cols;i++)
        col_names.add(md.getColumnLabel(i+1));
    Vector tableData=new Vector();
    while(rset.next()){
        Vector rowData=new Vector();
        for(int i=0;i<no_cols;i++) {
            rowData.add(rset.getString(i));
        }
        tableData.add(rowData);
        tableModel.setDataVector(tableData,col_names);
        frame.setTitle("Employees information");
        frame.getContentPane().add(resultPan);
        frame.pack();
        frame.setVisible(true);
    }
}
}
2 回复
#2
流星雨2009-10-27 18:00
select employee_id from employees;
把这句直接放数据库里跑。
看看是不是你字段employee_id拼写错误。

select employee_id  as "1" from employees
着句当然有问题,你见过别名这样起的吗?

select employee_id  as 1 from emloyees
起别名的时候换成字母就不会有这个错误
#3
sevenjike2009-10-28 16:48
楼主说的很对。。
1