oracle数据库联接成功,但不能执行SQL语句
本人刚学习ORACLE,请高手指点一下,万分感谢!!!
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBUtil {
//oracle联接
private static String user="manager";
private static String password="admin";
private static String DRIVER="oracle.jdbc.driver.OracleDriver";
private static String url="jdbc:oracl:thin:@127.0.0.1:1521:bookshop";
private Connection con=null;
private PreparedStatement ps=null;
private ResultSet rs=null;
public DBUtil(){
con=DBUtil.getConnection();
}
/**
* 取得数据库联接对象
* @return 数据库联接对象
*/
public static Connection getConnection(){
Connection conn=null;
try {
Class.forName(DRIVER);
conn=DriverManager.getConnection(url, user, password);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
/**
* 数据的更新,添加,删除
* @param sql Statement
*/
public void update(String sql){
try {
Statement st=this.con.createStatem
相关问答:
两种错误:
1.如果我这样申明:ResultSet rs;错误提示如下:
An error occurred at line: 51 in the jsp file: /index.jsp
The local variable rs may not have been initialized
48: ......
PB中开发的。
DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)
string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+&q ......
SQL code:
1. 说明:复制表(只复制结构,源表名:a,新表名:b)
SQL: select * into b from a where 1<>1;
2. 说明:拷贝表(拷贝数据,源表名:a,目标表名:b)
SQL: insert into b(a ......
数据库 现在有表1,表2如下,要求输出表3的样子
Table1
yue dep yj
一月 1 10
二月 1 20
三月 2 &nb ......