脚本宝典收集整理的这篇文章主要介绍了解决在eclipse2021中,用mysql-connector-java-8.0.18.jar不兼容,导致无法访问数据库问题(2021-10-23),脚本宝典觉得挺不错的,现在分享给大家,也给大家做个参考。
mysql-connector-java-8.0.18.jar 所对应的加载驱 “com.mysql.jc.jdbc.Driver”; mysql-connector-java-5.1.6.jar 所对应的加载驱 “com.mysql.jdbc.Driver”;
如果用Mysql-connector-java-8.0.18.jar,设置配置都没问题的情况下,则出现不兼容,报错:
换成mysql-connector-java-5.1.6-bin.jar,则可正常运行且写入: 如图: 由于未去修改字符编码,所以导致中文乱码<%@ page language="java" contentTyPE="text/htML; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<tITle>Insert title here</title>
</head>
<body>
<form action="model1PRosess.jsp" method="post" onsubmit="return save(this);">
<table border="1" align="center" width="300" bordercolor="#000000">
<tr>
<td align="center" colspan="2">
<br><h1>录入物品信息</h1>
</td>
</tr>
<tr><td>物品名称</td><td><input type="text" name="name" id="name"></td></tr>
<tr><td>价格:</td><td><input type="text" name="price" id="price"></td></tr>
<tr><td>物品描述:</td><td><input type="text" name="description" id="description"></td></tr>
<tr><td align="center" colspan="2"><input type="submit" value="提交"> <input type="reset" value="重置"></td></tr>
</table>
</form>
</body>
</html>
<%@page import="javabean.model1.GoodsDAO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<% request.setCharacterEncoding("UTF-8"); %>
<jsp:useBean id="goods" class="javabean.model1.Goods"></jsp:useBean>
<jsp:setProperty name="goods" property="*" />
<jsp:useBean id="goodsDao" class="javabean.model1.GoodsDao"></jsp:useBean>
<% goodsDao.saveGoods(goods); %>
</body>
</html>
package javabean.model1;
public class Goods {
private String name;
private double price;
private String description;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public double getPrice() {
return price;
}
public void setPrice(double price) {
this.price = price;
}
public String getDescription() {
return description;
}
public void setDescription(String description) {
this.description = description;
}
}
package javabean.model1;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Preparedstatement;
public class GoodsDao {
public void saveGoods(Goods goods){
try {
Class.forName("com.mysql.jdbc.Driver");//加载驱动程序
String url="jdbc:mysql://localhost:3306/javabean";//数据库链接地址
Connection conn=DriverManager.getConnection(url,"root","root");//获取数据库链接
//定义sql语句
String sql="insert into goods(name,price,description) values(?,?,?)";
//创建Preparedstatement对象
PreparedStatement ps=conn.prepareStatement(sql);
//sql参数赋值
ps.setString(1,goods.getName());
ps.setDouble(2, goods.getPrice());
ps.setString(3, goods.getDescription());
ps.executeUpdate();//更新操作
ps.close();
conn.close();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
以上是脚本宝典为你收集整理的解决在eclipse2021中,用mysql-connector-java-8.0.18.jar不兼容,导致无法访问数据库问题(2021-10-23)全部内容,希望文章能够帮你解决解决在eclipse2021中,用mysql-connector-java-8.0.18.jar不兼容,导致无法访问数据库问题(2021-10-23)所遇到的问题。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。