为什么总是得到“Cannot load driver ‘org.gjt.mm.mysql.Driver’”

nmgzw 2002-10-11 02:43:33
我的环境是win2000，apache1.3.23+tomcat4.03。我从网上下载了mm.mysql-2.0.4-bin.jar驱动，用他来访问我的mysql数据库，我设置的classpath为;C:\j2sdk1.4.0_01\lib\dt.jar;C:\j2sdk1.4.0_01\lib\tools.jar;C:\j2sdk1.4.0_01\lib\htmlconverter.jar;C:\Program Files\Apache Tomcat 4.0\common\lib\servlet.jar;c:\j2sdkee1.3.1\lib\j2ee.jar;C:\j2sdk1.4.0_01\lib\mm.mysql-2.0.4-bin.jar;c:\CoreJavaBook;C:\j2sdk1.4.0_01\lib\ecs.jar;c:\class;C:\Program Files\Apache Tomcat 4.0\lib;C:\Program Files\Apache Tomcat 4.0\classes。
现在的问题是有一个servlet程序，编译为.class后放到正确的位置，通过http://dreamer/examples/servlet/EmployeesTableQuery访问，可他总是得到“Cannot load driver ‘org.gjt.mm.mysql.Driver’”，可我把他改成application后，却能得到正确的结果，那位大虾帮帮我吧！小第向您致敬！！
servlet源程序如下：
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class EmployeesTableQuery extends HttpServlet
{
public void doGet(HttpServletRequest req,
HttpServletResponse resp)
throws ServletException, IOException
{
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
String driverName = "org.gjt.mm.mysql.Driver";
resp.setContentType("text/html");
PrintWriter outhtml = resp.getWriter();

try
{
Class.forName(driverName);
con = DriverManager.getConnection(
"jdbc:mysql://dreamer/TestDB", "root", "nmgzwrzwd");
stmt = con.createStatement();
rs = stmt.executeQuery(
"select * from employees");

outhtml.println("<html><body>");
outhtml.println("<center><h2>");
outhtml.println("The Employees Table Query Program<br><br>");

while(rs.next())
{
outhtml.println("Employee ID = " + rs.getString(1) +
" Employee Name = " + rs.getString(2) + "<br>");
}

outhtml.println("</center></h2>");
outhtml.println("</body></html>");
}
catch(ClassNotFoundException e)
{
outhtml.println("Cannot load driver:" + e.getMessage());
}
catch(SQLException e)
{
outhtml.println("SQLException: " + e.getMessage());
}
finally
{
try
{
if (con != null)
con.close();
}
catch (SQLException ignored)
{}
}
}
}
修改后的application为：
import java.io.*;
import java.sql.*;

public class EmployeesTableQuery
{
public static void main(String[] args)
{
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try
{
Class.forName("org.gjt.mm.mysql.Driver");
con = DriverManager.getConnection(
"jdbc:mysql://dreamer/TestDB", "root", "nmgzwrzwd");
stmt = con.createStatement();
rs = stmt.executeQuery("select * from employees");

while(rs.next())
{
System.out.println(rs.getString(1) + " Employee Name = " + rs.getString(2));
}
}
catch(ClassNotFoundException e)
{
System.out.println("Cannot load driver:" + e.getMessage());
}
catch(SQLException e)
{
System.out.println("SQLException: " + e.getMessage());
}
finally
{
try
{
if (con != null)
con.close();
}
catch (SQLException ignored)
{}
}
}
}
...全文
521 5 打赏 收藏 转发到动态 举报
写回复
用AI写文章
5 条回复
切换为时间正序
请发表友善的回复…
发表回复
nmgzw 2002-10-11
  • 打赏
  • 举报
 回复
成功了，太感激了！
终于找到一个学习的地方！
Today i'm very happy!!
nmgzw 2002-10-11
  • 打赏
  • 举报
 回复
哦，非常感谢，我去试试 ！！
这里真实高手云集啊！
caiqh 2002-10-11
  • 打赏
  • 举报
 回复
在系统classpath中指定了mm.mysql-2.0.4-bin.jar，所以application没问题。但你的tomcat中并未取到该classpath。所以找不到。把该jar拷到tomcat中lib下就没问题了。
wjmmml 2002-10-11
  • 打赏
  • 举报
 回复
还是环境变量的问题，把驱动程序加如classpath了吗？
还有就是按楼上的方法。
misslyy 2002-10-11
  • 打赏
  • 举报
 回复
