UC知道这段程序能实现jsp连接oracle吗？
来源：百度知道 编辑：UC知道 时间：2024/05/07 14:56:26
<%
// FileName="oracle_jdbc_conn.htm"
// Type="JDBC" ""
// DesigntimeType="JDBC"
// HTTP="true"
// Catalog=""
// Schema=""
String MM_djsp_DRIVER = "oracle.jdbc.driver.OracleDriver";
String MM_djsp_USERNAME = "system";
String MM_djsp_PASSWORD = "123456";
String MM_djsp_STRING = "jdbc:oracle:thin:@localhost:1521:oracle";
%>
还是不会，有具体点的吗？
// FileName="oracle_jdbc_conn.htm"
// Type="JDBC" ""
// DesigntimeType="JDBC"
// HTTP="true"
// Catalog=""
// Schema=""
String MM_djsp_DRIVER = "oracle.jdbc.driver.OracleDriver";
String MM_djsp_USERNAME = "system";
String MM_djsp_PASSWORD = "123456";
String MM_djsp_STRING = "jdbc:oracle:thin:@localhost:1521:oracle";
%>
还是不会，有具体点的吗？
不能..你的语句不全所以我说不行..
String MM_djsp_DRIVER = "oracle.jdbc.driver.OracleDriver";
String MM_djsp_USERNAME = "system";
String MM_djsp_PASSWORD = "123456";
String MM_djsp_STRING = "jdbc:oracle:thin:@localhost:1521:oracle";
Class.forName(MM_djsp_DRIVER);
Connection conn=DriverManager.getConnection(MM_djsp_STRING,MM_djsp_USERNAME,MM_djsp_PASSWORD);
//conn的创建就是你数据库连接成功..
//在创建 Statement 用Statement 的对象在去执行sql语句
Statement stmt=conn.createStatement();
stmt.executeQuery("insert into.....(语句忽略)");
//记着要去try catch..要扑获异常