会员可以在此提问,百战程序员老师有问必答
对大家有帮助的问答会被标记为“推荐”
看完课程过来浏览一下别人提的问题,会帮你学得更全面
截止目前,同学们一共提了 133322个问题
WEB前端全系列/第六阶段:音乐社区高级项目模块/移动端:基于jQuery使用Ajax和BootStrap 25037楼
Python 全系列/第一阶段:Python入门/Python入门(动画版) 25038楼

package com.bjsxt;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ResourceBundle;

/*
* jdbc工具类
* */
public class JdbcUtil {
    private static String driver;
    private static String jdbcUrl;
    private static String username;
    private static String userpassword;
    static {
        //读取properties文件
        ResourceBundle bundle = ResourceBundle.getBundle("jdbc");
        driver = bundle.getString("driver");
        jdbcUrl = bundle.getString("jdbcUrl");
        username = bundle.getString("username");
        userpassword = bundle.getString("userpassword");
        try {
            Class.forName(driver);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }
    //获取Connection对象
    public static Connection getConnection(){
        Connection conn = null;
        try {
            conn = DriverManager.getConnection(jdbcUrl,username,userpassword);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return conn;
    }
    //关闭statement
    public static void closeStatement(Statement state){
        if (state != null){
            try {
                state.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
    //关闭Connection
    public static void closeConnection(Connection conn){
        if (conn != null){
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
    //关闭资源
    public static void closeResource(Statement state ,Connection conn){
        closeStatement(state);
        closeConnection(conn);
    }
}[object Object]

image.png

image.png

这个问题实在找不到为什么?看不出来哪里报错??????



JAVA 全系列/第四阶段:数据库与AI协同技术实战/JDBC技术(旧) 25039楼

我之前卸载了数据库 按照教程做滴 之后又安装了 和这个有关吗?在学mybatis做项目mybatisdemo时 就有这个报警,其他的就没有了

at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)

 at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:612)

 at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:862)

 at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:917)

 at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:927)

 at com.bjsxt.dao.impl.UsersDaoImpl.insertDesigns(UsersDaoImpl.java:28)

 at com.bjsxt.service.impl.UsersServiceImpl.addUsers(UsersServiceImpl.java:25)

 at com.bjsxt.test.AddUsersTest.main(AddUsersTest.java:17)

Caused by: java.sql.SQLException: Access denied for user 'root '@'localhost' (using password: YES)

 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)

 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933)

 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869)

 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:864)

 at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1707)

 at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1217)

 at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2189)

 at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2220)

 at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2015)

 at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:768)

 at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)

 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

 at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

 at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)

 at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:385)

 at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:323)

 at java.sql.DriverManager.g

辛苦老师帮忙看一下啦

JAVA 全系列/第六阶段:项目管理与SSM框架/Spring 25040楼
Python 全系列/第七阶段:网页编程基础/Ajax 25041楼
JAVA 全系列/第二阶段:JAVA 基础深化和提高/智能电话本项目实战 25042楼
JAVA 全系列/第六阶段:项目管理与SSM框架/Mybatis 25043楼

<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <title>小米商城 - 小米11、Redmi Note 9、小米MIX Alpha,小米电视官方网站</title>
    <link rel="icon" href="images/favicon.ico">
    <link rel="stylesheet" href="iconfont.css">
    <link rel="stylesheet" href="index.xiaomi.style.css">
