DBconn.java如下:
import java.sql.*;
public class DBconn {
String DBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String ConnStr = "jdbc:odbc:db1";
Connection conn = null;
ResultSet rs = null;
public DBconn (){
try {
Class.forName(DBDriver);
//加载数据库驱动程序
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("DBconn (): "+ e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
rs = null;
try {
conn = DriverManager.getConnection(ConnStr);
//与DBMS建立链接
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("aq.executeQuery:"+ex.getMessage());
}
return rs;
}
}
import java.sql.*;
public class DBconn {
String DBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String ConnStr = "jdbc:odbc:db1";
Connection conn = null;
ResultSet rs = null;
public DBconn (){
try {
Class.forName(DBDriver);
//加载数据库驱动程序
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("DBconn (): "+ e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
rs = null;
try {
conn = DriverManager.getConnection(ConnStr);
//与DBMS建立链接
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("aq.executeQuery:"+ex.getMessage());
}
return rs;
}
}
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=gb2312">
<title>班级成绩</title>
</head>
<body>
<p><b>班级成绩</b></p>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="DBconn1" scope="page" class="DBconn" />
<%
ResultSet RS=DBconn1.executeQuery("SELECT * FROM db1");
while(RS.next()){
out.print("<li>"+RS.getString("name")+"</li>");
out.print("<li>"+RS.getString("id")+"</li>");
out.print("<li>"+RS.getString("绩点")+"</li>");
}
RS.close();
%>
</body>
</html>
try
同时放在放在webapps\ROOT\WEB-INF\classes下也不行
我原来就是放在放在webapps\ROOT\WEB-INF\classes下的
工程文件放在webapps\ROOT\下任意目录
要注意要把
\mm.mysql.jdbc-1.2c.tar\mm.mysql.jdbc-1.2c\mysql_comp.jar;
\mm.mysql.jdbc-1.2c.tar\mm.mysql.jdbc-1.2c\mysql_uncomp.jar;
放到\lib下,重起tomcat
jsp文件放在root\bean下也成功了。
我还想请教各位,如果要建立一个自己的文件夹,如webapps\project,在server.xml中已经设好了这个目录的路径,要把jsp文件放这个目录下class文件怎么放?
分一定给大家。