java连接数据库后连接几次后就无法再连接

public class login_gy extends HttpServlet {

public void doGet(HttpServletRequest request,HttpServletResponse response)

throws ServletException, IOException

{

Statement stmt = null;

try {

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

String url = "jdbc:sqlserver://localhost:1433;databasename=lls";

String user = "sa";

String pass = "sa";

Connection conn = DriverManager.getConnection(url, user,pass);

stmt = con.createStatement();

String sql = "SELECt id,password,goodsname,goodslevel from i_basic_goodsname where loginname='"+log+"'";

ResultSet rs = stmt.executeQuery(sql);

while (rs.next())

{

s_pass=rs.getString("password");

userid=rs.getInt("id");

username=rs.getString("goodsname");

orglevel=rs.getInt("goodslevel");

}

}

catch (Exception e) {

e.printStackTrace();

}

}

}

提示错误Cannot get a connection, pool error Timeout waiting for idle object

数据库连接用完后一定要关闭。增加
if(conn!=null){
conn.close();
}
if(stmt!=null){
stmt.close();
}
最好把这两句话加到 finally 语句中

这两个单引号是包在双引号里的～不是单引号里加个双引号。 你输出一你的sql下就知道了。

你用完数据库都没有关闭，你添加一个conn.close();试试