</head>
<body>
    <!-- 头部开始 -->
    <div>
        <a href="#">
            <img src="images/bb3c06a430689ba2357dd7d1fbfa6bab.jpg" alt="广告">
        </a>
    </div>
    <!-- 头部结束 -->
    <!-- 黑色导航开始 -->
    <div>
        <div>
            <ul>
                <li>
                    <a href="#">小米商城</a>
                    <span>|</span>
                </li>
                <li>
                    <a href="#">MIUI</a>
                    <span>|</span>
                </li>
                <li>
                    <a href="#">loT</a>
                    <span>|</span>
                </li>
                <li>
                    <a href="#">云服务</a>
                    <span>|</span>
                </li>
                <li>
                    <a href="#">天星科技</a>
                    <span>|</span>
                </li>
                <li>
                    <a href="#">有品</a>
                    <span>|</span>
                </li>
                <li>
                    <a href="#">小爱开放平台</a>
                    <span>|</span>
                </li>
                <li>
                    <a href="#">企业团购</a>
                    <span>|</span>
                </li>
                <li>
                    <a href="#">资质证照</a>
                    <span>|</span>
                </li>
                <li>
                    <a href="#">协议规则</a>
                    <span>|</span>
                </li>
                <li>
                    <a href="#">下载app</a>
                    <span>|</span>
                    <div>
                        <img src="images/download.png" alt="">
                        <p>小米商城APP</p>
                    </div>
                    <div></div>
                </li>
                <li>
                    <a href="#">智能生活</a>
                    <span>|</span>
                </li>
                <li>
                    <a href="#">Select Location</a>
                    <span>|</span>
                </li>
            </ul>
            <ul>
                <li>
                    <a href="#">登录</a>
                    <span>|</span>
                </li>
                <li>
                    <a href="#">注册</a>
                    <span>|</span>
                </li>
                <li>
                    <a href="#">消息通知</a>
                </li>
                <li>
                    <a href="#">购物车(0)</a>
                    <div>
                        购物车中还没有商品,赶紧选购吧!
                    </div>
                </li>
            </ul>
        </div>
    </div>
    <!-- 黑色导航结束 -->

    <!-- 白色导航开始 -->
    <div>
        <div>
            <div>
                <img src="images/mi-logo.png" alt="">
                <img src="images/mi-home.png" alt="">
            </div>
            <div>
                <ul>
                    <div></div>
                    <li>
                        <a href="">小米手机</a>
                        <div>
                            <div>
                                <ul>
                                    <li>
                                        <a href="#">
                                            <div>
                                                <img src="images/963679eaf3937351e154600ab3448460.png" alt="">
                                                <p>小米11</p>
                                                <p>3999元起</p>
                                            </div>
                                        </a>
                                    </li>
                                    <li>
                                        <a href="#">
                                            <div>
                                                <img src="images/963679eaf3937351e154600ab3448460.png" alt="">
                                                <p>小米11</p>
                                                <p>3999元起</p>
                                            </div>
                                        </a>
                                    </li>
                                    <li>
                                        <a href="#">
                                            <div>
                                                <img src="images/963679eaf3937351e154600ab3448460.png" alt="">
                                                <p>小米11</p>
                                                <p>3999元起</p>
                                            </div>
                                        </a>
                                    </li>
                                    <li>
                                        <a href="#">
                                            <div>
                                                <img src="images/963679eaf3937351e154600ab3448460.png" alt="">
                                                <p>小米11</p>
                                                <p>3999元起</p>
                                            </div>
                                        </a>
                                    </li>
                                    <li>
                                        <a href="#">
                                            <div>
                                                <img src="images/963679eaf3937351e154600ab3448460.png" alt="">
                                                <p>小米11</p>
                                                <p>3999元起</p>
                                            </div>
                                        </a>
                                    </li>
                                </ul>
                            </div>
                        </div>
                    </li>
                    <li>
                        <a href="">Redmi红米</a>
                    </li>
                    <li>
                        <a href="">电视</a>
                    </li>
                    <li>
                        <a href="">笔记本</a>
                    </li>
                    <li>
                        <a href="">家电</a>
                    </li>
                    <li>
                        <a href="">路由器</a>
                    </li>
                    <li>
                        <a href="">智能硬件</a>
                    </li>
                    <li>
                        <a href="">服务</a>
                    </li>
                    <li>
                        <a href="">社区</a>
                    </li>
                </ul>
            </div>
            <div>
                <input type="text" placeholder="赢手机,分一亿!">
                <button>&#xe63d;</button>
                <div></div>
            </div>
        </div>
    </div>
    <!-- 白色导航结束 -->
    <!-- banner部分开始 -->
    <div>
        <div>
            <img src="images/01d048d6ca5fea696b60c0431e24fbf3.jpg" alt="">
            <div>
                <ul>
                    <li>
                        <a href="#">手机 电话卡</a>
                        <i>&#xe50c;</i>
                        <div>
                            <ul>
                                <li>
                                    <a href="#">
                                        <img src="images/a51c1afa4db8e47e62fad1f6fa4a8970.png" alt="">
                                        <span>小米11</span>
                                    </a>
                                </li>
                                <li>
                                    <a href="#">
                                        <img src="images/a51c1afa4db8e47e62fad1f6fa4a8970.png" alt="">
                                        <span>小米11</span>
                                    </a>
                                </li>
                                <li>
                                    <a href="#">
                                        <img src="images/a51c1afa4db8e47e62fad1f6fa4a8970.png" alt="">
                                        <span>小米11</span>
                                    </a>
                                </li>
                                <li>
                                    <a href="#">
                                        <img src="images/a51c1afa4db8e47e62fad1f6fa4a8970.png" alt="">
                                        <span>小米11</span>
                                    </a>
                                </li>
                                <li>
                                    <a href="#">
                                        <img src="images/a51c1afa4db8e47e62fad1f6fa4a8970.png" alt="">
                                        <span>小米11</span>
                                    </a>
                                </li>
                                <li>
                                    <a href="#">
                                        <img src="images/a51c1afa4db8e47e62fad1f6fa4a8970.png" alt="">
                                        <span>小米11</span>
                                    </a>
                                </li>
                            </ul>
                            <ul>
                                <li>
                                    <a href="#">
                                        <img src="images/a51c1afa4db8e47e62fad1f6fa4a8970.png" alt="">
                                        <span>小米11</span>
                                    </a>
                                </li>
                                <li>
                                    <a href="#">
                                        <img src="images/a51c1afa4db8e47e62fad1f6fa4a8970.png" alt="">
                                        <span>小米11</span>
                                    </a>
                                </li>
                                <li>
                                    <a href="#">
                                        <img src="images/a51c1afa4db8e47e62fad1f6fa4a8970.png" alt="">
                                        <span>小米11</span>
                                    </a>
                                </li>
                                <li>
                                    <a href="#">
                                        <img src="images/a51c1afa4db8e47e62fad1f6fa4a8970.png" alt="">
                                        <span>小米11</span>
                                    </a>
                                </li>
                                <li>
                                    <a href="#">
                                        <img src="images/a51c1afa4db8e47e62fad1f6fa4a8970.png" alt="">
                                        <span>小米11</span>
                                    </a>
                                </li>
                                <li>
                                    <a href="#">
                                        <img src="images/a51c1afa4db8e47e62fad1f6fa4a8970.png" alt="">
                                        <span>小米11</span>
                                    </a>
                                </li>
                            </ul>
                            <ul>
                                <li>
                                    <a href="#">
                                        <img src="images/a51c1afa4db8e47e62fad1f6fa4a8970.png" alt="">
                                        <span>小米11</span>
                                    </a>
                                </li>
                                <li>
                                    <a href="#">
                                        <img src="images/a51c1afa4db8e47e62fad1f6fa4a8970.png" alt="">
                                        <span>小米11</span>
                                    </a>
                                </li>
                                <li>
                                    <a href="#">
                                        <img src="images/a51c1afa4db8e47e62fad1f6fa4a8970.png" alt="">
                                        <span>小米11</span>
                                    </a>
                                </li>
                                <li>
                                    <a href="#">
                                        <img src="images/a51c1afa4db8e47e62fad1f6fa4a8970.png" alt="">
                                        <span>小米11</span>
                                    </a>
                                </li>
                                <li>
                                    <a href="#">
                                        <img src="images/a51c1afa4db8e47e62fad1f6fa4a8970.png" alt="">
                                        <span>小米11</span>
                                    </a>
                                </li>
                                <li>
                                    <a href="#">
                                        <img src="images/a51c1afa4db8e47e62fad1f6fa4a8970.png" alt="">
                                        <span>小米11</span>
                                    </a>
                                </li>
                            </ul>
                            <ul>
                                <li>
                                    <a href="#">
                                        <img src="images/a51c1afa4db8e47e62fad1f6fa4a8970.png" alt="">
                                        <span>小米11</span>
                                    </a>
                                </li>
                                <li>
                                    <a href="#">
                                        <img src="images/a51c1afa4db8e47e62fad1f6fa4a8970.png" alt="">
                                        <span>小米11</span>
                                    </a>
                                </li>
                                <li>
                                    <a href="#">
                                        <img src="images/a51c1afa4db8e47e62fad1f6fa4a8970.png" alt="">
                                        <span>小米11</span>
                                    </a>
                                </li>
                                <li>
                                    <a href="#">
                                        <img src="images/a51c1afa4db8e47e62fad1f6fa4a8970.png" alt="">
                                        <span>小米11</span>
                                    </a>
                                </li>
                                <li>
                                    <a href="#">
                                        <img src="images/a51c1afa4db8e47e62fad1f6fa4a8970.png" alt="">
                                        <span>小米11</span>
                                    </a>
                                </li>
                                <li>
                                    <a href="#">
                                        <img src="images/a51c1afa4db8e47e62fad1f6fa4a8970.png" alt="">
                                        <span>小米11</span>
                                    </a>
                                </li>
                            </ul>
                        </div>
                    </li>
                    <li>
                        <a href="#">手机 电话卡</a>
                        <i>&#xe50c;</i>
                    </li>
                    <li>
                        <a href="#">手机 电话卡</a>
                        <i>&#xe50c;</i>
                    </li>
                    <li>
                        <a href="#">手机 电话卡</a>
                        <i>&#xe50c;</i>
                    </li>
                    <li>
                        <a href="#">手机 电话卡</a>
                        <i>&#xe50c;</i>
                    </li>
                    <li>
                        <a href="#">手机 电话卡</a>
                        <i>&#xe50c;</i>
                    </li>
                    <li>
                        <a href="#">手机 电话卡</a>
                        <i>&#xe50c;</i>
                    </li>
                    <li>
                        <a href="#">手机 电话卡</a>
                        <i>&#xe50c;</i>
                    </li>
                    <li>
                        <a href="#">手机 电话卡</a>
                        <i>&#xe50c;</i>
                    </li>
                    <li>
                        <a href="#">手机 电话卡</a>
                        <i>&#xe50c;</i>
                    </li>
                </ul>
            </div>
        </div>
    </div>
    <!-- banner部分结束 -->
