나 회원가입 홈페이지 만드는데 DB연동에 자꾸 오류나ㅜㅜ 도와줘ㅜㅜㅜㅜ
DBConnectionPool.java
//package bean.database;
import java.sql.*;
import java.util.*;
class DBConnectionPool
{
private final int maxConnNum=50;
private Vector connStack=new Vector();
private String id;
private String pass;
private String url;
private int loanConnNum;
public DBConnectionPool(String url,String id,String pass){
this.url=url;
this.id=id;
this.pass=pass;
}
public synchronized Connection getConnection() throws Exception {
Connection connection=null;
while(connStack.size()<=0){
if(loanConnNum<maxConnNum){
connection=makeConnection();
break;
}
else
wait();
}
if(connection==null){
connection=(Connection)connStack.get(0);
connStack.removeElementAt(0);
if(connection.isClosed())
connection=makeConnection();
}
loanConnNum++;
return connection;
}
private Connection makeConnection() throws Exception{
Connection connection=DriverManager.getConnection(url,id,pass);
return connection;
}
public synchronized void returnConnection(Connection connection){
connStack.add(connection);
loanConnNum--;
notifyAll();
}
public synchronized void close() throws Exception{
for(int i=0;i<connStack.size();i++){
Connection connection=(Connection)connStack.get(i);
connection.close();
}
connStack.removeAllElements();
}
}
DBConnectionPoolMgr.java
package bean.database;
import bean.database.*;
import java.sql.*;
public class DBConnectionPoolMgr {
private static DBConnectionPoolMgr instance=null;
private DBConnectionPool pool=null;
private DBConnectionPoolMgr() throws Exception{
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost/edb";
String id = "root";
String pass = "******";
pool=new DBConnectionPool(url,id,pass);
}
public static synchronized DBConnectionPoolMgr getInstance() throws Exception{
if(instance==null)
instance=new DBConnectionPoolMgr();
return instance;
}
public Connection getConnection() throws Exception{
Connection connection=pool.getConnection();
return connection;
}
public void returnConnection(Connection connection) throws Exception{
pool.returnConnection(connection);
}
public synchronized void close() throws Exception{
pool.close();
}
}
Pool파일 클래스만들고 PoolMgr파일 클래스 만들면 private DBConnectionPool pool=null; 이거 cannot find symbol이래
왜 못찾아 왜 못찾아 왜 못찾는데 ㅜㅜㅜ
도와줘도와줘 헤헤 나 헤헤 아 흐어긍흐어거ㅣ아ㅓ기 도와줘 횽횽
DBConnectionPool.java 맨 위에 package 주석 풀어
저거 풀어도안되ㅜㅜㅜㅜㅜㅜㅜㅜ풀고해봤는데 안되ㅜㅜㅜㅜㅜㅜㅜㅜ
오류화면도올렸어ㅜㅜ
DBConnectionPool 을 public class로 해봐.
이거 안되면 난 모르겠다. 자바 개발자가 아니라서.ㅋㅋ
했는데 안되ㅜㅜㅜ나 뭐 잘못지정한거야?ㅜㅜㅜ소스코드좀 변경했는데 왜 안돼ㅜㅜ
http://javaholic.tistory.com/169
팩키지 쎄우고 public 명시
다 퍼블릭으로 바꾸고 햇는데 패키지 지정을 잘못한거야?ㅜㅜ
형 제발 조금만 고쳐주면안되?ㅜㅜ
... 두 파일 동시에 해야되는거 아님?
동시에? 동시에 어떻게해???
동시에 하는 명령어좀 알려줘 해볼게 흥어이ㅓ기ㅏ억
javac *.java
그거 하나만 하는거자낭..
javac DBConnectionPool.java치고 다음에 javac DBConnectionPoolMgr.java치면 저 오류 뜨는거야ㅜ
그래서 javac *.java가 안 먹혔다는거임?
웅 앞에껀 먹혔는데 뒤에꺼 치니까 저 위에 사진처럼 cannot find symbol이래ㅜㅜ
이거떄매 밤새는데ㅜㅜ 해주면안되ㅜㅜ 제발제발제바루ㅜㅜ
패키지 주석을 풀으셔야지--