java能连上数据库_jsp usebean调用不行_jsp中调用javabean数据库连接不上

我在javabean中添了代码进行测试，能够连接上数据库的，可是到jsp页面调用时，提示“数据库连接失败！代码：packagecom.db;importjava.sql.Connection;importjava.sql.DriverManager;...

我在javabean中添了代码进行测试，能够连接上数据库的，可是到jsp页面调用时，提示“数据库连接失败！

代码：

package com.db;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class buyer {

private String memberID = null ; //会员ID

private String memberName = null; //会员姓名

private String pwd = null;

private Connection conn=null;

private ResultSet rs=null;

public buyer(){

try{

Class.forName("com.mysql.jdbc.Driver");

}

catch(Exception e){

System.err.println("驱动失败");

}

}

public String getName(){

try{

conn= DriverManager.getConnection("jdbc:mysql://localhost:3306/shudian","root","1234");

Statement stmt = conn.createStatement();

String sql="select memberName from buyerinfo where memberID='"+memberID+"'and pwd='"+pwd+"'";

rs= stmt.executeQuery(sql);

while (rs.next()){

//会员姓名

memberName = rs.getString("memberName");

}

stmt.close();

conn.close();

}

catch(SQLException e){

System.out.println("连接失败");

}

return memberName;

}

/**

* @param args

*/

public void setMemberID(String ID){

this.memberID = ID;

}

//设置pwd 属性

public void setPwd(String password){

this.pwd = password;

}

public String getMemberID(){

returnthis.memberID;

}

//设置pwd 属性

public String getPwd(){

return this.pwd;

}

}

jsp部分代码：

网上书店

buyer=new com.db.buyer();

String memberID = request.getParameter("memberID");

String pwd = request.getParameter("pwd");

buyer.setMemberID(memberID);

buyer.setPwd(pwd);

String memberName=buyer.getName();

%>

欢迎来到网上书店

展开