JDBCJdbc快速入门1.1、Jdbc概念1.2、模拟jdbc//1.定义接口package com.jdbc;public interface JdbcInterface { public Object getConnection(); public void crud(); public void close();}//2.定义接口实现类package com.jdbc;public class JdbcInterfaceImpl implements
摘要由CSDN通过智能技术生成
JDBC
Jdbc快速入门
1.1、Jdbc概念
1.2、模拟jdbc
//1.定义接口
package com.jdbc;
public interface JdbcInterface {
public Object getConnection();
public void crud();
public void close();
}
//2.定义接口实现类
package com.jdbc;
public class JdbcInterfaceImpl implements JdbcInterface{
@Override
public Object getConnection() {
System.out.println("连接mysql数据库");
return null;
}
@Override
public void crud() {
System.out.println("对mysql进行增删改查");
}
@Override
public void close() {
System.out.println("关闭连接");
}
}
//3.测试mysql
package com.jdbc;
public class TestMysql {
public static void main(String[] args) {
JdbcInterface jdbcInterface = new JdbcInterfaceImpl();
jdbcInterface.getConnection();
jdbcInterface.crud();
jdbcInterface.close();
//建立连接
//增删改查
//关闭连接
}
}
1.3、jdbc快速入门
package com.jdbc;
import com.mysql.cj.jdbc.Driver;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
public class Jdbc01 {
public static void main(String[] args) throws SQLException {
//注册驱动
Driver driver = new Driver();
//创建连接
String url = "jdbc:mysql://127.0.0.1:3306/db1" +
"?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT";
Properties properties = new Properties();
properties.setProperty("user","root");
properties.setProperty("password","root");
//建立连接
Connection conn = driver.connect(url,properties);
//执行sql
String sql = "insert into actor values(null,'Make','男','1970-11-11','110')";
Statement statement = conn.createStatement();
int i = statement.executeUpdate(sql);
System.out.println(i > 0 ? "成功" : "失败");
//关闭资源
statement.close();
conn.close();
}
}
JDBCJdbc快速入门1.1、Jdbc概念1.2、模拟jdbc//1.定义接口package com.jdbc;public interface JdbcInterface { public Object getConnection(); public void crud(); public void close();}//2.定义接口实现类package com.jdbc;public class JdbcInterfaceImpl implements