一、创建数据库
1、创建zjgm数据库,字符集位utf8,数据库排序规则为utf8_general_ci
2、创建一个新表stu,引擎InnoDB, 字符集utf8,数据库utf8_general_ci
3、增加列 id 数据类型 int 长度50 主键 非空 自增
name 数据类型 varchar 长度50
age 数据类型 int 长度50
向表添加一条信息 1 lindongdong 21
二、建立Java和MySQL连接
1、创建一个新的包 lib ,将架包mysql-connector-java-5.0.8-bin 放进去使其生效
2、创建一个新的项目文件
package com.zhongruan;
import java.sql.*;
public class Test {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
//1.加载驱动
Class.forName("com.mysql.jdbc.Driver");
//2.创建连接
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost/zjgm?user=root&password=123456");
System.out.println("创建连接成功");
//3.写sql
String sql = "select * from stu";
//4.得到statement对象
PreparedStatement statement = connection.prepareStatement(sql);
//5执行sql
ResultSet resultSet = statement.executeQuery();
//6.处理结果集
while (resultSet.next()){
int id=resultSet.getInt(1);
String name=resultSet.getString(2);
int age = resultSet.getInt(3);
System.out.println(id+name+age);
}
//7.关闭资源
resultSet.close();
statement.close();
connection.close();
}
}
3、类 (猫 狗 人) --------对象 (小花,小黄 ,华丽丽)
Class new
作业
查询
public class Test {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
//1.加载驱动
Class.forName("com.mysql.jdbc.Driver");
//2.创建连接
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost/zjgm?user=root&password=123456");
System.out.println("创建连接成功");
//3.写sql
String sql = "select * from stu";
//4.得到statement对象
PreparedStatement statement = connection.prepareStatement(sql);
//5执行sql
ResultSet resultSet = statement.executeQuery();
//6.处理结果集
while (resultSet.next()){
int id=resultSet.getInt(1);
String name=resultSet.getString(2);
int age = resultSet.getInt(3);
System.out.println(id+name+age);
}
//7.关闭资源
resultSet.close();
statement.close();
connection.close();
}
}
增加
3.写sql
String sql = "insert into stu(id,name,age) values (4,'来哲峰',78)";
String sql = "insert into stu(id,name,age) values (1,'林东栋',20)";
//4.得到statement对象
PreparedStatement statement = connection.prepareStatement(sql);
//5执行sql
statement.executeUpdate();
删除
//3.写sql
String sql = "delete from stu where age=27";
//4.得到statement对象
PreparedStatement statement = connection.prepareStatement(sql);
//5执行sql
statement.executeUpdate();
Change
//3.写sql
String sql = "UPDATE stu set name='小来',age=58 where id=4";
//4.得到statement对象
PreparedStatement statement = connection.prepareStatement(sql);
//5执行sql
statement.executeUpdate();