</body>
</html>
*{
    margin: 0;
    padding: 0;
}
a{
    text-decoration: none;
}
li{
    list-style-type: none;
}

/*头部样式开始*/
.header{
    width: 100%px;
    height: 120px;
    /*background-color: red;*/
    margin: 0 auto;
    position: relative;
    overflow: hidden;
}
.header img{
    height: 100%;
    position: absolute;
    left: 50%;
    transform: translateX(-50%);
}
/*头部样式结束*/


/*黑色导航样式开始*/
.black-nav{
    width: 100%;
    height: 40px;
    line-height: 40px;
    background-color: #333;
    color: #b0b0b0;
    font-size: 12px;
}
.wrap{
    width: 1226px;
    margin: 0 auto;
}
.black-nav-left{
    float: left;
}
.black-nav-right{
    float: right;
}
.black-nav li{
    float: left;
    position: relative;
}
.black-nav a{
    color:#b0b0b0;
}
.black-nav a:hover{
    color: #fff;
}
.black-nav span{
    color: #424242;
    margin: 0 3.6px;
}
.cart{
    width: 120px;
    height: 40px;
    background-color: #424242;
    text-align: center;
    margin-left: 25px;
    transition: all .2s;
    position: relative;
}
.cart:hover{
    background-color: #fff;
}
.cart:hover>a{
    color: #ff6700;
}
.cart-list{
    width: 316px;
    height: 0;
    background-color: #fff;
    box-shadow: 0 2px 10px rgba(0,0,0,.15);
    position: absolute;
    right: 0;
    top: 40px;
    color: #424242;
    line-height: 100px;
    overflow: hidden;/*隐藏溢出的文字*/
    transition: all .3s;
    z-index: 999;
}
.cart:hover>.cart-list{
    height: 100px;
}
/*下载app*/
.download{
    width: 124px;
    height: 0;
    background-color: #fff;
    box-shadow: 0 1px 5px #aaa;
    position: absolute;
    top: 40px;
    left: 50%;
    margin-left: -62px;
    transition: all .3s;
    overflow: hidden;
    z-index: 999;
}
.download>img{
    width: 90px;
    margin: 18px 17px -5px;
}
.download>p{
    color: #333;
    font-size: 14px;
    line-height: 14px;
    text-align: center;
}
.black-nav-left>li:hover>.download{
    height: 148px;
}
.stri{
    width: 0;
    height: 0;
    border-bottom: 8px solid #fff;
    border-left: 8px solid transparent;
    border-right: 8px solid transparent;
    position: absolute;
    bottom: 0;
    left: 50%;
    margin-left: -8px;
    display: none;
}
.black-nav-left>li:hover>.stri{
    display: block;
}
/*黑色导航样式结束*/

