数据库出错 把你的连接代码贴出来!!! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 代码如下:import java.sql.*;import javax.swing.*;import java.awt.event.*;import java.awt.*;public class Test extends JFrame{ private Statement statement; private Connection connection; private ResultSet rs; private String url = "jdbc:odbc:Students"; private String user = "anonymous"; private String password = "guest"; private String query = "SELECT * FROM Students"; public Test () throws SQLException {super("this is a test"); try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); connection = DriverManager.getConnection(url,user,password); statement = connection.createStatement(); rs = statement.executeQuery(query); display(rs); } catch(SQLException sqlex) { System.exit(1); } catch(ClassNotFoundException cnfex) { cnfex.printStackTrace(); System.exit(1); }} public void display(ResultSet result) throws SQLException { try { ResultSetMetaData rsmd = result.getMetaData(); do{ printRow(result,rsmd); }while(result.next()); } catch(SQLException sqlex) { sqlex.printStackTrace(); System.exit(1); } } public void printRow(ResultSet rs,ResultSetMetaData rsmd) throws SQLException { try { String s = new String(""); for(int i=0;i<rsmd.getColumnCount();i++) { switch(rsmd.getColumnType(i)) { case Types.VARCHAR : case Types.LONGVARCHAR: s+=rs.getString(i)+" "; case Types.INTEGER: s+= new Long(rs.getLong(i))+" "; } } System.out.println(s); } catch(SQLException sqlex) { sqlex.printStackTrace(); System.exit(1); } } public static void main(String args[]) { try { final Test app = new Test(); app.addWindowListener( new WindowAdapter() { public void windowClosing( WindowEvent e) { System.exit(0); } } ); } catch(SQLException sqlex) { sqlex.printStackTrace(); System.exit(1); } }} 关于flash,java做开发 在JPane上加JScrollPane问题???急!!!!!!!!!!!!!!! 请问这是什么错误呀,我环境变量都配好了 请教一个笔试遇到的问题 请教!如何用java编写程序以获取html源码中注释部分的内容? [求助]请问,如何取当前路径????? 请教关于String的问题 问个小问题? jbuilder中为Application的框架添加一个菜单JMenuBar,运行后却没有看见菜单,why? 五子棋制作的问题 一个关于线程同步synchronized的小问题 显示计算机目录和文件得tree是如何实现得,最好有源代码
import javax.swing.*;
import java.awt.event.*;
import java.awt.*;public class Test extends JFrame{
private Statement statement;
private Connection connection;
private ResultSet rs;
private String url = "jdbc:odbc:Students";
private String user = "anonymous";
private String password = "guest";
private String query = "SELECT * FROM Students";
public Test ()
throws SQLException
{super("this is a test");
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
connection = DriverManager.getConnection(url,user,password);
statement = connection.createStatement();
rs = statement.executeQuery(query);
display(rs);
}
catch(SQLException sqlex)
{
System.exit(1);
}
catch(ClassNotFoundException cnfex)
{
cnfex.printStackTrace();
System.exit(1);
}
}
public void display(ResultSet result)
throws SQLException {
try
{
ResultSetMetaData rsmd = result.getMetaData();
do{
printRow(result,rsmd);
}while(result.next());
}
catch(SQLException sqlex)
{
sqlex.printStackTrace();
System.exit(1);
}
}
public void printRow(ResultSet rs,ResultSetMetaData rsmd)
throws SQLException {
try
{
String s = new String("");
for(int i=0;i<rsmd.getColumnCount();i++) {
switch(rsmd.getColumnType(i))
{
case Types.VARCHAR :
case Types.LONGVARCHAR:
s+=rs.getString(i)+" ";
case Types.INTEGER:
s+= new Long(rs.getLong(i))+" ";
}
}
System.out.println(s);
}
catch(SQLException sqlex)
{
sqlex.printStackTrace();
System.exit(1);
}
}
public static void main(String args[])
{
try
{ final Test app = new Test();
app.addWindowListener(
new WindowAdapter() {
public void windowClosing( WindowEvent e)
{
System.exit(0);
}
}
);
}
catch(SQLException sqlex)
{
sqlex.printStackTrace();
System.exit(1);
}
}
}