package haha;import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Properties;
import java.sql.*;
import java.util.ArrayList;public class ConnectDB { private String user = "sysdba";
private String password = "sdm";
private String lc_ctype = "SJIS_0208";
private String database =
"E:\\java_project\\StudyJSP\\DB\\JavaBeanConnDB.FDB";
private String DBdriveClass = "org.firebirdsql.jdbc.FBDriver";
private String DBlocalhost = "jdbc:firebirdsql:localhost/3050:";
private static Connection conn = null;
ArrayList relist = null;
private ArrayList temp = null;
public ConnectDB() {
try {
Class.forName(DBdriveClass);
} catch (ClassNotFoundException ex) {
ex.printStackTrace();
}
Properties conProps = new Properties();
conProps.put("user", user);
conProps.put("password", password);
conProps.put("lc_ctype", lc_ctype);
try {
conn = DriverManager.getConnection(DBlocalhost + database, conProps);
} catch (SQLException ex) {
ex.printStackTrace();
}
Statement stat = null;
String sql = null;
try {
stat = conn.createStatement();
sql = "select max(template_ID) from swmt_template";
} catch (SQLException ex) {
ex.printStackTrace();
}
relist = getSapaResultSet(stat, sql);
getTemp();
} public String getTemp() {
temp = (ArrayList) relist.get(0);
System.out.print(temp.get(0).toString());
return temp.get(0).toString();
} public ArrayList getSapaResultSet(Statement st, String strSQL) {
ResultSet rs = null;
ArrayList dataList = new ArrayList();
ArrayList colarraylist;
try {
rs = st.executeQuery(strSQL);
ResultSetMetaData resultsetmetadata = rs.getMetaData();
while (rs.next()) {
colarraylist = new ArrayList();
for (int i = 1; i <= resultsetmetadata.getColumnCount(); i++) {
String colname = resultsetmetadata.getColumnName(i);
colarraylist.add(rs.getObject(colname));
}
dataList.add(colarraylist);
colarraylist = null;
}
rs.close();
} catch (Exception e) {
e.printStackTrace();
System.exit(0);
}
return dataList;
} public static void main(String[] args) {
new ConnectDB();
}}
上面是我使用javaBean连接数据库,测试过时好用的但是在我使用jsp页面调用的时候就报错说我没有装载的fireBird驱动?
<%@page language="java"%>
<%@page contentType="text/html; charset=Shift_JIS"%>
<jsp:useBean id="bean" class="haha.jspBean" scope="page"/>
<jsp:setProperty name="bean" property="*"/>
<html>
<head>
<title>jspandjavaBean</title>
</head>
<body bgcolor="#ffffff">
<h1>jghdfg
<%
Stirng thisTemp = bean.getTemp();
out.println(thisTemp);
%>
</h1>
</body>
</html>
请教高人怎么回事?
import java.sql.DriverManager;
import java.util.Properties;
import java.sql.*;
import java.util.ArrayList;public class ConnectDB { private String user = "sysdba";
private String password = "sdm";
private String lc_ctype = "SJIS_0208";
private String database =
"E:\\java_project\\StudyJSP\\DB\\JavaBeanConnDB.FDB";
private String DBdriveClass = "org.firebirdsql.jdbc.FBDriver";
private String DBlocalhost = "jdbc:firebirdsql:localhost/3050:";
private static Connection conn = null;
ArrayList relist = null;
private ArrayList temp = null;
public ConnectDB() {
try {
Class.forName(DBdriveClass);
} catch (ClassNotFoundException ex) {
ex.printStackTrace();
}
Properties conProps = new Properties();
conProps.put("user", user);
conProps.put("password", password);
conProps.put("lc_ctype", lc_ctype);
try {
conn = DriverManager.getConnection(DBlocalhost + database, conProps);
} catch (SQLException ex) {
ex.printStackTrace();
}
Statement stat = null;
String sql = null;
try {
stat = conn.createStatement();
sql = "select max(template_ID) from swmt_template";
} catch (SQLException ex) {
ex.printStackTrace();
}
relist = getSapaResultSet(stat, sql);
getTemp();
} public String getTemp() {
temp = (ArrayList) relist.get(0);
System.out.print(temp.get(0).toString());
return temp.get(0).toString();
} public ArrayList getSapaResultSet(Statement st, String strSQL) {
ResultSet rs = null;
ArrayList dataList = new ArrayList();
ArrayList colarraylist;
try {
rs = st.executeQuery(strSQL);
ResultSetMetaData resultsetmetadata = rs.getMetaData();
while (rs.next()) {
colarraylist = new ArrayList();
for (int i = 1; i <= resultsetmetadata.getColumnCount(); i++) {
String colname = resultsetmetadata.getColumnName(i);
colarraylist.add(rs.getObject(colname));
}
dataList.add(colarraylist);
colarraylist = null;
}
rs.close();
} catch (Exception e) {
e.printStackTrace();
System.exit(0);
}
return dataList;
} public static void main(String[] args) {
new ConnectDB();
}}
上面是我使用javaBean连接数据库,测试过时好用的但是在我使用jsp页面调用的时候就报错说我没有装载的fireBird驱动?
<%@page language="java"%>
<%@page contentType="text/html; charset=Shift_JIS"%>
<jsp:useBean id="bean" class="haha.jspBean" scope="page"/>
<jsp:setProperty name="bean" property="*"/>
<html>
<head>
<title>jspandjavaBean</title>
</head>
<body bgcolor="#ffffff">
<h1>jghdfg
<%
Stirng thisTemp = bean.getTemp();
out.println(thisTemp);
%>
</h1>
</body>
</html>
请教高人怎么回事?
<%@ page language="java" import="org.firebirdsql.jdbc.FBDriver"%>