我在写jsp时用了一个连接数据库的bean
出现了一下错误:
An error occurred at line: 9 in the jsp file: /bean.jsp
Generated servlet error:
UserData cannot be resolved to a type
代码如下:Bean.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" import ="java.sql.*" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JAVA BEAN连接数据库</title>
</head>
<body>
<jsp:useBean id="QureyBean" class="QureyBean" scope="session" >
</jsp:useBean>
<%
Connection conn = QureyBean.setConnection("master");
ResultSet rs = QureyBean.getQurey("select * from users");
while(rs.next() )
{
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
}
%>
</body>
</html>/* QureyBean.java */
import java.sql.*;
public class QureyBean { private Connection conn = null;
private ResultSet rs = null;
private String dbs;
public QureyBean()
{
}
public Connection setConnection(String db)
{
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DataBase = '" + db + "'","sa","");
}catch(Exception e)
{
System.out.println("throw exception!!");
e.printStackTrace();
}
return conn;
}
public ResultSet getQurey(String sqls)
{
try
{
Statement statement = conn.createStatement();
rs = statement.executeQuery(sqls);
}catch(Exception e)
{
System.out.println(e.toString());
}
return rs;
}
}
出现了一下错误:
An error occurred at line: 9 in the jsp file: /bean.jsp
Generated servlet error:
UserData cannot be resolved to a type
代码如下:Bean.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" import ="java.sql.*" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JAVA BEAN连接数据库</title>
</head>
<body>
<jsp:useBean id="QureyBean" class="QureyBean" scope="session" >
</jsp:useBean>
<%
Connection conn = QureyBean.setConnection("master");
ResultSet rs = QureyBean.getQurey("select * from users");
while(rs.next() )
{
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
}
%>
</body>
</html>/* QureyBean.java */
import java.sql.*;
public class QureyBean { private Connection conn = null;
private ResultSet rs = null;
private String dbs;
public QureyBean()
{
}
public Connection setConnection(String db)
{
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DataBase = '" + db + "'","sa","");
}catch(Exception e)
{
System.out.println("throw exception!!");
e.printStackTrace();
}
return conn;
}
public ResultSet getQurey(String sqls)
{
try
{
Statement statement = conn.createStatement();
rs = statement.executeQuery(sqls);
}catch(Exception e)
{
System.out.println(e.toString());
}
return rs;
}
}
解决方案 »
- 静态方法的重写问题
- 如图JTable 添加了JScrollpane以后,如何消除列头上的ABC.....
- Exception in thread "main" java.lang.OutOfMemoryError: Java heap space
- list排序
- 为什么这段代码会这么慢
- 请问大家现在一般用什么工具进行UML建模?要比较流行的和容易使用的
- 面试题目,请牛人帮我看看
- exception类有何作用?每个exception类得对象代表了什么
- java文件读取大揭秘
- abstract的method为什么不能试static,native,以及syncgronized的?
- ServerSocket处于Accept()阻塞状态,如何写代码结束这种状态?
- 我在看一个程序,看来看去就是不知道怎么回事>大侠们你们知道么?
UserData不能解决为一个类型
你是不是用了什么你没有导入的类
看你的代码本身是没有什么问题的
javax.servlet.ServletException: 无法解析的编译问题:
QureyBean 不能解析为类型
QureyBean 不能解析为类型
QureyBean 不能解析为类型 org.apache.jasper.servlet.JspServlet.service(JspServlet.java:272)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)bean要怎样加包啊?
package temp
/* QureyBean.java */
import java.sql.*;
public class QureyBean {
`````````````````````````````````````
```````````````````````````````````````
/* bean.jsp */
<body>
<jsp:useBean id="QureyBean" class="temp.QureyBean" scope="session" >
</jsp:useBean>
<%
````````````````````````````
`````````````````````````````对不?
还有你的程序还有问题 Connection conn = QureyBean.setConnection("master");
返回Connection却没用
如果只是设置String db没必要返回
你这样Statement statement = conn.createStatement();
这里conn为空