import java.awt.*;
import java.net.*;
import java.sql.*;
import java.awt.event.*; public void Liststudent2() throws SQLException
{String name;int math,english,physics,sum;
try{Class.forName("oracle.jdbc.driver.oracleDriver");}
catch(ClassNotFoundException e){}
Connection adCon=DriverManager.getConnection("jdbc:oracle:thin:@myhost:1521:orcl","system","manager");
Statement sql=adCon.createStatement();
ResultSet rs=sql.executeQuery("SELECT * FROM zhengran;");
while(rs.next())
{name=rs.getString("学号");math=rs.getInt("姓名");
physics=rs.getInt("性别");english=rs.getInt("分数");
// sum=english+math+physics;
text.append("****"+name+math+physics+english);
}
}这是一个连接数据库地例子,怎么连不上呢,初学orale,请朋友告诉那里参数设置不当,请指教;
是装完orale还的装驱动吗,(我的orale建表操作的好使)谢谢
import java.net.*;
import java.sql.*;
import java.awt.event.*; public void Liststudent2() throws SQLException
{String name;int math,english,physics,sum;
try{Class.forName("oracle.jdbc.driver.oracleDriver");}
catch(ClassNotFoundException e){}
Connection adCon=DriverManager.getConnection("jdbc:oracle:thin:@myhost:1521:orcl","system","manager");
Statement sql=adCon.createStatement();
ResultSet rs=sql.executeQuery("SELECT * FROM zhengran;");
while(rs.next())
{name=rs.getString("学号");math=rs.getInt("姓名");
physics=rs.getInt("性别");english=rs.getInt("分数");
// sum=english+math+physics;
text.append("****"+name+math+physics+english);
}
}这是一个连接数据库地例子,怎么连不上呢,初学orale,请朋友告诉那里参数设置不当,请指教;
是装完orale还的装驱动吗,(我的orale建表操作的好使)谢谢
Connection conn=new OracleDriver().defaultConnection();
试试看
java -classpath /oracle/jdbc/class12.zip
你使用的是thin连接,不需要安装oracle client