/*白色导航样式开始*/
.white-nav{
    width: 100%;
    height: 100px;
    /*background-color: skyblue;*/
    position: relative;
}
.logo{
    width: 55px;
    height: 55px;
    background-color: #ff6700;
    float: left;
    margin-top: 22.5px;
    position: relative;
    overflow: hidden;
}
.nav-bar{
    width: 875px;
    height: 100px;
    line-height: 100px;
    /*background-color: pink;*/
    float: left;
}
.search{
    width: 296px;
    height: 100px;
    /*background-color: purple;*/
    float: left;
    position: relative;
}
.logo>img{
    width: 100%;
    height: 100%;
    position: absolute;
    top: 0;
    transition: all .2s;
}
.mi-home{
    left: -55px;
}
.mi-logo{
    left: 1px;
}
.logo:hover>.mi-home{
    left: 1px;
}
.logo:hover>.mi-logo{
    left: 55px;
}
.nav-bar li{
    float: left;
}
/*白色导航空白*/
.nav-bar .blank{
    width: 200px;
    height: 100px;
    /*background-color: red;*/
    float: left;
}
.nav-bar>ul>li>a{
    font-size: 16px;
    color: #333;
    padding: 0 10px;
}
.nav-bar>ul>li>a:hover{
    color: #ff6700;
}
.nav-bar-list{
    width: 100%;
    height: 229px;
    background-color: #fff;
    border-top: 1px solid #eee;
    box-shadow: 0 3px 4px rgba(0,0,0,.1);
    position: absolute;
    top: 100px;
    left: 0;
    display: none;
    z-index: 999;
}
.img-box{
    width: 100%;
    height: 110px;
    margin-top: 25px;
    border-right: 2px solid #eee;
    box-sizing: border-box;
    text-align: center;
}
.name1{
    color: #333;
    font-size: 12px;
    line-height: 20px;
    margin-top: -35px;
}
.price{
    color: #ff6700;
    font-size: 12px;
    line-height: 20px;
}
.nav-bar-list li{
    width: 204px;
}
.nav-bar-list li:last-child .img-box{
    border-right: none;
}
.nav-bar li:hover .nav-bar-list{
    display: block;
}
.search>input{
    width: 244px;
    height: 50px;
    /*background-color: red;*/
    border: 1px solid #e0e0e0;
    box-sizing: border-box;
    padding: 0 10px;
    outline: none;
    float: left;
    border-right: none;
    margin-top: 25px;
    transition: all .2s;
}
.search>button{
    width: 52px;
    height: 50px;
    background-color: #fff;
    border: 1px solid #e0e0e0;
    float: left;
    margin-top: 25px;
    outline: none;
    transition: all .2s;
}
.search>input:hover,.search>input:hover+button{
    border-color: #b0b0b0;
}
.search>input:focus,.search>input:focus+button{
    border-color: #ff6700;
}
.search>button:hover{
    background-color: #ff6700;
    border-color: #ff6700;
    color: #fff;
}
.search-list{
    width: 245px;
    height: 241px;
    background-color: #fff;
    border: 1px solid #ff6700;
    border-top: none;
    box-sizing: border-box;
    position: absolute;
    left: 0;
    top: 75px;
    display: none;
}
.search>input:focus~.search-list{
    display: block;
}
/*白色导航样式结束*/


