程序异常：com.mysql.cj.jdbk.Driver

原创于 2024-10-16 16:01:12 发布 · 194 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #数据库 #eclipse

1.先是改程序异常：com.mysql.jdbk.Driver

2.重新安装mysql

3.发现mysql自带配件

以为胜利就在前方

结果还是报错

重新改代码，发现是表格建错了

不在随便改代码了

<%@ page language="java" contentType="text/html; charset=UTF-8" import="java.util.*,java.sql.*"
    pageEncoding="UTF-8"%>

<%
	String path = request.getContextPath();
	String basePath = request.getScheme()+"://"
			+request.getServerName()+ ":"+request.getServerPort()
			+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//3C//DTD HTML 4.01 Transitional//EN">
<html>
    <head>
    
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>用户登录</title>
		
</head>
<body>
    <%
        String username = request.getParameter("username");
        String password = request.getParameter("password");
    %>
    <%
        String driverName = "com.mysql.jdbc.Driver";
        String url = "jdbc:mysql://localhost:3306/mydb";
        try {
            Class.forName(driverName);
            Connection con = DriverManager.getConnection(url, "root", "123456");
            Statement stmt = con.createStatement();
            ResultSet rs=stmt.executeQuery("select * from userinfo where username='"
            +username+"' and password='"+password+"'");
         
            if(rs.next()){//判断结果
            	response.sendRedirect("suss.jsp");
            	session.setAttribute("username", username);//将name的内容赋值给UserName
            }else{
            	response.sendRedirect("relogin.jsp");
            }
        } catch (Exception e) {
            System.out.println("程序异常："+e.getMessage());
        }
    %>
</body>
</html>