凯里欧文三分视频:请教高手

来源:百度文库 编辑:查人人中国名人网 时间:2024/05/04 17:59:44
我用JBUILDER写了下面这个连接数据库的程序,但不知怎么运行结果是:
sun,jdbc,odbc,JdbcOdbcDriver
程序如下:
public class DataBase
{
public static void main(String[] args)
{
Connection connection=null;
ResultSet rs=null;
String name;

try
{
System.out.print("请输入数据库名:");
name=MyInput.readString();
Class.forName("sun,jdbc,odbc,JdbcOdbcDriver");
String dbURL="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+name;
connection = DriverManager.getConnection(dbURL," "," ");
System.out.println("数据库连接成功!");
String sql= "SELECT * From studentbase,studentaddress WHERE (性别='男')"+" AND (电话='010-63000001')";
Statement statement;
statement=connection.createStatement();
rs=statement.executeQuery(sql);
System.out.println(rs);
if(rs!=null)
{
ResultSetMetaData rsmd=rs.getMetaData();
int numCols=rsmd.getColumnCount();
for(int i=1;i<=rsmd.getColumnCount();i++)
{
if(i>1) System.out.print(" ");
System.out.print(rsmd.getColumnLabel(i));
}
System.out.println(" ");
System.out.println(" ");
while(rs.next())
{
for(int i=1;i<=numCols;i++)
{
if(i>1) System.out.print(" ");
System.out.print(rs.getString(i));
}
System.out.println(" ");
}
}

}
catch(SQLException ex1)
{
System.out.println(ex1.getMessage());
}
catch(ClassNotFoundException ex2)
{
System.out.println(ex2.getMessage());
}
finally
{
try {
if (rs != null)
rs.close();
if (connection != null)
connection.close();

} catch (SQLException ex3) {
System.out.println(ex3);
}
}

}

}
请高手帮帮忙帮我修改一下,谢谢!

先加个包import java.sql.*;
Class.forName("sun,jdbc,odbc,JdbcOdbcDriver");
改成
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

试试可以了么?

那么难啊,我不会!