/*banner部分样式开始*/
.banner{
    width: 100%;
    height: 460px;    
}
.banner .banner-img{
    width: 100%;
}
.banner>.wrap{
    position: relative;
}
.slide{
    width: 234px;
    height: 420px;
    padding: 20px 0;
    background-color: rgba(105,101,101,.6);
    position: absolute;
    left: 0;
    top: 0;
}
.slide>ul>li{
    height: 42px;
    line-height: 42px;
    text-align: left;
    padding-left: 30px;
    font-size: 14px;
}
.slide>ul>li:hover{
    background-color: #ff6700;
}
.slide>ul>li>a{
    color: #fff;
}
.slide i{
    float: right;
    padding-right: 20px;
    color: #fff;
}
.slide-list{
    width: 992px;
    height: 460px;
    background-color: #fff;
    border: 1px solid #e0e0e0;
    border-left: none;
    box-shadow: 0 8px 16px rgba(0,0,0,.18);
    padding-top: 2px;
    position: absolute;
    top: 0;
    left: 234px;
    display: none;
}
.slide-list>ul{
    float: left;
    width: 247.75px;
}
.slide-list li{
    width: 100%;
    height: 76px;
    padding: 18px 0 18px 20px;
    box-sizing: border-box;
}
.slide-list img{
    margin-right: 10px;
    width: 40px;
    height: 40px;
}
.slide-list span{
    color: #333;
    font-size: 14px;
    white-space: nowrap;
    overflow: hidden;
    text-overflow: ellipsis;
    position: relative;
    top: -14px;
}
.slide-list li:hover span{
    color: #ff6700;
}
.slide li:hover .slide-list{
    display: block;
}
/*banner部分样式结束*/

