我编写一个JAVA程序创建一个StudentGrade表,但是出现了一个错误:java.sql.SQLException: No ResultSet was produced;不过在数据库中又会创建出StudentGrade表,这是为什么呢??下面这是程序:package com.vitas.start;
import java.sql.*;
public class TestJDBC {
public static void main(String []args)
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e)
{
e.printStackTrace();
}
try{
Connection con=DriverManager.getConnection("jdbc:odbc:test");
Statement s=con.createStatement();
ResultSet rs=s.executeQuery("Use Cool create table
StudentGrade(ShareId int primary key,
CompName varchar(20) not null,
NoOfShares int not null,
PurRate decimal(6,2) not null,
CurrRate decimal(6,2) not null,
PurDate datetime not null)"); rs.close();
s.close();
con.close();
}catch(SQLException e)
{
e.printStackTrace();
}
}}
import java.sql.*;
public class TestJDBC {
public static void main(String []args)
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e)
{
e.printStackTrace();
}
try{
Connection con=DriverManager.getConnection("jdbc:odbc:test");
Statement s=con.createStatement();
ResultSet rs=s.executeQuery("Use Cool create table
StudentGrade(ShareId int primary key,
CompName varchar(20) not null,
NoOfShares int not null,
PurRate decimal(6,2) not null,
CurrRate decimal(6,2) not null,
PurDate datetime not null)"); rs.close();
s.close();
con.close();
}catch(SQLException e)
{
e.printStackTrace();
}
}}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货