我有一个问题? 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记事本 统计字符串中单词问题时碰到的疑惑!关于JAVA字符串的问题 一个关于线程的问题 hibernate的问题 我的CardLayout不能使用!?? 关于file 呵呵 请教大家一个菜鸟问题 用JAVA编一个程序,测试网络速度~~高手帮忙 给我解释一下好吗? 菜鸟的问题
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方法就可以了。