Help me aoubt java in php4
| From: | smallsnake | Date: | Thu, 10 Aug 2000 06:19:46 +0000 |
| Subject: | Help me aoubt java in php4 | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-11069@lists.php.net to get a copy of this message | ||
<?
$dbUrl = "jdbc:odbc:localdb";
$user = "sa";
$password = "";
$cls=new JAVA("java.lang.Class");
$c1s->forName="sun.jdbc.odbc.JdbcOdbcDriver";
$conn = new JAVA("java.sql.Connection");
$drv = new JAVA("java.sql.DriverManager");
$conn = $drv->getConnection($dbUrl, $user, $password); /* line 10 */
$stam = new JAVA("java.sql.Statement");
$stam = $conn->createStatement();
$rest = new JAVA("java.sql.ResultSet");
$rest = $stam->executeQuery("SELECT NAME FROM GUESTBOOK ");
while($rest->next())
{
echo $rest->getString("NAME");
}
?>
The error is:
Warning: java.sql.SQLException: No suitable driver in e:\php\program\jsp.php
on line 10
Fatal error: Call to a member function on a non-object in
e:\php\program\jsp.php on line 13
The "localdb" is the odbc system dsn.
My java program is success.
How to do that,thanks a lot.