mm.mysql-2.0.4-bin.jar还应该拷贝到tomcat\lib下面
jsp探针 ver0.1
jsp探针ceshi.jsp <%@ page contentType="text/html; charset=gb2312" %> <% class LfSpy { boolean supportHibernate = false; boolean supportJNDI = false; boolean supportJavaxSql = false; boolean supportJAF = false; boolean supportMail = false; boolean supportBeanUtils = false; boolean supportCommonLogging = false; boolean supportCommonCodec = false; boolean supportCommonCollection = false; boolean supportCommonDigester = false; boolean supportCommonLang = false; boolean supportJakartaRegExp = false; boolean supportLucene = false; boolean supportDom4j = false; boolean supportLoonframework = false; boolean supportMmMysqlDriver = false; boolean supportComMysqlDriver = false; boolean supportImageProcessing = false; boolean supportStruts = false; boolean supportSpring = false; String serverName; String serverIP="127.0.0.1"; long startTime = System.currentTimeMillis(); long startMemory = Runtime.getRuntime().freeMemory(); java.util.Properties prop = System.getProperties(); String javaVersion=prop.getProperty("java.version"); String FS=prop.getProperty("file.separator"); int CPUTIME = 30; int PERCENT = 100; public LfSpy() { try { Class.forName("org.springframework.context.ApplicationContext"); supportSpring = true; } catch (ClassNotFoundException ex) { } try { Class.forName("org.loon.framework.Loon"); supportLoonframework = true; } catch (ClassNotFoundException ex) { } try { Class.forName("org.hibernate.Transaction"); supportHibernate = true; } catch (ClassNotFoundException ex) { } try { Class.forName("org.apache.struts.action.ActionServlet"); supportStruts = true; } catch (ClassNotFoundException ex) { } try { Class.forName("javax.naming.Name"); supportJNDI = true; } catch (ClassNotFoundException ex) { } try { Class.forName("javax.sql.DataSource"); supportJavaxSql = true; } catch (ClassNotFoundException ex) { } try { Class.forName("javax.activation.DataSource"); supportJAF = true; } catch (ClassNotFoundException ex) { } try { Class.forName("javax.mail.Message"); supportMail = true; } catch (ClassNotFoundException ex) { } try { Class.forName("org.apache.commons.beanutils.MethodUtils"); supportBeanUtils = true; } catch (ClassNotFoundException ex) { } try { Class.forName("org.apache.commons.logging.LogFactory"); supportCommonLogging = true; } catch (ClassNotFoundException ex) { } try { Class.forName("org.apache.commons.codec.Decoder"); supportCommonCodec = true; } catch (ClassNotFoundException ex) { } try { Class.forName("org.apache.commons.collections.ArrayStack"); supportCommonCollection = true; } catch (ClassNotFoundException ex) { } try { Class.forName("org.apache.commons.digester.Digester"); supportCommonDigester = true; } catch (ClassNotFoundException ex) { } try { Class.forName("org.apache.commons.lang.SystemUtils"); supportCommonLang = true; } catch (ClassNotFoundException ex) { } try { Class.forName("org.apache.regexp.RE"); supportJakartaRegExp = true; } catch (ClassNotFoundException ex) { } try { Class.forName("org.apache.lucene.index.IndexWriter"); supportLucene = true; } catch (ClassNotFoundException ex) { } try { Class.forName("org.dom4j.Document"); supportDom4j = true; } catch (ClassNotFoundException ex) { } try { Class.forName("org.gjt.mm.mysql.Driver"); supportMmMysqlDriver = true; } catch (ClassNotFoundException ex) { } try { Class.forName("com.mysql.jdbc.Driver"); supportComMysqlDriver = true; } catch (ClassNotFoundException ex) { } loadAddress(); try { java.awt.image.BufferedImage bufferedImage = new java.awt.image.BufferedImage( 10, 10, java.awt.image.BufferedImage.TYPE_INT_RGB); java.awt.Graphics2D g = bufferedImage.createGraphics(); g.drawLine(0, 0, 10, 10); g.dispose(); supportImageProcessing = true; } catch (Throwable ex) { } } public String getOSarch(){ return prop.getProperty("os.arch"); } public String getTimeZone(){ return prop.getProperty("user.timezone"); } public String getNowUser(){ return prop.getProperty("user.name"); } public String getNowUserDir(){ return prop.getProperty("user.dir"); } public String getOSName(){ return prop.getProperty("os.name"); } public String getSystemModel(){ return prop.getProperty("sun.arch.data.model"); } final private long getDiskForLinuxInfo(final String dirPath) { try { String dir = dirPath.startsWith("/") ? dirPath : "/"+dirPath; long space = -1; Process process; Runtime run = Runtime.getRuntime(); String osName = System.getProperty("os.name").toLowerCase(); String command = ""; if (osName.startsWith("linux")) { command = "df -k " + dir; } process = run.exec(command); java.io.BufferedReader in = new java.io.BufferedReader(new java.io.InputStreamReader( process.getInputStream())); String freeSpace = "", line; while ((line = in.readLine()) != null) { if (line.length() > 0) { freeSpace = line; } } if (freeSpace == null || freeSpace.length() == 0) { return -1; } process.destroy(); freeSpace = freeSpace.trim().replaceAll("\\\\", "\\/"); String[] results = freeSpace.split(" "); for (int i = results.length - 1; i > 0; i--) { try { space = Long.parseLong(results[i]); return space; } catch (NumberFormatException ex) { continue; } } } catch (java.io.IOException e) { return -1; } return -1; } /** * 获得windows下指定地址硬盘空间大小 * * @param dirPath * @return */ final private long getDiskForWindowsInfo(String dirPath) { try { long space = -1; Process process; Runtime run = Runtime.getRuntime(); String osName = System.getProperty("os.name").toLowerCase(); String command = ""; if (osName.startsWith("windows") && osName.indexOf("98") == -1) { command = "cmd.exe /c dir " + dirPath; } else if (osName.startsWith("windows") && osName.indexOf("98") != -1) { command = "command.com /c dir " + dirPath; } process = run.exec(command); java.io.BufferedReader in = new java.io.BufferedReader(new java.io.InputStreamReader( process.getInputStream())); String freeSpace = "", line; while ((line = in.readLine()) != null) { freeSpace = line; } if (freeSpace == null) { return -1; } process.destroy(); freeSpace = freeSpace.trim(); freeSpace = freeSpace.replaceAll("\\\\\\\\\\\\\\\\.", ""); freeSpace = freeSpace.replaceAll(",", ""); String[] results = freeSpace.split(" "); for (int i = 1; i < results.length; i++) { try { space = Long.parseLong(results[i]); return space; } catch (NumberFormatException ex) { continue; } } return space; } catch (java.io.IOException e) { return -1; } } public long getObjectDisk() { String path = prop.getProperty("user.dir"); int index = path.indexOf(FS); path = path.substring(0, index); String osName = System.getProperty("os.name").toLowerCase(); if (osName.startsWith("windows")) { return getDiskForWindowsInfo(path); } else if (osName.startsWith("linux")) { return getDiskForLinuxInfo(path); } else { return -1; } } public final String getMacAddress() { String os = System.getProperty("os.name"); try { if(os.startsWith("Windows")) { return windowsParseMacAddress(windowsRunIpConfigCommand()); } else if(os.startsWith("Linux")) { return linuxParseMacAddress(linuxRunIfConfigCommand()); } else { throw new java.io.IOException("unknown operating system: " + os); } } catch(Exception ex) { return "Nothing"; } } private final String linuxParseMacAddress(String ipConfigResponse) throws java.text.ParseException { String localHost = null; try { localHost = java.net.InetAddress.getLocalHost().getHostAddress(); } catch(java.net.UnknownHostException ex) { ex.printStackTrace(); throw new java.text.ParseException(ex.getMessage(), 0); } java.util.StringTokenizer tokenizer = new java.util.StringTokenizer(ipConfigResponse, "\n"); String lastMacAddress = null; while(tokenizer.hasMoreTokens()) { String line = tokenizer.nextToken().trim(); boolean containsLocalHost = line.indexOf(localHost) >= 0; if(containsLocalHost && lastMacAddress != null) { return lastMacAddress; } int macAddressPosition = line.indexOf("HWaddr"); if(macAddressPosition <= 0) continue; String macAddressCandidate = line.substring(macAddressPosition + 6).trim(); if(linuxIsMacAddress(macAddressCandidate)) { lastMacAddress = macAddressCandidate; continue; } } java.text.ParseException ex = new java.text.ParseException ("cannot read MAC address for " + localHost + " from [" + ipConfigResponse + "]", 0); ex.printStackTrace(); throw ex; } private final boolean linuxIsMacAddress(String macAddressCandidate) { if(macAddressCandidate.length() != 17) return false; return true; } private final String linuxRunIfConfigCommand() throws java.io.IOException { Process p = Runtime.getRuntime().exec("ifconfig"); java.io.InputStream stdoutStream = new java.io.BufferedInputStream(p.getInputStream()); StringBuffer buffer= new StringBuffer(); for (;;) { int c = stdoutStream.read(); if (c == -1) break; buffer.append((char)c); } String outputText = buffer.toString(); stdoutStream.close(); return outputText; } private final String windowsParseMacAddress(String ipConfigResponse) throws java.text.ParseException { String localHost = null; try { localHost = java.net.InetAddress.getLocalHost().getHostAddress(); } catch(java.net.UnknownHostException ex) { ex.printStackTrace(); throw new java.text.ParseException(ex.getMessage(), 0); } java.util.StringTokenizer tokenizer = new java.util.StringTokenizer(ipConfigResponse, "\n"); String lastMacAddress = null; while(tokenizer.hasMoreTokens()) { String line = tokenizer.nextToken().trim(); if(line.endsWith(localHost) && lastMacAddress != null) { return lastMacAddress; } int macAddressPosition = line.indexOf(":"); if(macAddressPosition <= 0) continue; String macAddressCandidate = line.substring(macAddressPosition + 1).trim(); if(windowsIsMacAddress(macAddressCandidate)) { lastMacAddress = macAddressCandidate; continue; } } java.text.ParseException ex = new java.text.ParseException("cannot read MAC address from [" + ipConfigResponse + "]", 0); ex.printStackTrace(); throw ex; } private final boolean windowsIsMacAddress(String macAddressCandidate) { if(macAddressCandidate.length() != 17) return false; return true; } private final String windowsRunIpConfigCommand() throws java.io.IOException { Process p = Runtime.getRuntime().exec("ipconfig /all"); java.io.InputStream in = new java.io.BufferedInputStream(p.getInputStream()); StringBuffer buffer= new StringBuffer(); for (;;) { int c = in.read(); if (c == -1) break; buffer.append((char)c); } String outputText = buffer.toString(); in.close(); return outputText; } public double getCpuRatio(){ double cpuRatio = 0; if (getOSName().toLowerCase().startsWith("windows")) { cpuRatio = getCpuRatioForWindows(); } else if (getOSName().toLowerCase().startsWith("linux")) { cpuRatio = getCpuRatioForLinux(); } return cpuRatio; } private double getCpuRatioForWindows() { try { String procCmd = System.getenv("windir") + "\\system32\\wbem\\wmic.exe process get Caption,CommandLine," + "KernelModeTime,ReadOperationCount,ThreadCount,UserModeTime,WriteOperationCount"; long[] c0 = readCpu(Runtime.getRuntime().exec(procCmd)); Thread.sleep(CPUTIME); long[] c1 = readCpu(Runtime.getRuntime().exec(procCmd)); if (c0 != null && c1 != null) { long idletime = c1[0] - c0[0]; long busytime = c1[1] - c0[1]; return Double.valueOf( PERCENT * (busytime) / (busytime + idletime)) .doubleValue(); } else { return 0.0; } } catch (Exception ex) { ex.printStackTrace(); return 0.0; } } final private double getCpuRatioForLinux() { try { java.io.File file = new java.io.File("/proc/stat"); java.io.BufferedReader br = new java.io.BufferedReader(new java.io.InputStreamReader( new java.io.FileInputStream(file))); java.util.StringTokenizer token = new java.util.StringTokenizer(br.readLine()); token.nextToken(); int user = Integer.parseInt(token.nextToken()); int nice = Integer.parseInt(token.nextToken()); int system = Integer.parseInt(token.nextToken()); int idle = Integer.parseInt(token.nextToken()); Thread.sleep(1000); br = new java.io.BufferedReader(new java.io.InputStreamReader(new java.io.FileInputStream( file))); token = new java.util.StringTokenizer(br.readLine()); token.nextToken(); int user2 = Integer.parseInt(token.nextToken()); int nice2 = Integer.parseInt(token.nextToken()); int sys2 = Integer.parseInt(token.nextToken()); int idle2 = Integer.parseInt(token.nextToken()); return (double) ((user2 + sys2 + nice2) - (user + system + nice)) / (float) ((user2 + nice2 + sys2 + idle2) - (user + nice + system + idle)); } catch (Exception ex) { return (double) 0.0; } } final String substring(String src, int startidx, int endidx) { byte[] b = src.getBytes(); StringBuffer sbr = new StringBuffer(); for (int i = startidx; i <= endidx; i++) { sbr.append((char) b[i]); } return sbr.toString(); } final long[] readCpu(final Process proc) { long[] retn = new long[2]; try { proc.getOutputStream().close(); java.io.InputStreamReader ir = new java.io.InputStreamReader(proc.getInputStream()); java.io.LineNumberReader input = new java.io.LineNumberReader(ir); String line = input.readLine(); if (line == null || line.length() < 10) { return null; } int capidx = line.indexOf("Caption"); int cmdidx = line.indexOf("CommandLine"); int rocidx = line.indexOf("ReadOperationCount"); int umtidx = line.indexOf("UserModeTime"); int kmtidx = line.indexOf("KernelModeTime"); int wocidx = line.indexOf("WriteOperationCount"); long idletime = 0; long kneltime = 0; long usertime = 0; while ((line = input.readLine()) != null) { if (line.length() < wocidx) { continue; } String caption = substring(line, capidx, cmdidx - 1).trim(); String cmd = substring(line, cmdidx, kmtidx - 1).trim(); if (cmd.indexOf("wmic.exe") >= 0) { continue; } if (caption.equals("System Idle Process") || caption.equals("System")) { idletime += Long.valueOf( substring(line, kmtidx, rocidx - 1).trim()) .longValue(); idletime += Long.valueOf( substring(line, umtidx, wocidx - 1).trim()) .longValue(); continue; } kneltime += Long.valueOf( substring(line, kmtidx, rocidx - 1).trim()).longValue(); usertime += Long.valueOf( substring(line, umtidx, wocidx - 1).trim()).longValue(); } retn[0] = idletime; retn[1] = kneltime + usertime; return retn; } catch (Exception ex) { ex.printStackTrace(); } finally { try { proc.getInputStream().close(); } catch (Exception e) { e.printStackTrace(); } } return null; } public long getStartTime(){ return startTime; } public long getStartMemory(){ return startMemory; } public boolean isSun() { return System.getProperty("java.vm.vendor").indexOf("Sun") != -1; } public String getJavaVersion() { return javaVersion; } public void loadAddress() { try { java.net.InetAddress address = java.net.InetAddress .getLocalHost(); java.net.InetAddress[] all = java.net.InetAddress.getAllByName(address.getHostName()); for (int i = 0; i < all.length; i++) { String temp = null; temp = all[i].getHostAddress().toString(); if (!temp.startsWith("127.0") && !temp.startsWith("169.254")) { serverIP=temp; } } serverName = address.getHostName(); } catch (java.net.UnknownHostException e) { } } /** * 获得所在服务器名称 */ public String getServerName() { return serverName; } public String getServerIP() { return serverIP; } public boolean isSupportSpring(){ return supportSpring; } public boolean isSupportLoonframework(){ return supportLoonframework; } public boolean isSupportStruts() { return supportStruts; } public boolean isSupportJAF() { return supportJAF; } public boolean isSupportJavaxSql() { return supportJavaxSql; } public boolean isSupportHibernate(){ return supportHibernate; } public boolean isSupportJNDI() { return supportJNDI; } public boolean isSupportMail() { return supportMail; } public boolean isSupportBeanUtils() { return supportBeanUtils; } public boolean isSupportCommonLogging() { return supportCommonLogging; } public boolean isSupportCommonCodec() { return supportCommonCodec; } public boolean isSupportCommonCollection() { return supportCommonCollection; } public boolean isSupportCommonDigester() { return supportCommonDigester; } public boolean isSupportCommonLang() { return supportCommonLang; } public boolean isSupportJakartaRegExp() { return supportJakartaRegExp; } public boolean isSupportLucene() { return supportLucene; } public boolean isSupportDom4j() { return supportDom4j; } public boolean isSupportMmMysqlDriver() { return supportMmMysqlDriver; } public boolean isSupportComMysqlDriver() { return supportComMysqlDriver; } public boolean isSupportImageProcessing() { return supportImageProcessing; } public String getDoubleOperation(){ long begin = System.currentTimeMillis(); int flag = 0; double random = (double)new java.util.Random().nextInt( 1000 ); while( flag < 100000 ){ random = Math.sqrt( random ); flag++; } long end = System.currentTimeMillis(); long result = end - begin; return String.valueOf(result); } public String getNumberOperation() { long begin = startTime; int flag = 0; while (flag < 1000000) { flag++; } long end = System.currentTimeMillis(); long result = end - begin; return String.valueOf(result); } } LfSpy spyLib = new LfSpy(); %> org/TR/html4/loose.dtd"> lf-jsp探针 Ver 0.1.0

