81,094
社区成员
发帖
与我相关
我的任务
分享
C:\Documents and Settings\Shaun>javac C:\jakarta-tomcat\webapps\Assignment1\WEB-
INF\classes\mypack\ShowBalance.java
C:\jakarta-tomcat\webapps\Assignment1\WEB-INF\classes\mypack\ShowBalance.java:47
: cannot resolve symbol
symbol : class BankCustomer
location: class mypack.ShowBalance
BankCustomer bc = new BankCustomer(userid, username, bal
ance, level);
^
C:\jakarta-tomcat\webapps\Assignment1\WEB-INF\classes\mypack\ShowBalance.java:47
: cannot resolve symbol
symbol : class BankCustomer
location: class mypack.ShowBalance
BankCustomer bc = new BankCustomer(userid, username, bal
ance, level);
^
2 errors
package mypack;
import java.io.*;
import java.sql.*;
import java.util.*;
public class ShowBalance {
public ShowBalance(String UserName)
throws IOException{
try{
String clientName = UserName;
//connect to database
String dbUrl = "jdbc:mysql://localhost:3306/balancecontrol";
String dbUser = "Jay";
String dbPwd = "123456";
//load driver
Class.forName("com.mysql.jdbc.Driver");
//regesister driver
java.sql.DriverManager.registerDriver(new com.mysql.jdbc.Driver());
Connection con = java.sql.DriverManager.getConnection(dbUrl,dbUser,dbPwd);
Statement stmt = con.createStatement();
String sql = "select user_id, user_name, balance, level from user_balance where user_name = '" + clientName + "' ";
ResultSet rs = stmt.executeQuery(sql);
int userid = 1000;
String username = "New Customer";
float balance = 0;
int level = 3;
if(rs.next()){
userid = rs.getInt("user_id");
username = rs.getString("user_name");
balance = rs.getFloat("balance");
level = rs.getInt("level");
}
rs.close();
stmt.close();
con.close();
BankCustomer bc = new BankCustomer(userid, username, balance, level);
}
catch(Exception e){
throw new IOException(e.getMessage());
}
}
}
package mypack;
public class BankCustomer{
private int userid = 1000;
private String username = "New Customer";
private float balance = 0;
private int level = 3;
public void Bankcustomer(int userid, String username, float balance, int level){
this.userid = userid;
this.username = username;
this.balance = balance;
this.level = level;
}
public int getUserID(){
return userid;
}
public String getUserName(){
return username;
}
public float getBalance(){
return balance;
}
public int getLevel(){
return level;
}
}
public BankCustomer(int userid, String username, float balance, int level){
this.userid = userid;
this.username = username;
this.balance = balance;
this.level = level;
}
public Bankcustomer(int userid, String username, float balance, int level){
this.userid = userid;
this.username = username;
this.balance = balance;
this.level = level;
}
public void Bankcustomer(int userid, String username, float balance, int level){
this.userid = userid;
this.username = username;
this.balance = balance;
this.level = level;
}
public void Bankcustomer(int userid1, String username1, float balance1, int level1){
this.userid = userid1;
this.username = username1;
this.balance = balance1;
this.level = level1;
}