Database类、网页、TOMCAT6.0下出现的问题如下:
Database类
import java.sql.*;
public class Database {
private Connection con;
private Statement sql;
private ResultSet rs;
public Database(){
String url="jdbc:odbc:zheng";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){
}
try{
con=DriverManager.getConnection(url,"","");
sql=con.createStatement();
}
catch(SQLException e){
}
}
public void update(String insertStr){
try{
sql.executeUpdate(insertStr);
}
catch(SQLException e){
}
}
public ResultSet query(String queryStr){
try{
rs=sql.executeQuery(queryStr);
return rs;
}
catch(SQLException e){
}
finally {
return rs;
}
}
public String getResult(String col){
try{
while(rs.next()){
String result=rs.getString(col);
return result;
}
System.out.println("No existing!");
}
catch(SQLException e){
}
return "No existing!";
}
public void closeAll(){
try{
rs.close();
sql.close();
con.close();
}
catch(SQLException e){
}
}
}
JSP网页如下
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.util.*" %>
<%@ page import="javabean.Datetime"%>
<%@ page import="javabean.Database"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body>
<%
request.setCharacterEncoding("gb2312");
String username=request.getParameter("textfield1");
String password=request.getParameter("textfield2");
String phone=request.getParameter("textfield4");
String qq=request.getParameter("textfield5");
String school=request.getParameter("textfield6");
String specialty=request.getParameter("textfield7");
%>
<%
Datetime datetime=new Datetime();
String usertime=datetime.gettime();
String insert=null;
insert="insert into login_user (username,password,phone,qq,school,specialty,usertime) values "+"("+"'"+username+"'"+","+"'"+password+"'"+","+"'"+phone+"'"+","+"'"+qq+"'"+","+"'"+school+"'"+","+"'"+specialty+"'"+","+"'"+usertime+"'"+")";
Database database=new Database();
database.update(insert);
database.closeAll();
out.println("注册成功");
%>
<%=username%>
</body>
</html>
问题如下:
An error occurred at line: 27 in the jsp file: /myweb/get_register.jsp
Database cannot be resolved to a type
Stacktrace:
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:85)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:415)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:308)
Database类
import java.sql.*;
public class Database {
private Connection con;
private Statement sql;
private ResultSet rs;
public Database(){
String url="jdbc:odbc:zheng";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){
}
try{
con=DriverManager.getConnection(url,"","");
sql=con.createStatement();
}
catch(SQLException e){
}
}
public void update(String insertStr){
try{
sql.executeUpdate(insertStr);
}
catch(SQLException e){
}
}
public ResultSet query(String queryStr){
try{
rs=sql.executeQuery(queryStr);
return rs;
}
catch(SQLException e){
}
finally {
return rs;
}
}
public String getResult(String col){
try{
while(rs.next()){
String result=rs.getString(col);
return result;
}
System.out.println("No existing!");
}
catch(SQLException e){
}
return "No existing!";
}
public void closeAll(){
try{
rs.close();
sql.close();
con.close();
}
catch(SQLException e){
}
}
}
JSP网页如下
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.util.*" %>
<%@ page import="javabean.Datetime"%>
<%@ page import="javabean.Database"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body>
<%
request.setCharacterEncoding("gb2312");
String username=request.getParameter("textfield1");
String password=request.getParameter("textfield2");
String phone=request.getParameter("textfield4");
String qq=request.getParameter("textfield5");
String school=request.getParameter("textfield6");
String specialty=request.getParameter("textfield7");
%>
<%
Datetime datetime=new Datetime();
String usertime=datetime.gettime();
String insert=null;
insert="insert into login_user (username,password,phone,qq,school,specialty,usertime) values "+"("+"'"+username+"'"+","+"'"+password+"'"+","+"'"+phone+"'"+","+"'"+qq+"'"+","+"'"+school+"'"+","+"'"+specialty+"'"+","+"'"+usertime+"'"+")";
Database database=new Database();
database.update(insert);
database.closeAll();
out.println("注册成功");
%>
<%=username%>
</body>
</html>
问题如下:
An error occurred at line: 27 in the jsp file: /myweb/get_register.jsp
Database cannot be resolved to a type
Stacktrace:
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:85)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:415)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:308)