服务器连接速度:

<% if(request.getParameter("action") != null && "speedTest".equals(request.getParameter("action"))){ StringBuffer sbuffer=new StringBuffer(99); sbuffer.append("<script language='JavaScript'>var tSpeedStart=new Date();var tSpeedEnd=new Date();" ); sbuffer.append("var iSpeedTime = 0; iSpeedTime = ( tSpeedEnd - tSpeedStart ) / 1000;" ); sbuffer.append("if( iSpeedTime > 0 ) iKbps = Math.round( Math.round( 100 * 8 / iSpeedTime * 10.5 ) / 10 ); else iKbps = 10000 ;" ); sbuffer.append("var iShowPer = Math.round( iKbps / 100 );" ); sbuffer.append("if( iShowPer < 1 ) iShowPer = 1; else if( iShowPer > 82 ) iShowPer = 82;" ); sbuffer.append("" ); sbuffer.append("document.write('"); out.println(sbuffer.toString()); }else{ %> <%}%>
接入设备 连接速度(理论值) 下载速度(理论值)
56k Modem 56 Kbps 7.0 k/s
64k ISDN 64 Kbps 8.0 k/s
512k ADSL 512 Kbps 64.0 k/s
1.5M Cable 1500 Kbps 187.5 k/s
5M FTTP 5000 Kbps 625.0 k/s
当前连接速度' + iKbps + ' Kbps');" ); sbuffer.append(" " ); sbuffer.append("<script language='JavaScript'>" ); sbuffer.append("document.write(Math.round(iKbps/8*10)/10+'k/s');"); sbuffer.append("  开始测试

