java连接MySQL数据库并操作数据库

最新推荐文章于 2024-07-28 08:35:58 发布

无意呢

最新推荐文章于 2024-07-28 08:35:58 发布

阅读量387

点赞数

分类专栏： Mysql 文章标签： mysql java

本文链接：https://blog.csdn.net/qq_41900081/article/details/82891459

版权

Mysql 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

jdk版本：10.0.2

MySQL版本：8.0

MySQL连接驱动版本8.0.12

启动MySQL服务

net start mysql

如果显示服务名无效，那就安装服务，然后再启动服务

mysqld install

用root登录MySQL，第一次使用不用密码

mysql -u root -p

退出登录

exit

用Java10.0.2和connectors/J8.0连接mysql

Class.forName("com.mysql.cj.jdbc.Driver");
	   
String url = "jdbc:mysql://127.0.0.1:3306/book_manage?
              serverTimezone=UTC&useUnicode=true&
              characterEncoding=utf-8&useSSL=false";

附一个例子

import java.sql.*;

public class Userinfo {

	public static void main(String[] args) throws ClassNotFoundException, SQLException {
	    Class.forName("com.mysql.cj.jdbc.Driver");
		String url = "jdbc:mysql://127.0.0.1:3306/test?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8&useSSL=false";
		String user="root";
	    String password="root";
		Connection con = DriverManager.getConnection(url,user,password);
		Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
		/*创建表ueserindfo
		 * 
		 * String sql = "create table userinfo("+
						"code	varchar(4) not null,"+	
						"name	varchar(10),"+			
						"password varchar(6),"+	
						"email	 varchar(40),"+
						"primary key(code));";
				
		int count = stmt.executeUpdate(sql);*/
		String sql2 = "select * from userinfo";
		
		ResultSet rset = stmt.executeQuery(sql2);
		while(rset.next()){
			int code = rset.getInt("code");
			String name = rset.getString("name");
			String pass = rset.getString("password");
			String email = rset.getString("email");
			System.out.print("代号："+code+" ");
			System.out.print("姓名："+name+"   ");
			System.out.print("密码："+pass+" ");
			System.out.println("email："+email+" ");
			
		}
		/*  插入一个记录
		 *  String sql3 = "insert into userinfo values('7107','帅哥','223333','shuaibi@qq.com')";
		 *  int count2 = stmt.executeUpdate(sql3);
		 *  System.out.println(count2);
		 *  */
		 
		//关闭数据库
		rset.close();
		stmt.close();
		con.close();
	}

}