当然了
或用 mysql.users 引用
use mysql
http://mysql.hklpg.org/Downloads/Win32/mysqlfront.zip 558K
http://mysql.gremlins.com.hk/Downloads/Win32/netadmin.zip 505K
或用 mysql.users 引用
use mysql
http://mysql.hklpg.org/Downloads/Win32/mysqlfront.zip 558K
http://mysql.gremlins.com.hk/Downloads/Win32/netadmin.zip 505K
use mysql;
select * from user;
mysql数据库时要用什么客户端程序.
并且在win2000的环境变量及系统量中加入了
classpath=e:\jdk1.3\lib\tools.jar;e:\jdk1.3\lib\dt.jar;e:\jdk1.3\lib\mysql-connector-java-2.0.14-bin.jar但是运行如下mysql数据连接测试程序时是出现以下错误
org.apache.jasper.JasperException: Unable to compile class for JSPNote: sun.tools.javac.Main has been deprecated.
C:\jakarta-tomcat\work\www.er.com_8080\_0002ftest_0002ejsptest_jsp_0.java:66: Ambiguous class: java.beans.Statement and java.sql.Statement
Statement stmt = con.createStatement(); 我的程序如下:
<%@ page import="java.sql.*"%>
<%@ page contentType="text/html;charset=gb2312"%>
<%
Class.forName ("org.gjt.mm.mysql.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://192.168.0.100:3306/lb?user=abc;password=abc");
Statement stmt = con.createStatement();
String query="SELECT * FROM user";
ResultSet rs = stmt.executeQuery(query);
while (rs.next()) {
String s1 = rs.getString(1);
String s2 = rs.getString(2);
String s3 = rs.getString(3);
out.println(s1+"--"+s2+"--"+s3+" <A href='DELETE.jsp?userId="+s1+"'>删除</a><br>");
}
stmt.close();
con.close(); %>
请高手指点