Mysql笔记

最新推荐文章于 2023-02-26 14:31:03 发布

F_URY

最新推荐文章于 2023-02-26 14:31:03 发布

阅读量435

点赞数

分类专栏： DB

本文链接：https://blog.csdn.net/u012400327/article/details/43371967

版权

DB 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

简介

一、框架

MClient 主界面，相当于主菜单. 集成了其他某块的链接类似网站的主页.

二、绘图模块

三、用户管理模块

四、数据库开发

MYSQL 笔记

1.MySQL Command Line Client

	命令行中切换到bin目录 运行mysql -h localhost -u root -p

user:root password: toot

创建mydata数据库 creat databases mydata.

选择mydata数据库 use mydata;

数据库中创建一张表 create table dept

show databases;

show tables;

desc dept; 观察dept这张表。

insert into dept values(10, 'A', 'A');

commit 提交

delete from (某张表)

select * from dept order by deptno desc limit 2,2;从第二条记录开始数两条记录显示。

？查看说明

\ . （文件所在目录）执行一个SQL脚本文件

不打开mysql 既链接就会出现The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
SQLState: 08S01

package TestJDBC;
import java.sql.*;

public class hello {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		try{
			Class.forName("com.mysql.jdbc.Driver");
			conn =DriverManager.getConnection("jdbc:mysql://localhost/mydata?user=root&password=toot");
			stmt = conn.createStatement();
			rs = stmt.executeQuery("select * from dept");
			while(rs.next()){
				System.out.println(rs.getString("deptno"));
			}
		}catch(ClassNotFoundException e){
			e.printStackTrace();
		}
		catch(SQLException ex){
			System.out.println("SQLException: " + ex.getMessage());
			System.out.println("SQLState: " + ex.getSQLState());
			System.out.println("venderError: " + ex.getErrorCode());
		}finally{
			try {
				if(rs != null){
					rs.close();
					rs = null;
				}
				if(stmt != null){
					stmt.close();
					stmt = null;
				}
				if(conn != null){
					conn.close();
					conn = null;
				}
			}catch (SQLException e){
				e.printStackTrace();
			}
		}
	}
}