请问怎么用jsp连接mysql数据库.
1.先装好JDK ex：C:\j2sdk1.4.22.再装TomCat ex：C:\Tomcat 5.03.下载 JDBC 驱动 http://mysql.easynet.be/Downloads/Connector-J/mysql-connector-java-3.1.14.zip 下载就直接解压，里面有一个 mysql-connector-java-3.1.14-bin.jar 文件 在 C:\ 建立一个 mysqlforjdbc 文件夹，将 mysql-connector-java-3.1.14-bin.jar 复制到这个文件夹中. 再将 mysql-connector-java-3.1.14-bin.jar 复制到 C:\j2sdk1.4.2\lib 中 再将 mysql-connector-java-3.1.14-bin.jar 复制到 C:\Tomcat 5.0\common\lib 和 C:\Tomcat 5.0\shared\lib 中4.设置环境变量classpath .;d:\j2sdk\lib\dt.jar;d:\j2sdk\lib\tools.jar;d:\mysqlforjdbc\mysql-connector-java-3.1.14-bin.jar;d:\j2sdk\lib\mysql-connector-java-3.1.14-bin.jar;d:\mysqlforjdbc\msbase.jar;d:\mysqlforjdbc\mssqlserver.jar;d:\mysqlforjdbc\msutil.jar;%CATALINA_HOME%\common\lib\servlet.jarJAVA_HOME d:\j2sdkPath ;%JAVA_HOME%\bin\5.执行代码，输出结果在 C:\Tomcat 5.0\webapps\ROOT 中新建 test_mysql.jsp 测试文件<%@ page contentType="text/html; charset=gb2312" %><%@ page language="java" %><%@ page import="com.mysql.jdbc.Driver" %><%@ page import="java.sql.*" %> <%//驱动程序名String driverName="com.mysql.jdbc.Driver";//数据库用户名String userName="root";//密码String userPasswd="";//数据库名String dbName="ex";//表名String tableName="post";//联结字符串String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd;Class.forName("com.mysql.jdbc.Driver").newInstance();Connection connection=DriverManager.getConnection(url);Statement statement = connection.createStatement();String sql="SELECT * FROM "+tableName;ResultSet rs = statement.executeQuery(sql); //获得数据结果集合ResultSetMetaData rmeta = rs.getMetaData();//确定数据集的列数，亦字段数int numColumns=rmeta.getColumnCount();out.print("id"); out.print("| ");out.print("title");out.print("| ");out.print("comment ");out.print("");while(rs.next()) {out.print(rs.getString(1)); out.print(" | ");out.print(rs.getString(2));out.print(" | "); out.print(rs.getString(3));out.print(""); } out.print("");out.print("数据库操作成功，恭喜你"); rs.close(); statement.close(); connection.close(); %>
标签：jsp,mysql,数据库
