建立一个用户表，由键盘输入表名称和列定义，在数据库中实现

import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Scanner;
import java.sql.Statement;

public class TestDemo01 {
    public static final String DBDRIVER = "org.gjt.mm.mysql.Driver" ;
    public static final String DBURL = "jdbc:mysql://localhost:3306/mldn" ;
    public static final String DBUSER = "root" ;
    public static final String DBPASS = "root" ;
    public static void main(String[] args) throws Exception{
        Scanner sc = new  Scanner(System.in);
        System.out.println("请输入要创建表的名称：");
        String tbname = sc.next();     // 由键盘输入所创建的表的名称
        System.out.println("请输入要创建id列的名称：");
        String tbno1   = sc.next();     // 由键盘输入所创表的属性id。
        System.out.println("请输入要创建name列的名称：");
        String tbno2   = sc.next(); 
        
        Class.forName(DBDRIVER);
        Connection conn = DriverManager.getConnection(DBURL,DBUSER,DBPASS);
        Statement stmt = conn.createStatement();
        String sql = " CREATE TABLE tbname(tbno1 int,tbno2 char(10))";
        stmt.execute(sql);
        stmt.close();
        conn.close();
    }
}

 

转载于:https://www.cnblogs.com/ivan999/p/10920685.html