课程
/后端开发
/Java
/JDBC之 “ 对岸的女孩看过来”
运行没有错误，但MySQL中全是null
2017-08-20
源自：JDBC之 “ 对岸的女孩看过来” 2-4
正在回答
数据表user(除了id其它字段可为null)：
-- 正确语句(运行成功，表有数据) insert into user(id,name,age) value(1,'jack',18); -- 错误语句(运行成功，表数据为 null) insert into user value(id=1,name='jack',age=18); insert into user(id,name,age) value(id=1,name='jack',age=18);
看看你是不是用了这样的语句
谢谢支持，多多关注相关课程。
http://house.china.com.cn/sousou/%25101%253D%252C%2520%25%44%30%25%41%31%25%43%33%25%43%44%25%43%30%25%41%44%25%44%33%25%45%39%25%43%30%25%44%36%25%42%39%25%44%39%25%43%44%25%46%38%25%35%38%25%35%33%25%33%36%25%33%38%25%33%36%25%41%33%25%41%45%25%41%33%25%43%33%25%41%33%25%43%46%25%41%33%25%43%44%252C%25%44%31%25%45%46%25%44%36%25%44%44%25%43%39%25%45%37%25%42%31%25%41%33_1s.htmhttp://house.china.com.cn/sousou/%25101%253D%252C%2520%25%43%33%25%45%35%25%42%35%25%45%39%25%42%44%25%46%35%25%43%30%25%46%42%25%42%39%25%46%41%25%42%43%25%43%41%25%43%44%25%46%38%25%43%44%25%42%36%25%42%32%25%42%46%25%44%36%25%42%31%25%44%33%25%41%41%25%43%44%25%46%38%25%34%32%25%33%32%25%33%30%25%33%32%25%33%34%25%32%45%25%34%33%25%34%45%252C%25%42%42%25%42%34%25%42%31%25%42%31%25%42%44%25%42%39%25%42%35%25%45%33_1s.htmhttp://house.china.com.cn/sousou/%25101%253D%252C%2520%25%44%32%25%46%38%25%44%37%25%45%41%25%42%39%25%46%41%25%42%43%25%43%41%25%44%33%25%45%39%25%43%30%25%44%36%25%42%33%25%43%37%25%42%46%25%41%41%25%42%42%25%41%37%25%42%39%25%44%39%25%43%44%25%46%38%25%35%38%25%35%33%25%33%36%25%33%38%25%33%36%25%41%31%25%41%34%25%34%33%25%34%46%25%34%44%252C%25%43%39%25%43%46%25%43%38%25%43%34%25%43%39%25%46%41%25%42%42%25%45%45_1s.htmhttp://house.china.com.cn/sousou/%25101%253D%252C%2520%25%43%31%25%46%41%25%44%34%25%42%34%25%43%38%25%41%42%25%43%37%25%46%32%25%42%42%25%41%41%25%43%38%25%43%42%25%44%33%25%45%39%25%43%30%25%44%36%25%42%33%25%41%31%25%43%44%25%46%38%25%44%36%25%42%37%25%35%38%25%35%33%25%33%36%25%33%38%25%33%36%25%32%45%25%41%33%25%43%33%25%41%33%25%43%46%25%41%33%25%43%44%252C%25%43%42%25%45%36%25%44%36%25%44%44%25%42%35%25%45%37%25%43%41%25%44%33%25%43%43%25%41%38_1s.htmhttp://house.china.com.cn/sousou/%25101%253D%252C%2520%25%43%33%25%45%35%25%42%35%25%45%39%25%43%31%25%46%41%25%44%34%25%42%34%25%43%38%25%41%42%25%43%37%25%46%32%25%42%42%25%41%41%25%43%38%25%43%42%25%44%33%25%45%39%25%43%30%25%44%36%25%42%39%25%44%39%25%42%37%25%42%44%25%43%44%25%46%38%25%44%36%25%42%37%25%34%32%25%33%32%25%33%30%25%33%32%25%33%34%25%32%45%25%34%33%25%34%45%252C%25%42%38%25%42%37%25%44%31%25%46%34%25%42%35%25%45%37%25%43%43%25%41%38_1s.htmhttp://house.china.com.cn/sousou/%25101%253D%252C%2520%25%43%33%25%45%35%25%42%35%25%45%39%25%42%42%25%43%41%25%42%43%25%44%32%25%43%30%25%46%42%25%42%42%25%41%41%25%42%35%25%45%33%25%42%42%25%46%37%25%42%32%25%42%46%25%42%46%25%41%41%25%42%42%25%41%37%25%35%38%25%35%33%25%33%36%25%33%38%25%33%36%25%32%45%25%36%33%25%41%33%25%43%46%25%41%33%25%43%44%252C%25%44%37%25%46%31%25%44%32%25%45%35%25%43%43%25%45%35%25%44%33%25%46%44_1s.htmhttp://house.china.com.cn/sousou/%25101%253D%252C%2520%25%43%33%25%45%35%25%42%35%25%45%39%25%42%36%25%43%34%25%42%33%25%41%31%25%43%44%25%46%38%25%43%44%25%42%36%25%44%35%25%46%44%25%42%39%25%45%36%25%43%32%25%46%30%25%43%44%25%46%38%25%44%36%25%42%37%25%35%38%25%35%33%25%33%36%25%33%38%25%33%36%25%32%45%25%41%33%25%43%33%25%41%33%25%43%46%25%41%33%25%43%44%252C%25%42%42%25%42%33%25%42%42%25%41%46%25%43%45%25%43%30%25%43%39%25%46%41%25%42%45%25%44%36_1s.htmhttps://iias.tsinghua.edu.cn/search/%E7%A6%8F%E5%BB%BA%E7%A6%8F%E5%B7%9E%E5%93%AA%E6%9C%89%E7%BD%91%E4%B8%8A%E5%B9%B3%E5%8F%B0%E5%AE%98%E7%BD%91B2024%C2%B7CN%E5%85%AD%E5%AE%89%E7%BD%91%E7%BA%A2/feed/rss/https://db.auto.sina.com.cn/search/?search_txt=%E6%96%B0%E7%99%BE%E5%88%A9%E5%A8%B1%E4%B9%90%E6%9E%9C%E6%95%A2%E7%89%B9%E5%8C%BA%E6%8E%A8%E8%8D%90B2024%C2%B7CN%E5%98%89%E5%85%B4%E7%BD%91%E9%80%9A%EF%BC%BD%EF%BF%A5%EF%BC%A6https://iias.tsinghua.edu.cn/search/%E7%BC%85%E7%94%B8%E5%B0%8F%E5%8B%90%E6%8B%89%E6%8B%89%E6%96%AF%E7%BB%B4%E5%8A%A0%E6%96%AF%E6%B3%A8%E5%86%8C%E7%BD%91%E7%AB%99%E7%BD%91%E5%9D%80TL262%C2%B7C%EF%BC%AFM%E5%BE%B7%E9%98%B3%E7%BD%91%E9%80%9A/feed/rss/https://list.jd.com/search?keyword=%E8%85%BE%E9%BE%99%E5%9B%BD%E9%99%85%E4%B8%8A%E4%B8%8B%E5%88%86%E7%94%B5%E8%AF%9D%E5%AE%98%E7%BD%91TL262%C2%B7C%EF%BC%AFM%E7%A6%8F%E5%B7%9E%E4%BA%A4%E9%80%9Ahttps://search.bilibili.com/all?keyword=%E7%BC%85%E7%94%B8%E8%B5%8C%E5%9C%BA%E5%BC%80%E6%88%B7%E8%BF%9B%E6%96%B0%E9%94%A6%E6%B5%B7%E5%AE%98%E7%BD%91B2024%EF%BC%8E%EF%BC%A3N%E8%AE%B8%E6%98%8C%E5%8D%AB%E7%94%9F%E5%B1%80%EF%BD%82%EF%BC%A8%EF%BC%B9https://mod.3dmgame.com/mods?mods_title=%E6%96%B0%E9%87%91%E5%AE%9D%E4%B8%8A%E4%B8%8B%E5%88%86%E5%AE%A2%E6%9C%8D%E5%BE%AE%E4%BF%A1%E5%AE%98%E7%BD%91TL262%C2%B7C%EF%BC%AFM%E8%87%AA%E8%B4%A1%E8%8A%82%E7%9B%AE%E8%A1%A8http://iias.tsinghua.edu.cn/search/%E8%80%81%E8%A1%97%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E5%A8%B1%E4%B9%90%E5%AE%98%E6%96%B9%E7%BD%91%E5%9D%80%E7%9B%B4%E8%90%A5%E7%BD%91B2024%C2%B7CN%E6%B3%89%E5%B7%9E%E4%BA%A4%E9%80%9Ahttps://b2b.baidu.com/s?q=%E7%BC%85%E7%94%B8%E4%B8%87%E4%B8%B0%E5%9B%BD%E9%99%85%E5%BC%80%E4%BA%86%E6%88%B7%E5%BC%80%E6%88%B7B2024.cN%E7%8E%89%E6%BA%AA%E7%94%B5%E5%8F%B0&from=searchhttp://gdh.dict.cn/%E5%B8%9D%E5%AE%9D%E7%BC%85%E7%94%B8%E8%BF%9E%E7%BA%BF%E7%BD%91%E7%AB%99%E7%BD%91%E5%9D%80TL262.%EF%BC%A3%EF%BC%AF%EF%BC%AD%E8%A5%BF%E5%AE%81%E9%98%B2%E7%96%ABhttps://b2b.baidu.com/s?q=%E6%B2%B3%E5%8D%97%E4%BF%A1%E9%98%B3%E6%89%8B%E6%9C%BA%E7%BD%91%E6%8A%95%E5%B9%B3%E5%8F%B0%E7%9B%B4%E8%90%A5%E7%BD%91TL262%C2%B7%EF%BC%A3%EF%BC%AF%EF%BC%AD%E6%B1%95%E5%A4%B4%E5%8D%AB%E8%A7%86&from=searchhttps://www.oschina.net/search?scope=news&q=%E9%91%AB%E4%BD%B0%E5%88%A9%E8%B5%8C%E5%9C%BA%E7%BD%91%E7%AB%99%E7%9B%B4%E8%90%A5%E5%BC%80%E6%88%B7%3ATL262%C2%B7%EF%BC%A3%EF%BC%AF%EF%BC%AD%E4%B8%9C%E8%8E%9E%E4%BC%81%E4%B8%9A%EF%BD%90%EF%BC%ADhttps://www.oschina.net/search?scope=news&q=%E8%80%81%E8%A1%97%E8%85%BE%E9%BE%99%E5%9B%BD%E9%99%85%E5%B9%B3%E5%8F%B0%E5%9C%BA%E5%AE%98%E7%BD%91B2024%C2%B7CN%E9%95%BF%E6%B2%BB%E4%BA%BA%E5%8A%9B%E8%B5%84%E6%BA%90&days=0&onlytitle=0&sort_by_time=0https://minecraft.fandom.com/zh/wiki/UserProfile:%E6%96%B0%E6%98%8C%E7%9B%9B%E5%A8%B1%E4%B9%90%E6%B3%A8%E5%86%8C%E3%80%90%E5%AE%98%E7%BD%91%E2%86%92B2024%C2%B7CN%E3%80%91%E5%8E%A6%E9%97%A8%E4%BA%BA%E6%89%8D%EF%BC%A3%EF%BC%9F?variant=zh-hk&cb=&mobileaction=toggle_view_mobilehttp://www.vpansou.com/query?wd=%E6%9E%9C%E6%95%A2%E8%85%BE%E9%BE%99%E5%9B%BD%E9%99%85%E7%94%B5%E6%8A%95%E5%A8%B1%E4%B9%90%E7%94%B5%E8%84%91%E7%99%BB%E5%BD%95%E7%BD%91%E5%9D%80%E5%AE%98%E6%96%B9%E7%BD%91%E5%9D%80TL262%C2%B7%EF%BC%A3%EF%BC%AF%EF%BC%AD%E6%AD%A6%E5%A8%81%E4%BA%A4%E9%80%9Ahttps://www.oschina.net/search?scope=all&q=%E7%BC%85%E7%94%B8%E6%96%B0%E7%99%BE%E5%88%A9%E5%9B%BD%E9%99%85%E5%A8%B1%E4%B9%90%E5%AE%98%E6%96%B9%E7%BD%91%E5%9D%80TL262%C2%B7%EF%BC%A3%EF%BC%AF%EF%BC%AD%E6%BB%A8%E5%B7%9E%E4%BA%BA%E5%8A%9B%E8%B5%84%E6%BA%90https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E4%B8%8B%E5%88%86%E6%8F%90%E6%AC%BE%E7%9B%B4%E8%90%A5%E7%BD%91TL262%C2%B7C%EF%BC%AFM%E4%B8%89%E4%BA%9A%E4%BC%81%E4%B8%9A%EF%BC%94https://iias.tsinghua.edu.cn/search/%E7%9A%87%E5%AE%B6%E5%9B%BD%E9%99%85%E5%9C%A8%E7%BA%BF%E8%BD%A6%E9%98%9F%E7%94%B5%E8%AF%9D%E6%8E%A8%E8%8D%90B2024%C2%B7CN%E6%B0%B8%E5%B7%9E%E4%BD%93%E8%82%B2/feed/rss2/http://www.minitu.cn/?s=%E9%91%AB%E7%99%BE%E5%88%A9%E5%A8%B1%E4%B9%90%E6%B2%A1%E8%A7%86%E9%A2%91%E5%AE%98%E7%BD%91%E5%BE%AE%E4%BF%A1%E5%BC%80%E6%88%B7%E7%94%B5%E8%AF%9D%E5%AE%98%E6%96%B9%E7%BD%91%E5%9D%80TL262%C2%B7%EF%BC%A3%EF%BC%AF%EF%BC%AD%E5%B9%BF%E5%85%83%E4%BD%93%E8%82%B2%EF%BD%82%EF%BD%99%EF%BD%9C
数据库链接没成功吧
休城记忆 提问者
qq_慕斯卡9084436 回复 休城记忆 提问者
举报
一起领略JDBC的奥秘，为进一步学习集成框架打下良好的基础
1 回答插入中文，数据库显示？
3 回答mysql的字符集是utf-8，myeclips的编码也是utf-8，为什么中文还是显示乱码？
2 回答控制台的年龄显示的是null
1 回答为什么连接mysql，导入的包是java.sql.*,而不是com.mysql.*呢
1 回答为什么能显示数据库的数据但还是报错呢？
