JDBC连接mysql
安装JDBC驱动mysql-connector-java-5.1.43-bin.jar)将JDBC驱动mysql-connector-java-5.1.43-bin.jar文件拷贝到Tomcat安装目录下的lib文件夹中。用JDBC连接数据库。创建jsp文件并加入代码选择jsp文件,右键run as Server安装JDBC驱动mysql-connector-java-5.1.43-bin.jar
/weixin_41831619/article/details/79914307
)将JDBC驱动mysql-connector-java-5.1.43-bin.jar文件拷贝到Tomcat安装目录下的lib文件夹中。用JDBC连接数据库。
创建jsp文件并加入代码
<%@ page language="java" contentType="text/html; charset=UTF-8"pageEncoding="UTF-8"%><%@ page import="java.sql.*"%><html><head><title>通过JSP打开数据表</title></head><body>hello<% try {Class.forName("com.mysql.jdbc.Driver"); // 驱动程序名String url = "jdbc:mysql://localhost:3306/test1"; //数据库名String username = "root"; //数据库用户名String password = "123456"; //数据库用户密码Connection conn = DriverManager.getConnection(url, username, password); //连接状态if(conn != null){out.print("数据库连接成功!"); //out.print("<br />"); //Statement stmt = null; //ResultSet rs = null; //String sql = "SELECT *FROM teacher;"; //查询语句//stmt = conn.createStatement(); //rs = stmt.executeQuery(sql); //out.print("查询结果:"); //out.print("<br />"); //.println("姓名"+" "+"性别 "+" "+"年龄"); //out.print("<br />"); //while (rs.next()) {//out.println(rs.getString("姓名")+"   "+rs.getString("性别")+"   "+rs.getInt("年龄")); //将查询结果输出 //} }else{out.print("连接失败!"); } }catch (Exception e) {out.print("数据库连接异常!"); } %> </body></html>