 [求助]这是一个有关SQL数据库创建表的程序，请各位帮忙看看怎么能调通！
import java.sql.*;
import sun.jdbc.odbc.JdbcOdbcDriver;
public class TableMaker
{
static String jdbcDriver="sun.jcbc.odbc.JdbcOdbcDriver";
static String dbName="zhaozhenbing";
static String url="jdbc:odbc:";
static String SQLCreate=
"CREATE TABLE CONTACT_INFO ("+
"CONTACT_ID INTEGER NOT NULL PRIMARY KEY,"+
"FIRST-NAME VARCHAR(20) NOT NULL,"+
"MI CHAR(1) NULL,"+
"LAST-NAME VARCHAR(30) NOT NULL,"+
"STREET VARCHAR(50) NOT NULL,"+
"CITY VARCHAR(30) NOT NULL,"+
"STATE CHAR(2) NOT NULL,"+
"ZIP VARCHAR(10) NOT NULL,"+
");";
public TableMaker()
{
registerDriver();
}
public void setDatabaseName(String dbName)
{
this.dbName=dbName;
}
public void registerDriver()
{
try
{
Class.forName(jdbcDriver);
DriverManager.registerDriver(new JdbcOdbcDriver());
}
catch(ClassNotFoundException exp)
{
System.err.println(exp.getMessage());
}
catch(SQLException e)
{
System.err.println(e.getMessage());
}
}
public void execute(String SQLCommand)
{
url+=dbName;
Connection con;
Statement stmt;
try
{
con=DriverManager.getConnection(url);
stmt=con.createStatement();
stmt.execute(SQLCommand);
con.close();
}
catch(SQLException e)
{
System.err.println(e.getMessage());
}
/*finally
{
try
{
if(con !=null)
{
con.close();
}
if(stmt !=null)
{
stmt.close();
}
}
catch(Exception ex)
{
}
}*/
}
public static void main(String[] args)
{
TableMaker tableMaker=new TableMaker();
tableMaker.execute(SQLCreate);
}
}
|
[返回] W3CHINA.ORG讨论区 - 语义网·描述逻辑·本体·RDF·OWL →
XML.ORG.CN讨论区 - 高级XML应用 → 『 XML 与 数据库 』 → [求助]这是一个有关SQL数据库创建表的程序，请各位帮忙看看怎么能调通！
(订阅本版)
2005/5/18 9:56:00
新浪微博
