jbuilder4.0中如何开发数据库应用？

javaduke 2001-01-09 09:37:00

我想在jsp中开发关于jdatastore的数据库应用，总是不好使！
jsp源文件如下：
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>

<body bgcolor="#FFFFFF">

<%@ page import="java.util.*" %>
<%@ page import="java.lang.*" %>
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*"%>
<%

Connection c = null;
String URL = "jdbc:borland:dslocal:";
String dbUrl = "DataBBS.jds";
Statement st = null;
String FILE = "F:/workshop/Borland/DataBBS/data/data.jds";
String jds="jdbc:borland:dslocal:/F:/workshop/Borland/DataBBS/data/data.jds";

try {
// Load the Hyper Sonic SQL driver
Class.forName("com.borland.datastore.jdbc.DataStoreDriver");
//c=DriverManager.getConnection(jds,"","");
c = DriverManager.getConnection(FILE, "", "");
st = c.createStatement();
} catch(Exception e) {
out.println(e.getMessage());
return;
}

try {
st.executeUpdate("CREATE TABLE TEST (YEAR INTEGER, STATE VARCHAR(32), NAME INTEGER)");
} catch(Exception e) {
out.println(e.toString());
return;
}
%>
</body>
</html>
运行后提示：
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>

<body bgcolor="#FFFFFF">

<%@ page import="java.util.*" %>
<%@ page import="java.lang.*" %>
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*"%>
<%

Connection c = null;
String URL = "jdbc:borland:dslocal:";
String dbUrl = "DataBBS.jds";
Statement st = null;
String FILE = "F:/workshop/Borland/DataBBS/data/data.jds";
String jds="jdbc:borland:dslocal:/F:/workshop/Borland/DataBBS/data/data.jds";

try {
// Load the Hyper Sonic SQL driver
Class.forName("com.borland.datastore.jdbc.DataStoreDriver");
//c=DriverManager.getConnection(jds,"","");
c = DriverManager.getConnection(FILE, "", "");
st = c.createStatement();
} catch(Exception e) {
out.println(e.getMessage());
return;
}

try {
st.executeUpdate("CREATE TABLE TEST (YEAR INTEGER, STATE VARCHAR(32), NAME INTEGER)");
} catch(Exception e) {
out.println(e.toString());
return;
}
%>
</body>
</html>
运行后提示：
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>

<body bgcolor="#FFFFFF">

<%@ page import="java.util.*" %>
<%@ page import="java.lang.*" %>
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*"%>
<%

Connection c = null;
String URL = "jdbc:borland:dslocal:";
String dbUrl = "DataBBS.jds";
Statement st = null;
String FILE = "F:/workshop/Borland/DataBBS/data/data.jds";
String jds="jdbc:borland:dslocal:/F:/workshop/Borland/DataBBS/data/data.jds";

try {
// Load the Hyper Sonic SQL driver
Class.forName("com.borland.datastore.jdbc.DataStoreDriver");
//c=DriverManager.getConnection(jds,"","");
c = DriverManager.getConnection(FILE, "", "");
st = c.createStatement();
} catch(Exception e) {
out.println(e.getMessage());
return;
}

try {
st.executeUpdate("CREATE TABLE TEST (YEAR INTEGER, STATE VARCHAR(32), NAME INTEGER)");
} catch(Exception e) {
out.println(e.toString());
return;
}
%>
</body>
</html>
运行后提示：
java.sql.SQLException: No suitable driver
why????

...全文