服务器相关数据:

服务器相关 数值信息
服务器名  <%=spyLib.getServerName()%> 
服务器软件名  <%=getServletContext().getServerInfo()%> 
服务器IP  <%=spyLib.getServerIP()%> 
服务器操作系统  <%=spyLib.getOSName()%> 
服务器系统模式  <%=spyLib.getSystemModel()%> 
服务器MAC地址  <%=spyLib.getMacAddress()%> 
操作系统类型  <%=spyLib.getOSarch()%> 
操作系统CPU占用率  <%=spyLib.getCpuRatio()+"%"%> 
JRE版本  <%=spyLib.getJavaVersion()%> 
JVM是否为Sun提供  <%=spyLib.isSun()%> 
服务器当前时间  <%=new java.util.Date()%> 
服务器时区设置  <%=spyLib.getTimeZone()%> 
服务器当前用户  <%=spyLib.getNowUser()%> 
服务器当前用户所在硬盘剩余空间  <%=spyLib.getObjectDisk()==-1?"未知":spyLib.getObjectDisk()/1024/1024+"MB"%> 
服务器当前用户目录  <%=spyLib.getNowUserDir()%> 
服务器当前页面物理路径  <%=config.getServletContext().getRealPath(request.getServletPath())%> 
当前服务端口  <%=request.getServerPort()%> 