图片.png


老师好,我这个小米手机的下拉框加过渡怎么也加不上是咋回事呀

WEB前端全系列/第一阶段:HTML5+CSS3模块/CSS3新特性 25047楼

package com.bjsxt;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class JdbcText {
    //向Departments表中添加一条数据
    public void insertDepartments(String department_name,int location_id){
            Connection conn = null;
            Statement state =null;
        try {
            //驱动的注册
            Class.forName("com.mysql.jdbc.Driver");
            //创建链接
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/bjsxt?useUnicode=true&characterEncoding=utf-8","root","root");
            String sql = "insert into departments values(default,'"+department_name+"',"+location_id+")";
            state = conn.createStatement();
            int flag = state.executeUpdate(sql);
            System.out.println(flag);

        } catch (Exception e) {
            e.printStackTrace();
        }finally {
            if (state != null){
                try {
                    state.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            if (conn != null){
                try {
                    conn.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }

        }
    }
    //更新departments表中的department_id为6的数据,将部门名称修改为教学部,location_id修改为6
    public  void updateDepartments(String department_name,int location_id,int department_id){
        Connection conn = null;
        Statement state = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/bjsxt?useUnicode=true&characterEncoding=utf-8","root","root");
            state = conn.createStatement();
            String sql = "update dapartments d set d.department_name = '"+department_name+"',d.location_id = "+location_id+" where d.department_id ="+department_id;
            int flag = state.executeUpdate(sql);
            System.out.println(flag);
        }catch (Exception e){
            e.printStackTrace();
        }finally {
            if (state != null){
                try {
                    state.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            if (conn != null){
                try {
                    conn.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        }
    }
    public static void main(String[] args) {
        JdbcText test = new JdbcText();
       // test.insertDepartments("研发部",8);
        test.updateDepartments("教学部",6,6);
    }
}

老师,我在执行的时候一直报错52行,找了很久实在找不出原因,麻烦帮我看下

image.png

JAVA 全系列/第四阶段:数据库与AI协同技术实战/JDBC技术(旧) 25049楼
JAVA 全系列/(隐藏)第二十三阶段:数字货币交易所项目/服务中台_财务系统的开发 25050楼

课程分类

百战程序员微信公众号

百战程序员微信小程序

©2014-2025百战汇智(北京)科技有限公司 All Rights Reserved 北京亦庄经济开发区科创十四街 赛蒂国际工业园
网站维护:百战汇智(北京)科技有限公司
京公网安备 11011402011233号    京ICP备18060230号-3    营业执照    经营许可证:京B2-20212637