如何用java創(chuàng)建MYSQL的數(shù)據(jù)表?
3 回答
慕哥6287543
TA貢獻(xiàn)1831條經(jīng)驗(yàn) 獲得超10個贊
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();
拉丁的傳說
TA貢獻(xiàn)1789條經(jīng)驗(yàn) 獲得超8個贊
class.forname("oracle.jdbc.driver.OracleDriver");//加載數(shù)據(jù)庫驅(qū)動
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");//建立數(shù)據(jù)庫連接
if(!conn.isClose()){
Statement stmt = conn.createStatement();
stmt.executeUPDATE(sql); //建立一個表
}
慕碼人8056858
TA貢獻(xiàn)1803條經(jīng)驗(yàn) 獲得超6個贊
use mysql;
create table student(
id number,
name varchar(20),
age number
);
添加回答
舉報
0/150
提交
取消