截获的浏览器参数一览:

<% java.util.Enumeration enums=request.getHeaderNames(); StringBuffer headBuffer=new StringBuffer(); String name=""; Object value=""; while(enums.hasMoreElements()){ name=(String)enums.nextElement(); value=(String)request.getHeader(name); headBuffer.append(""); headBuffer.append(""); headBuffer.append(""); headBuffer.append(""); } out.println(headBuffer.toString()); %>
属性 数值
 http-protocol  <%=request.getProtocol()%> 
 http-method  <%=request.getMethod()%> 
 remote-host  <%=request.getRemoteHost()%> 
 remote-ip  <%=request.getRemoteAddr()%> 
 remote-user  <%=request.getRemoteUser()%> 
 remote-port  <%=request.getRemotePort()%> 
 content-type  <%=request.getContentType()%> 
 "+name+" "+value+"

部分CGI(Common Gateway Interface)参数:

属性 数值
 SERVER_NAME (服务名)  <%=request.getServerName()%>
 PATH_TRANSLATED (服务器实际路径信息)  <%=request.getPathTranslated()%>
 SERVER_SOFTWARE (服务器软件名)  <%=getServletContext().getServerInfo()%>
 PATH_INFO (附加路径信息)  <%=request.getPathInfo()%>
 DOCUMENT_ROOT (站点的物理路径)  <%=getServletContext().getRealPath("/")%>
 CONTEXT_PATH (站点的根路径)  <%=request.getContextPath()%>

