MyEclipse------如何连接MySQL

testconnection.jsp
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>

<%

    String path = request.getContextPath();

    String basePath = request.getScheme() + "://"

            + request.getServerName() + ":" + request.getServerPort()

            + path + "/";

%>

<%@ page import="java.sql.*" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<base href="<%=basePath%>">

<title>My JSP 'testconnection.jsp' starting page</title>

</head>

<body>

    <%

        //student为数据库名字，加上useSSL=true不然报错

        //localhost:3360在MySQL GUI tools里面的MySQLAdministrator.exe里面设置

        String url="jdbc:mysql://localhost:3306/student?useSSL=true";

        String useName="root";

        String password="2277092";

        Connection conn=null;

        try{

            Class.forName("com.mysql.jdbc.Driver");

        }

        catch(ClassNotFoundException e){

            out.print("加载驱动器类出现异常");

        }

        try{

            conn=null;

            conn=DriverManager.getConnection(url,useName,password);

        }

        catch(SQLException e){

            out.print("连接数据库的过程中出现SQL异常");

        }

        if(conn==null){

            out.print("连接数据库失败");

        }

        else{

            out.print("连接数据库成功");

        }

        try{

            conn.close();

        }

        catch(SQLException e){

            out.print("关闭数据库连接时出现SQL异常");

        }

     %>

</body>

</html>
秒客网

MyEclipse------如何连接MySQL

相关文章
