4个回答
展开全部
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); //建立一个表
}
展开全部
use mysql;
create table student(
id number,
name varchar(20),
age number
);
create table student(
id number,
name varchar(20),
age number
);
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
展开全部
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();
本回答被提问者和网友采纳
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询
广告 您可能关注的内容 |