Question

jdbc获取视图字段名称，长度等信息，这句话怎么得到的resultset为空？

Connection con;
String viewsql="select * from user_tab_cols WHERE table_name='"+viewname+"'";
Statement pStemt = null;
try {
try {
Class.forName(DRIVER);
} catch (ClassNotFoundException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
con = DriverManager.getConnection(URL, NAME, PASS);
pStemt = (Statement) con.createStatement();
ResultSet rs = pStemt.executeQuery(viewsql);

Answer 1

jdbc连接没问题吧？ String viewsql="select * from user_tab_cols WHERE table_name='"+viewname+"'"孝绝咐;看宏迟看你这巧纯条sql语句有问题没？