如何用java创建MYSQL的数据表?
答案:3 悬赏:10 手机版
解决时间 2021-03-22 00:24
- 提问者网友：人生佛魔见
- 2021-03-21 17:55
如何用java创建MYSQL的数据表?
最佳答案
- 五星知识达人网友：深街酒徒
- 2021-03-21 19:04
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");
String sql = "CREATE TABLE tableName (id int not null, name varchar(20) not null, age int null, primary key (id));";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.executeUpdate();
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");
String sql = "CREATE TABLE tableName (id int not null, name varchar(20) not null, age int null, primary key (id));";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.executeUpdate();
全部回答
- 1楼网友：冷風如刀
- 2021-03-21 20:41
use mysql;
create table student(
id number,
name varchar(20),
age number
);
create table student(
id number,
name varchar(20),
age number
);
- 2楼网友：duile
- 2021-03-21 19:30
class.forname("oracle.jdbc.driver.OracleDriver");//加载数据库驱动
String url="jdbc:oracle:thin:@localhost:1521:db_name";
String sql="CREATE TABLE table(filed1 varchar2(2),filed2 varchar2(2))";
Connection conn=DriverManager.getConnection(url,"scott","tiger");//建立数据库连接
if(!conn.isClose()){
Statement stmt = conn.createStatement();
stmt.executeUPDATE(sql); //建立一个表
}
String url="jdbc:oracle:thin:@localhost:1521:db_name";
String sql="CREATE TABLE table(filed1 varchar2(2),filed2 varchar2(2))";
Connection conn=DriverManager.getConnection(url,"scott","tiger");//建立数据库连接
if(!conn.isClose()){
Statement stmt = conn.createStatement();
stmt.executeUPDATE(sql); //建立一个表
}
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
点此我要举报以上问答信息
大家都在看
推荐资讯