小女的一个JDBC问题

[zhaofang1972]

写了一个c/s的数据库插入代码:
服务器：
import java.net.*;
import java.io.*;
import java.sql.*;
public class server{
public static void main(String args[]){
ServerSocket serverSocket;
Socket clientSocket;
BufferedReader br;
PrintStream ps;
String username,password,email,homepage,money;
String outString,sql;
String url="jdbc:oracle:thin:@fz1212:1521:oradb";

try{
Class.forName("oracle:jdbc:driver.OracleDriver");
Connection con=DriverManager.getConnection(url,"scott","tiger");
Statement stmt=con.createStatement();

serverSocket=new ServerSocket(8888);
clientSocket=serverSocket.accept();

br=new BufferedReader(new InputStreamReader(clientSocket.getInputStream()));
ps=new PrintStream(clientSocket.getOutputStream());

username=br.readLine();
outString="\t\t\t\t\tÄãÊäÈëµÄÐÕÃûÊÇ:"+username;
ps.println(outString);
ps.flush();

password=br.readLine();
outString="\t\t\t\t\tÄãÊäÈëµÄÃÜÂëÊÇ:"+password;
ps.println(outString);
ps.flush();

email=br.readLine();
outString="\t\t\t\t\tÄãÊäÈëµÄÓʼþµØÖ·ÊÇ:"+email;
ps.println(outString);
ps.flush();

homepage=br.readLine();
outString="\t\t\t\t\tÄãÊäÈëµÄÖ÷Ò³ÊÇ:"+homepage;
ps.println(outString);
ps.flush();

money=br.readLine();
outString="\t\t\t\t\tÄãÊäÈëµÄ½ð¶îÊÇ:"+money;
ps.println(outString);
ps.flush();

sql="insert into userinfo values(\'"+username+"\',\'"+password+"\',\'"+email+"\',\'"+homepage+"\',sysdate,"+money+")";
int ret=stmt.executeUpdate(sql);

br.close();
ps.close();

stmt.close();
con.close();

serverSocket.close();
clientSocket.close();
}catch(Exception e){
System.err.println(e);
}
}
}




客户
import java.net.*;
import java.io.*;
public class client{
public static void main(String args[]){
Socket clientSocket;
BufferedReader br1,br2;
PrintStream ps;
String username,password,email,homepage,money,inString;
try{
clientSocket=new Socket("fz1212",8888);
br1=new BufferedReader(new InputStreamReader(System.in));
br2=new BufferedReader(new InputStreamReader(clientSocket.getInputStream()));
ps=new PrintStream(clientSocket.getOutputStream());
System.out.println("ÇëÊäÈëÓû§ÐÕÃû(±ØÊäÏî,×î¶à20¸ö×Ö·û):");
username=br1.readLine();
ps.println(username);
ps.flush();

inString=br2.readLine();
System.out.println(inString);

System.out.println("ÇëÊäÈëÃÜÂë(±ØÊäÏî,×î¶à20¸ö×Ö·û):");
password=br1.readLine();
ps.println(password);
ps.flush();

inString=br2.readLine();
System.out.println(inString);

System.out.println("ÇëÊäÈëµç×ÓÓʼþµØÖ·(×î¶à30¸ö×Ö·û):");
email=br1.readLine();
ps.println(email);
ps.flush();

inString=br2.readLine();
System.out.println(inString);

System.out.println("ÇëÊäÈë¸öÈËÖ÷Ò³(×î¶à50¸ö×Ö·û):");
homepage=br1.readLine();
ps.println(homepage);
ps.flush();

inString=br2.readLine();
System.out.println(inString);

System.out.println("ÇëÊäÈë½ð¶î(±ØÊäÏî,Ö»ÄÜÊÇÊý×Ö):");
money=br1.readLine();
ps.println(money);
ps.flush();

inString=br2.readLine();
System.out.println(inString);

br1.close();
br2.close();
ps.close();
clientSocket.close();
}catch(Exception e){
System.err.println(e);
}
}
}
编以后运行时异常：java.lang.ClassNotFoundException: oracle:jdbc:driver/OracleDriver
怎么回事呢？我刚开始学java，classes12.jar也加进去了

[zhaofang1972]

哦，我有个地方写错了。但是当我改正过来之后会出现：
java.sql.SQLException: Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=150
999297)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
Press any key to continue...
我想应该是数据库设置的问题，请大家指点

[yoken]

oracle:jdbc:driver.OracleDriver-〉oracle.jdbc.driver.OracleDriver
oracle.jdbc.driver是个package

[xujie839997]

关注！

[jxnclhjjxnclhj]

up

[hanty]

顶

[cyicecream]

Class.forName("oracle:jdbc:driver.OracleDriver");
Class.forName("oracle.jdbc.driver.OracleDriver");
再运行试试

[HurricanDavidLiu]

yoken(雨泉) 说的有理

[favourl]

up，肯定时JDBC的类配错了