e1701.java

来自「java小程序」· Java 代码 · 共 28 行

import java.sql.*;
public class E1701 
{
public static void main(String args[])
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(java.lang.ClassNotFoundException e)
{
System.out.println(e.getMessage());
}
try
{
Connection con=DriverManager.getConnection("jdbc:odbc:bookbase");
Statement stmt=con.createStatement();
stmt.executeUpdate("create table mailTab(name char(12),sex char(2),birthday char(8),tel char(14) PRIMARY KEY,email char(30),remark char(14))");
stmt.close();
con.close();
}
catch(SQLException ex)
{
System.out.println("SQLException:"+ex.getMessage());
}
}
}