java连接数据库MySQL笔记

注解:

1. 其中Class.forName("com.mysql.jdbc.Driver");这一句代码需要加载驱动jar包,下载地址 https://pan.baidu.com/s/1Aw1x1vXm1dglchyh7O4cEQ

2. 驱动jar包使用教程请看 https://blog.csdn.net/jakera/article/details/73694674 第6第7步

3. 写入mysql中文变成了问好, 解决方法: 连接url地址加上?useUnicode=true&characterEncoding=UTF-8这一句话。如下所示：
   jdbc:mysql://localhost:3306/student?useUnicode=true&characterEncoding=UTF-8

4. Navicate免安装中文版软件下载地址: 链接: https://pan.baidu.com/s/1QGy4JuObl7NEJjfjAXftzA 提取码: x9ag

一. MySQL插入,删除,修改

String url = "jdbc:mysql://localhost:3306/javabook";
String user = "root";
String passwd = "wangwei";
try {
	//加载驱动
	Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e1) {
	System.out.println("驱动加载失败");
}
try {
	Connection conn = DriverManager.getConnection(url,user,passwd);
	String SQL = "INSERT INTO example(name,age,sex) VALUES (?,?,?) ";
	PreparedStatement ps = conn.prepareStatement(SQL);
	ps.setString(1, "qing");
	ps.setInt(2, 22);
	String sex = "女";
	ps.setString(3,sex);
	
	//注意这里不要添加参数sql   ps.executeUpdate(sql);
	int m = ps.executeUpdate();
	if(m!=0){
		System.out.println("插入成功!");
	}
	else{
		System.out.println("插入失败!");
	}
	conn.close();
} catch (SQLException e) {
	System.out.println("操作失败!");
}
System.out.println("结束了!");
		

二. MySQL查找

String url = "jdbc:mysql://localhost:3306/javabook";
String user = "root";
String passwd = "wangwei";

try {
	Class.forName("com.mysql.jdbc.Driver");
	Connection con = DriverManager.getConnection(url,user,passwd);
	String sql = "select * from example where name=?"; //注意String也不需要加单引号'
	PreparedStatement ps = con.prepareStatement(sql);
	ps.setString(1, "wang");
	ResultSet rs = ps.executeQuery();
	while(rs.next()){
		int id = rs.getInt(1);
		String name = rs.getString(2);
		int age = rs.getInt(3);
		System.out.println(id+":"+name+":"+age);
	}
	rs.close();
	con.close();
} catch (ClassNotFoundException e) {
	// TODO Auto-generated catch block
	e.printStackTrace();
} catch (SQLException e) {
	// TODO Auto-generated catch block
	e.printStackTrace();
}

还有更多的代码
https://blog.csdn.net/weixin_37730482/article/details/77984417