jdbctext2.java

来自「java与数据库相连接的原程序」· Java 代码 · 共 49 行

package main;
//表创建
 
import java.sql.*;
import java.lang.*;
import java.util.*;

public class JdbcText2 {

	 
	public static void main(String[] args) {
		 
		String url = "jdbc:oracle:thin:@127.0.0.1:1521:xiaoran";
		String driver = "oracle.jdbc.driver.OracleDriver";
		String user = "scott";
		String password = "tiger";
		String sql = "create table STUDENT8(student_ID  int,student_NAME char(10),student_SCORE numeric(12,2),GREAD int,primary key(student_ID))";
		
		try {
			 
			Class.forName(driver);

			/*
			 * 保证相应的Driver类已经被加载到 jvm中，并且完成了类的初始化工作就行了，而具体是怎样实现这个功能却是没有讲究的。
			 */
			
			Connection conn = DriverManager.getConnection(url, user, password);
//			获取连接
			java.sql.Statement stmt = conn.createStatement();
			//执行查询
			 stmt.executeUpdate(sql);

//			if (rs1.next()) {
//				System.out.println(rs1.getDate("STUDENT4"));
//			}
			//sql = "select DNAME from DEPT";
			//执行操作
			//sql = "insert into DEPT(DEPTNO,DNAME)values('35','WANG')";
			//stmt.executeUpdate(sql);
			//stmt.close();
		} 
		catch (Exception e)
		 {
			System.out.println(e);
		}

	}
}