写了两个bean来连接数据库
Conn_DB
package beans;
import java.sql.*;
public class Conn_DB
{
public static Connection getConnection()
{
Connection con=null;
String CLASSFORNAME="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String SERVANDDB="jdbc:microsoft:sqlserver://locathost:1433;DatabaseName=db_login";
String USER="sa";
String PWD="";
try
{
Class.forName(CLASSFORNAME);
con=DriverManager.getConnection(SERVANDDB,USER,PWD);
}
catch(Exception e)
{
e.printStackTrace();
}
return con;
}
}Rs_DB
package beans;
import java.sql.*;public class Rs_DB
{
private Connection con;
public Rs_DB()
{
this.con=Conn_DB.getConnection();
}
public ResultSet getResult(String str)
{
try
{
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(str);
return rs;
}
catch (Exception e)
{
}
return null;
}
}jsp:
<%@ page contentType="text/html; charset=gb2312" language="java" %>
<%@ page import="java.sql.*,java.io.*" errorPage="" %>
<%@ page import="beans.*"%>
<jsp:useBean id="rst" class="beans.Rs_DB" scope="page"/><html>
<body><%
//String username=request.getParameter("username");
//String password=request.getParameter("password");
String str="select * from user_info ";
ResultSet rs=rst.getResult(str);
while(rs.next())
%>
用户名:<% =rs.getString("1") %>
密码:<% =rs.getString("2") %>
<% } %>
</body>
</html>
用的是sql2000,用其他的程序可以访问数据库
大家帮我看看那里写错了。谢谢
Conn_DB
package beans;
import java.sql.*;
public class Conn_DB
{
public static Connection getConnection()
{
Connection con=null;
String CLASSFORNAME="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String SERVANDDB="jdbc:microsoft:sqlserver://locathost:1433;DatabaseName=db_login";
String USER="sa";
String PWD="";
try
{
Class.forName(CLASSFORNAME);
con=DriverManager.getConnection(SERVANDDB,USER,PWD);
}
catch(Exception e)
{
e.printStackTrace();
}
return con;
}
}Rs_DB
package beans;
import java.sql.*;public class Rs_DB
{
private Connection con;
public Rs_DB()
{
this.con=Conn_DB.getConnection();
}
public ResultSet getResult(String str)
{
try
{
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(str);
return rs;
}
catch (Exception e)
{
}
return null;
}
}jsp:
<%@ page contentType="text/html; charset=gb2312" language="java" %>
<%@ page import="java.sql.*,java.io.*" errorPage="" %>
<%@ page import="beans.*"%>
<jsp:useBean id="rst" class="beans.Rs_DB" scope="page"/><html>
<body><%
//String username=request.getParameter("username");
//String password=request.getParameter("password");
String str="select * from user_info ";
ResultSet rs=rst.getResult(str);
while(rs.next())
%>
用户名:<% =rs.getString("1") %>
密码:<% =rs.getString("2") %>
<% } %>
</body>
</html>
用的是sql2000,用其他的程序可以访问数据库
大家帮我看看那里写错了。谢谢
rs.getString("2")
把""去掉,再有问题的话建议你把错误贴出来看看
这句话有错,locathost:写错了,应该是localhost
改了再试试看,其他的好像没有什么问题。
看看这里是否跟你一样。
http://community.csdn.net/Expert/topic/5456/5456357.xml?temp=.3751032
Generated servlet error:
F:\Program Files\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\myweb\org\apache\jsp\login_jsp.java:71: 非法的表达式开始
=rs.getString(1)
^
An error occurred at line: 18 in the jsp file: /login.jsp
Generated servlet error:
F:\Program Files\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\myweb\org\apache\jsp\login_jsp.java:74: 非法的表达式开始
=rs.getString(2)
^
Generated servlet error:
F:\Program Files\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\myweb\org\apache\jsp\login_jsp.java:33: "try" 不带有 "catch" 或 "finally"
try {
^
Generated servlet error:
F:\Program Files\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\myweb\org\apache\jsp\login_jsp.java:81: 非法的类型开始
} catch (Throwable t) {
^
Generated servlet error:
F:\Program Files\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\myweb\org\apache\jsp\login_jsp.java:91: 需要 <标识符>
}
^
Generated servlet error:
F:\Program Files\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\myweb\org\apache\jsp\login_jsp.java:92: 需要 "class" 或 "interface"
}
^
Generated servlet error:
F:\Program Files\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\myweb\org\apache\jsp\login_jsp.java:93: 需要 "class" 或 "interface"
^
7 错误 org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:332)
org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:437)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:497)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:476)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:464)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:511)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:295)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)note The full stack trace of the root cause is available in the Apache Tomcat/5.0.30 logs.
这句话后面差一个{
Generated servlet error:
F:\Program Files\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\myweb\org\apache\jsp\login_jsp.java:71: 非法的表达式开始
=rs.getString(1)
^
An error occurred at line: 18 in the jsp file: /login.jsp
Generated servlet error:
F:\Program Files\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\myweb\org\apache\jsp\login_jsp.java:74: 非法的表达式开始
=rs.getString(2)
^
2 错误 org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:332)
org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:437)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:497)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:476)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:464)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:511)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:295)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)note The full stack trace of the root cause is available in the Apache Tomcat/5.0.30 logs.
再次流泪感谢
把两个<%和=之间的空格去掉