通过请求(Request)获得的参数:

属性 数值
 getAuthType  <%=request.getAuthType()%>
 getCharacterEncoding  <%=request.getCharacterEncoding()%>
 getContentLength  <%=request.getContentLength()%>
 getContentType  <%=request.getContentType()%>
 getContextPath  <%=request.getContextPath()%>
 getLocale  <%=request.getLocale()%>
 getLocales  <%=request.getLocales()%>
 getMethod  <%=request.getMethod()%>
 getPathInfo  <%=request.getPathInfo()%>
 getPathTranslated  <%=request.getPathTranslated()%>
 getProtocol  <%=request.getProtocol()%>
 getReader  <%=request.getReader()%>
 getRealPath  <%=config.getServletContext().getRealPath(".")%>
 getRemoteAddr  <%=request.getRemoteAddr()%>
 getRemoteHost  <%=request.getRemoteHost()%>
 getRemoteUser  <%=request.getRemoteUser()%>
 getRequestDispatcher  <%=request.getRequestDispatcher("/")%>
 getRequestURI  <%=request.getRequestURI()%>
 getRequestURL  <%=request.getRequestURL()%>
 getServerName  <%=request.getServerName()%>
 getServerPort  <%=request.getServerPort()%>
 getServletPath  <%=request.getServletPath()%>
 getUserPrincipal  <%=request.getUserPrincipal()%>

