我有一个问题? public static void main(){ JdbcOdbctest jot = new JdbcOdbctest();} 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 import java.net.URL;import java.sql.*;import java.util.*;/*加入一个public类和它的main方法*/public runClass{ public static void main(String []args){ JdbcOdbctest JOTest = new JdbcOdbctest (); JOTest.JdbcOdbctest(); }}//加入完毕,直写的,没有测试,自己试一下class JdbcOdbctest{ ResultSet results; ResultSetMetaData rsmd; DatabaseMetaData dma; Connection con; int numCols,i;public JdbcOdbctest(){ String url="jdbc:odbc:shopprice"; String query="SELECT DISTINCTROW Food FROM foodprice"+"WHERE(Food like'C%');"; try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection(url); dma=con.getMetaData(); System.out.println("Connected to:"+dma.getURL()); System.out.println("Driver"+dma.getDriverName()); String[] types=new String[1]; types[0]="TABLES"; results=dma.getTables(null,null,"%",types); dumpResults("--Tables--"); results.close();} catch(Exception e){ System.out.println(e);} System.out.println("--Column Names--");try{ results=dma.getColumns(null,null,"foodprice",null); ResultSetMetaData rsmd=results.getMetaData(); int numCols=rsmd.getColumnCount(); while(results.next()){ String cname=results.getString("COLUMN_NAME"); System.out.println(cname+" "); System.out.println(); results.close();}}catch(Exception e){System.out.println(e);}try{ Statement stmt=con.createStatement(); results=stmt.executeQuery("SELECT Food from foodprice;");}catch(Exception e){System.out.println("query exception");}dumpResults("--Contents of Food column--");try{ Statement stmt=con.createStatement(); results=stmt.executeQuery(query);} catch(Exception e){System.out.println("query exception");} dumpResults("--Results of Query--");}} 晕~~~看错了,以为JdbcOdbctest()是方法(是构造器来的)请按bluesmile979(笑着)写的来做。 import java.net.URL;import java.sql.*;import java.util.*;class JdbcOdbctest{ ResultSet results; ResultSetMetaData rsmd; DatabaseMetaData dma; Connection con; int numCols,i;public JdbcOdbctest(){ String url="jdbc:odbc:shopprice"; String query="SELECT DISTINCTROW Food FROM foodprice"+"WHERE(Food like'C%');"; try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection(url); dma=con.getMetaData(); System.out.println("Connected to:"+dma.getURL()); System.out.println("Driver"+dma.getDriverName()); String[] types=new String[1]; types[0]="TABLES"; results=dma.getTables(null,null,"%",types); dumpResults("--Tables--"); results.close();} catch(Exception e){ System.out.println(e);} System.out.println("--Column Names--");try{ results=dma.getColumns(null,null,"foodprice",null); ResultSetMetaData rsmd=results.getMetaData(); int numCols=rsmd.getColumnCount(); while(results.next()){ String cname=results.getString("COLUMN_NAME"); System.out.println(cname+" "); System.out.println(); results.close();}}catch(Exception e){System.out.println(e);}try{ Statement stmt=con.createStatement(); results=stmt.executeQuery("SELECT Food from foodprice;");}catch(Exception e){System.out.println("query exception");}dumpResults("--Contents of Food column--");try{ Statement stmt=con.createStatement(); results=stmt.executeQuery(query);} catch(Exception e){System.out.println("query exception");} dumpResults("--Results of Query--");}public static void main(String[] agag){new JdbcOdbctest();} import java.net.URL;import java.sql.*;import java.util.*;class JdbcOdbctest{ ResultSet results; ResultSetMetaData rsmd; DatabaseMetaData dma; Connection con; int numCols,i;public JdbcOdbctest(){ String url="jdbc:odbc:shopprice"; String query="SELECT DISTINCTROW Food FROM foodprice"+"WHERE(Food like'C%');"; try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection(url); dma=con.getMetaData(); System.out.println("Connected to:"+dma.getURL()); System.out.println("Driver"+dma.getDriverName()); String[] types=new String[1]; types[0]="TABLES"; results=dma.getTables(null,null,"%",types); dumpResults("--Tables--"); results.close();} catch(Exception e){ System.out.println(e);} System.out.println("--Column Names--");try{ results=dma.getColumns(null,null,"foodprice",null); ResultSetMetaData rsmd=results.getMetaData(); int numCols=rsmd.getColumnCount(); while(results.next()){ String cname=results.getString("COLUMN_NAME"); System.out.println(cname+" "); System.out.println(); results.close();}}catch(Exception e){System.out.println(e);}try{ Statement stmt=con.createStatement(); results=stmt.executeQuery("SELECT Food from foodprice;");}catch(Exception e){System.out.println("query exception");}dumpResults("--Contents of Food column--");try{ Statement stmt=con.createStatement(); results=stmt.executeQuery(query);} catch(Exception e){System.out.println("query exception");} dumpResults("--Results of Query--");}public static void main(String[] agag){new JdbcOdbctest();}俺也来顶一下! 俺顶二楼的。直接在你的类里面加入main方法就可以了。 java socket 多人单对单聊天 客户端的接受问题 Class.getMethod()方法是做什么用的? 用JAVA实现定时执行任务怎么写?(jdk1.4) 怎样才能把多个界面连在一起使用? spring入门问题 新手问题 “[Microsoft][ODBC 驱动程序 管理器] 无效的光标状态”是什么错误?? 请问使用java如何虚拟键盘操作,如虚拟按下按钮delete键或print键 有谁知道ant做什么用的,为什么要用它?(高分) 我想请教一下关于iReport生成二维码的问题 给我解释一下好吗? 菜鸟的问题
import java.sql.*;
import java.util.*;/*加入一个public类和它的main方法*/
public runClass{
public static void main(String []args){
JdbcOdbctest JOTest = new JdbcOdbctest ();
JOTest.JdbcOdbctest();
}
}//加入完毕,直写的,没有测试,自己试一下
class JdbcOdbctest{ ResultSet results;
ResultSetMetaData rsmd;
DatabaseMetaData dma;
Connection con;
int numCols,i;
public JdbcOdbctest(){
String url="jdbc:odbc:shopprice";
String query="SELECT DISTINCTROW Food FROM foodprice"+"WHERE(Food like'C%');";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection(url);
dma=con.getMetaData();
System.out.println("Connected to:"+dma.getURL());
System.out.println("Driver"+dma.getDriverName());
String[] types=new String[1];
types[0]="TABLES";
results=dma.getTables(null,null,"%",types);
dumpResults("--Tables--");
results.close();
} catch(Exception e){
System.out.println(e);
}
System.out.println("--Column Names--");
try{
results=dma.getColumns(null,null,"foodprice",null);
ResultSetMetaData rsmd=results.getMetaData();
int numCols=rsmd.getColumnCount();
while(results.next()){
String cname=results.getString("COLUMN_NAME");
System.out.println(cname+" ");
System.out.println();
results.close();
}
}
catch(Exception e){System.out.println(e);}
try{
Statement stmt=con.createStatement();
results=stmt.executeQuery("SELECT Food from foodprice;");
}catch(Exception e){System.out.println("query exception");
}
dumpResults("--Contents of Food column--");
try{
Statement stmt=con.createStatement();
results=stmt.executeQuery(query);
} catch(Exception e){System.out.println("query exception");}
dumpResults("--Results of Query--");
}
}
import java.sql.*;
import java.util.*;class JdbcOdbctest{ ResultSet results;
ResultSetMetaData rsmd;
DatabaseMetaData dma;
Connection con;
int numCols,i;
public JdbcOdbctest(){
String url="jdbc:odbc:shopprice";
String query="SELECT DISTINCTROW Food FROM foodprice"+"WHERE(Food like'C%');";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection(url);
dma=con.getMetaData();
System.out.println("Connected to:"+dma.getURL());
System.out.println("Driver"+dma.getDriverName());
String[] types=new String[1];
types[0]="TABLES";
results=dma.getTables(null,null,"%",types);
dumpResults("--Tables--");
results.close();
} catch(Exception e){
System.out.println(e);
}
System.out.println("--Column Names--");
try{
results=dma.getColumns(null,null,"foodprice",null);
ResultSetMetaData rsmd=results.getMetaData();
int numCols=rsmd.getColumnCount();
while(results.next()){
String cname=results.getString("COLUMN_NAME");
System.out.println(cname+" ");
System.out.println();
results.close();
}
}
catch(Exception e){System.out.println(e);}
try{
Statement stmt=con.createStatement();
results=stmt.executeQuery("SELECT Food from foodprice;");
}catch(Exception e){System.out.println("query exception");
}
dumpResults("--Contents of Food column--");
try{
Statement stmt=con.createStatement();
results=stmt.executeQuery(query);
} catch(Exception e){System.out.println("query exception");}
dumpResults("--Results of Query--");
}
public static void main(String[] agag){
new JdbcOdbctest();
}
import java.sql.*;
import java.util.*;class JdbcOdbctest{ ResultSet results;
ResultSetMetaData rsmd;
DatabaseMetaData dma;
Connection con;
int numCols,i;
public JdbcOdbctest(){
String url="jdbc:odbc:shopprice";
String query="SELECT DISTINCTROW Food FROM foodprice"+"WHERE(Food like'C%');";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection(url);
dma=con.getMetaData();
System.out.println("Connected to:"+dma.getURL());
System.out.println("Driver"+dma.getDriverName());
String[] types=new String[1];
types[0]="TABLES";
results=dma.getTables(null,null,"%",types);
dumpResults("--Tables--");
results.close();
} catch(Exception e){
System.out.println(e);
}
System.out.println("--Column Names--");
try{
results=dma.getColumns(null,null,"foodprice",null);
ResultSetMetaData rsmd=results.getMetaData();
int numCols=rsmd.getColumnCount();
while(results.next()){
String cname=results.getString("COLUMN_NAME");
System.out.println(cname+" ");
System.out.println();
results.close();
}
}
catch(Exception e){System.out.println(e);}
try{
Statement stmt=con.createStatement();
results=stmt.executeQuery("SELECT Food from foodprice;");
}catch(Exception e){System.out.println("query exception");
}
dumpResults("--Contents of Food column--");
try{
Statement stmt=con.createStatement();
results=stmt.executeQuery(query);
} catch(Exception e){System.out.println("query exception");}
dumpResults("--Results of Query--");
}
public static void main(String[] agag){
new JdbcOdbctest();
}
俺也来顶一下!
直接在你的类里面加入main方法就可以了。