}catch(SQLException se){ System.err.println("抛出SQL异常"); } return record; } ................. } 测试:package com.bluesoft.crazy;/** * * @author Administrator */ public class Test { public static void main(String[] args){ ChatBean chat; boolean has=false; //String userName="CRAZY"; //String passWord="CRAZY"; //String sql="SELECT * FROM USERINFO WHERE USERNAME='"+userName+"'"+" AND "+"PASSWORD='"+passWord+"'"; chat = new com.bluesoft.crazy.ChatBean(); has=chat.executeQuery("SELECT * FROM USERINFO WHERE USERNAME='CRAZY' AND PASSWORD='CRAZY'"); if(has){ System.out.println("This is 正确"); }else{ System.out.println("This is 错误"); } } } 错误信息: java.sql.SQLException: ORA-00600: 内部错误代码,参数: [ttcgcshnd-1], [0], [], [], [], [], [], [] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:542) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1311) at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:797) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1608) at oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1758) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1805) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:410) at com.bluesoft.crazy.ChatBean.executeQThis is 错误 uery(ChatBean.java:46) at com.bluesoft.crazy.Test.main(Test.java:21) 600,60000 This is 错误服务器:Tomcat 4.1 拜托了,否则我的工作就无法继续下去了。。 拜托。
package com.bluesoft.crazy;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
/**
*
* @author Administrator
*/
public class ChatBean {
String driverStr="oracle.jdbc.driver.OracleDriver";
String urlStr="jdbc:oracle:thin:@192.168.95.92:1521:topshine";
Connection conn=null;
ResultSet rs=null;
boolean has=false;
HttpSession session;
HttpServletRequest request;
String defaultStr="";
//构造方法ChatBean()
public ChatBean() {
try{
Class.forName(driverStr);
}catch(ClassNotFoundException e){
System.err.println("装载驱动程序失败");
}
}
//Context环境设置
public void setContext(HttpServletRequest request,HttpSession session){
this.request=request;
this.session=session;
}
//SQL查询语句的执行
public synchronized boolean executeQuery(String sql){
Statement stmt=null;
ResultSet rst=null;
try{
conn=DriverManager.getConnection(urlStr,"CRAZY_CHAT","zht");
stmt=conn.createStatement();
rst=stmt.executeQuery(sql);
if(rst.next())
has=true;
else
has=false;
}catch(SQLException se){
se.printStackTrace();
System.err.println(se.getErrorCode() + "," + se.getSQLState());
//System.err.println("抛出SQL异常");
}
return has;
}
//SQL Update命令的执行
public synchronized int executeUpdate(String sql){
int record=-1;
try{
conn=DriverManager.getConnection(urlStr,"CRAZY_CHAT","zht");
Statement stmt=conn.createStatement();
record=stmt.executeUpdate(sql);
}catch(SQLException se){
System.err.println("抛出SQL异常");
}
return record;
}
.................
}
测试:package com.bluesoft.crazy;/**
*
* @author Administrator
*/
public class Test {
public static void main(String[] args){
ChatBean chat;
boolean has=false;
//String userName="CRAZY";
//String passWord="CRAZY";
//String sql="SELECT * FROM USERINFO WHERE USERNAME='"+userName+"'"+" AND "+"PASSWORD='"+passWord+"'";
chat = new com.bluesoft.crazy.ChatBean();
has=chat.executeQuery("SELECT * FROM USERINFO WHERE USERNAME='CRAZY' AND PASSWORD='CRAZY'");
if(has){
System.out.println("This is 正确");
}else{
System.out.println("This is 错误");
}
}
}
错误信息:
java.sql.SQLException: ORA-00600: 内部错误代码,参数: [ttcgcshnd-1], [0], [], [], [], [], [], []
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:542)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1311)
at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:797)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1608)
at oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1758)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1805)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:410)
at com.bluesoft.crazy.ChatBean.executeQThis is 错误
uery(ChatBean.java:46)
at com.bluesoft.crazy.Test.main(Test.java:21)
600,60000
This is 错误服务器:Tomcat 4.1
拜托了,否则我的工作就无法继续下去了。。
拜托。
查ORACLE9I文档,好像是ORACLE9I内存结构出了问题,
所以我重装了系统。。
问题是解决了。^_^。
好愚蠢的做法阿。我觉得我。