jdbc复习
1)准备工作
下载mysql(https://dev.mysql.com/downloads/mysql/)
下载navicat for mysql(sql可视化式具)(https://blog.csdn.net/qq_27598243/article/details/79882978)
下载jar包mysql-connector-java-jar(https://dev.mysql.com/downloads/connector/j/)
下载druid包
2)创建项目
第一步)在navicat中创建t-student表
第二步)操作jdbc(贾琏欲执事)
package jdbcno1;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.naming.spi.DirStateFactory.Result;
public class jdbcno1 {
/*增加操作
* 贾琏欲执事*/
public static void create() throws Exception {
String sql="INSERT INTO `student` (`nane`, `age`) VALUES ( '2', '15')";
//贾(加载注册驱动)
//驱动名为com.+数据库类型+jdbc.Driver
Class.forName("com.mysql.jdbc.Driver");
//琏(获取连接对象)
//connection和statement要导入的包为
//sql中的connection接口和statement接口
//url:jdbc:mysql://ip名:端口名/数据库名
//username:root
//password:admin
Connection connection = null;
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/user", "root", "admin");
//创建语句对象
Statement statement = null;
statement = connection.createStatement();
//执行语句
//statement.execute执行DML操作 返回受影响的行数
//executequery执行dql操作 返回结果集
statement.execute(sql);
//关闭资源
statement.close();
connection.close();
}
//查询操作
public static void get() throws Exception {
// TODO Auto-generated method stub
String sql="SELECT * FROM `student` WHERE `id` = '1'";
Class.forName("com.mysql.jdbc.Driver");
Connection conn=null;
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/user", "root", "admin");
Statement sta=conn.createStatement();
ResultSet rs=sta.executeQuery(sql);
if (rs.next()) {
long id=rs.getLong("id");
String name=rs.getString("name");
int age=rs.getInt("age");
System.out.println("student1 [id=" + id + ", name=" +name + ", age=" + age + "]");
}
rs.close();
sta.close();
conn.close();
}
}