生成access数据库
package javaapplication1;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class CreateTable {
public static void main(String [] args)
{
String JDriver="sun.jdbc.odbc.JdbcOdbcDriver";
String conURL="jdbc:odbc:TestDB";
sun.jdbc.odbc.JdbcOdbcDriver driver=new sun.jdbc.odbc.JdbcOdbcDriver(); try{
Class.forName(JDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.out.println("无法加载JDBC驱动程序."+e.getMessage());
}
Connection con=null;
Statement s=null;
try
{
DriverManager.registerDriver(driver);
con=DriverManager.getConnection(conURL);
s=con.createStatement();
String query="create table consumer("+"model INTEGER(4) ,"+"speed INTEGER(4),"+"ram INTEGER(4)"+"hd INTEGER(4)"+"price INTEGER(6)"+")";
s.executeUpdate(query);
System.out.println("创建表成功!");
}
catch(SQLException e)
{
System.out.println("SQLException:"+e.getMessage());
}}
}SQLException:[Microsoft][ODBC Microsoft Access ?????] CREATE TABLE ????е??�????
package javaapplication1;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class CreateTable {
public static void main(String [] args)
{
String JDriver="sun.jdbc.odbc.JdbcOdbcDriver";
String conURL="jdbc:odbc:TestDB";
sun.jdbc.odbc.JdbcOdbcDriver driver=new sun.jdbc.odbc.JdbcOdbcDriver(); try{
Class.forName(JDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.out.println("无法加载JDBC驱动程序."+e.getMessage());
}
Connection con=null;
Statement s=null;
try
{
DriverManager.registerDriver(driver);
con=DriverManager.getConnection(conURL);
s=con.createStatement();
String query="create table consumer("+"model INTEGER(4) ,"+"speed INTEGER(4),"+"ram INTEGER(4)"+"hd INTEGER(4)"+"price INTEGER(6)"+")";
s.executeUpdate(query);
System.out.println("创建表成功!");
}
catch(SQLException e)
{
System.out.println("SQLException:"+e.getMessage());
}}
}SQLException:[Microsoft][ODBC Microsoft Access ?????] CREATE TABLE ????е??�????
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public class Sdd {
public static void main(String[] args) throws ClassNotFoundException {
String Driver = "com.mysql.jdbc.Driver";
String url="jdbc:mysql://localhost:3306/kjsb";
String username = "root";
String password = "long";
Connection con = null;
Statement s = null;
ResultSet rs = null; try {
Class.forName(Driver);
con = DriverManager.getConnection(url, username, password);
System.out.println("数据库连接成功!");
s = con.createStatement();
// rs = s.executeQuery("select * from users");
String query = "create table consumer(model INTEGER(4),speed INTEGER(4), ram INTEGER(4),hd INTEGER(4),price INTEGER(6))";
s.executeUpdate(query);
System.out.println("创建表成功!");
} catch (SQLException e) {
System.out.println("SQLException:" + e.getMessage());
} }
}