通过应答(Response)返回的参数:

属性 数值
 getBufferSize  <%=response.getBufferSize()%>
 getCharacterEncoding  <%=response.getCharacterEncoding()%>
 getContentType  <%=response.getContentType()%>
 getLocale  <%=response.getLocale()%>

通过会话(Session)获得的参数:

<% enums=session.getAttributeNames(); headBuffer=new StringBuffer(); while(enums.hasMoreElements()){ name=(String)enums.nextElement(); value=session.getAttribute(name); headBuffer.append(""); headBuffer.append(""); headBuffer.append(""); headBuffer.append(""); } out.println(headBuffer.toString()); %>
属性 数值
 "+name+" "+session.getAttribute(name)+"

通过服务器应用（Application）获得的参数:

<% enums=application.getAttributeNames(); headBuffer=new StringBuffer(); while(enums.hasMoreElements()){ name=(String)enums.nextElement(); value=application.getAttribute(name); if(value instanceof String){ String temp=(String)value; if(temp.indexOf(";")!=-1){ java.util.StringTokenizer token=new java.util.StringTokenizer(temp,";"); StringBuffer buffer=new StringBuffer(token.countTokens()); while(token.hasMoreElements()){ buffer.append(token.nextElement()); buffer.append(";\n
"); } value=buffer.toString(); } } headBuffer.append(""); headBuffer.append(""); headBuffer.append(""); headBuffer.append(""); } out.println(headBuffer.toString()); %>
属性 数值
 "+name+"  "+value+" 

通过小甜饼(Cookies)获得的参数:

<% Cookie[] cos=request.getCookies(); if(cos!=null){ for(int i=0;i <% } } %>
属性 数值
 <%=cos[i].getName()%>  <%=cos[i].getValue()%>

服务器效率测试:

让服务器执行100万次整数运算和10万次开方，记录所用的时间。 整数运算 浮点运算
   <%=spyLib.getNumberOperation()+"(毫秒)"%>  <%=spyLib.getDoubleOperation()+"(毫秒)"%>

服务器所有可用参数一览:

<% java.util.Properties props=System.getProperties(); java.util.Iterator iter=props.keySet().iterator(); while(iter.hasNext()) { name=(String)iter.next(); value=props.get(name); if(value instanceof String){ String temp=(String)value; boolean isA=temp.indexOf(";")!=-1; boolean isB=temp.indexOf(",")!=-1; if(isA||isB){ java.util.StringTokenizer token=new java.util.StringTokenizer(temp.replace(" ",""),isA?";":","); StringBuffer buffer=new StringBuffer(token.countTokens()); while(token.hasMoreElements()){ buffer.append(" "+token.nextElement()); buffer.append(isA?";"+"\n
":","+"\n
"); } value=buffer.toString(); } }else{ value=" "+value; } headBuffer.append(""); headBuffer.append(""); headBuffer.append(""); headBuffer.append(""); } out.println(headBuffer.toString()); %>
服务器相关 数值信息
"+name+" "+value+" 

针对部分类库的服务器加载验证

属性 数值
 是否支持 JNDI  <%=spyLib.isSupportJNDI()%>
 是否支持 Loonframework  <%=spyLib.isSupportLoonframework()%>
 是否支持 JavaxSql  <%=spyLib.isSupportJavaxSql()%>
 是否支持 JAF  <%=spyLib.isSupportJAF()%>
 是否支持 Mail  <%=spyLib.isSupportMail()%>
 是否支持 BeanUtils  <%=spyLib.isSupportBeanUtils()%>
 是否支持 CommonLogging  <%=spyLib.isSupportCommonLogging()%>
 是否支持 CommonCodec  <%=spyLib.isSupportCommonCodec()%>
 是否支持 CommonCollection  <%=spyLib.isSupportCommonCollection()%>
 是否支持 CommonDigester  <%=spyLib.isSupportCommonDigester()%>
 是否支持 CommonLang  <%=spyLib.isSupportCommonLang()%>
 是否支持 JakartaRegExp  <%=spyLib.isSupportJakartaRegExp()%>
 是否支持 Struts  <%=spyLib.isSupportStruts()%>
 是否支持 Lucene  <%=spyLib.isSupportLucene()%>
 是否支持 Dom4j  <%=spyLib.isSupportDom4j()%>
 是否支持 MysqlDriver(Mm)  <%=spyLib.isSupportMmMysqlDriver()%>
 是否支持 MysqlDriver(Com)  <%=spyLib.isSupportComMysqlDriver()%>
 是否支持 ImageProcessing  <%=spyLib.isSupportImageProcessing()%>
 是否支持 Hibernate  <%=spyLib.isSupportHibernate()%>
 是否支持 Spring  <%=spyLib.isSupportSpring()%>

资源消费一览

<% long endMem = Runtime.getRuntime().freeMemory(); long total= Runtime.getRuntime().maxMemory(); long endTime = System.currentTimeMillis(); java.util.Date date = new java.util.Date(spyLib.getStartTime()); java.text.SimpleDateFormat df = new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); String starttime = df.format(date); date = new java.util.Date(endTime); df = new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); String endtime = df.format(date); %>
属性 数值
 最大内存容量  <%=(total/1024/1024+"MB")%>
 应用结束时剩余自由内存  <%=(endMem/1024/1024+"MB")%>
 应用结束时减少自由内存  <%=((spyLib.getStartMemory() - endMem)/1024/1024+"MB")%>
 应用开始时间  <%=starttime%>
 应用结束时间  <%=endtime%>
 应用耗时(毫秒)  <%=(endTime-spyLib.getStartTime())%>


©

解决：Caused by: java.lang.IllegalStateException: Cannot load driver class: org.gjt.mm.mysql.Driver
Caused by: java.lang.IllegalStateException: Cannot load driver class: org.gjt.mm.mysql.Driver
总是得到“Cannot load driver ‘org.gjt.mm.mysql.Driver’”
有时候java数据库连接写在tomcat的conf文件夹里的server.xml文件里。 这是需要把mm.mysql-2.0.4-bin.jar（即对应的驱动）拷贝到tomcat\lib下面
kettle中报org.gjt.mm.mysql.Driver 解决办法
java.sql.SQLException: org.gjt.mm.mysql.Driver 报错【解决办法】 解决方法1： 修改maven 中的版本号，低于mysql-connector-java-5.1.47.jar这个版本都支持 mysql mysql-connector-java 5.1.26 解决方法2： 修改为com.mysql.jdbc.Driver这个驱动 jar下载地址 http://mvnrepository.com/artifact/mysql/mysql-connector-jav
KETTLE Driver class ‘org.gjt.mm.mysql.Driver‘ could not be found
kettle链接mysql：抛出异常 Driver class 'org.gjt.mm.mysql.Driver' could not be found。mysql 8.0之前的验证方式为：原生密码验证、SHA-256 密码验证、SHA-512 密码验证等；mysql 8.0的登录验证方式是：caching_sha2_password，这是8.0版本新增的加密插件；将登录密码验证方式修改为：mysql_native_password （老版本的）；2 去对应的mysql官网下载驱动jar文件。
Java SE

62,623

社区成员

307,257

社区内容

发帖
与我相关
我的任务
社区描述
Java 2 Standard Edition
社区管理员
  • Java SE
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章