ORA-01017: invalid username/password; logon denied 把语句写出来,是不是你程序语句有问题,还有就是密码可以加密的,看看是不是被别人加密过了, 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 //Êý¾Ý¿âÁ¬½Ópackage tsglxt;import java.sql.*;import oracle.sql.*;import oracle.jdbc.driver.OracleResultSet;public class Conn{String sDBDriver = "oracle.jdbc.driver.OracleDriver";String sConnStr = "jdbc:oracle:thin:@localhost:1521:lib";//Connection connect = null;String user="bigroc";String password="roc";Connection connect=null;ResultSet rs = null;public Conn() { try { Class.forName(sDBDriver); } catch(java.lang.ClassNotFoundException e){ System.err.println( e.getMessage()); }} public ResultSet executeQuery(String sql) { rs = null; String r; try { connect = DriverManager.getConnection(sConnStr,user,password); Statement stmt = connect.createStatement(); rs = stmt.executeQuery(sql); while(rs.next()){ r=rs.getString(1).trim(); System.out.println(r);} } catch(SQLException ex) { System.out.println("Ö´ÐÐDataBase::QuerySQL(String)µ÷ÓÃSQLÓï¾ä "+sql+" ʱ³ö´í;\r\n´íÎóΪ:"+ex); } return rs;}public void executeUpdate(String sql) { try { connect = DriverManager.getConnection(sConnStr,user,password); Statement stmt = connect.createStatement(); stmt.executeUpdate(sql); } catch(SQLException ex) { System.err.println(ex.getMessage()); }} public void releaseConn() { try { connect.close(); } catch(SQLException e){System.out.println("¹Ø±ÕÊý¾Ý¿âÁ¬½Óʱ³ö´í;\r\n´íÎóΪ:"+e);} } /* public static void main(String arg[]){ String sql="select ID from member"; conn connecting=new conn(); connecting.executeQuery(sql); }*/} 这就是那段程序,不知道那里有问题 user_tab_partitions 表中的last_analyzed确切含义 在开发软件的时候,可以向用户提供哪些关于数据库的性能指标? c#及数据库的高手帮帮忙 字符串能否直接用作变量名 问一条语句 书上关于表空间的一段话,请大家帮我解疑,thx 我只有redhat linux 9,在家里自学安装和管理oracle,用那个版本的oracle好呢? 在单机上建立oracle数据库的问题 实例(instance),全局数据库名(db_name),系统标识符(SID)怎么区分? 求救:< 插入数据特别慢是怎么回事? 如何写一个view
package tsglxt;
import java.sql.*;
import oracle.sql.*;
import oracle.jdbc.driver.OracleResultSet;public class Conn{
String sDBDriver = "oracle.jdbc.driver.OracleDriver";
String sConnStr = "jdbc:oracle:thin:@localhost:1521:lib";
//Connection connect = null;
String user="bigroc";
String password="roc";
Connection connect=null;
ResultSet rs = null;
public Conn() {
try {
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e){
System.err.println( e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
rs = null;
String r;
try {
connect = DriverManager.getConnection(sConnStr,user,password);
Statement stmt = connect.createStatement();
rs = stmt.executeQuery(sql);
while(rs.next()){
r=rs.getString(1).trim();
System.out.println(r);}
}
catch(SQLException ex) {
System.out.println("Ö´ÐÐDataBase::QuerySQL(String)µ÷ÓÃSQLÓï¾ä "+sql+" ʱ³ö´í;\r\n´íÎóΪ:"+ex);
}
return rs;
}
public void executeUpdate(String sql) {
try {
connect = DriverManager.getConnection(sConnStr,user,password);
Statement stmt = connect.createStatement();
stmt.executeUpdate(sql);
}
catch(SQLException ex) {
System.err.println(ex.getMessage());
}
}
public void releaseConn()
{
try
{
connect.close();
}
catch(SQLException e){System.out.println("¹Ø±ÕÊý¾Ý¿âÁ¬½Óʱ³ö´í;\r\n´íÎóΪ:"+e);}
}
/* public static void main(String arg[]){
String sql="select ID from member";
conn connecting=new conn();
connecting.executeQuery(sql);
}*/
}