![]() |
#2
流星雨2009-10-27 18:00
|
以上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);
}
}
}