package com.lovo;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/**
* 数据库
* @author Dean
*
*/
public class Test01 {
public static void main(String[] args) {
Connection con = null;
// 1.加载驱动程序
try {
Class.forName("com.mysql.jdbc.Driver");
// 2.创建连接;
con = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/company",
"root", "123456");
System.out.println(con + ":连接成功");
// 3.创建语句对象
Statement stmt = con.createStatement();
// 4.发出SQL语句得到结果集(游标)
ResultSet rs = stmt.executeQuery("select * from emp");
// 5.循环遍历结果集
while(rs.next()){ //先判断游标是否可以取到下一条记录
System.out.println("姓名:" + rs.getString("ename"));
System.out.println("工资:" + rs.getInt("sal"));
System.out.println("=====分割线=====");
}
//更新一条数据
int temp = stmt.executeUpdate("Update emp set ename ='曾雯' where eno=4466");
System.out.println(temp);
//删除一条数据
int temp1 = stmt.executeUpdate("Delete from emp where eno=4466");
System.out.println(temp1);
//添加一条数据
int temp2 = stmt.executeUpdate("insert into emp (eno,ename,job,mgr,sal,comm,dno) "
+ "values(4466,'黄佳梦','会计',5566,4000,300,10)");
System.out.println(temp2);
//批量加入数据
stmt.addBatch("insert into emp values(4411,'龙哥','会计',5566,3000,300,10)");
stmt.addBatch("insert into emp values(4422,'梦姐','会计',5566,3100,400,10)");
stmt.addBatch("insert into emp values(4433,'炮娘','会计',5566,3200,100,10)");
int[] count = stmt.executeBatch();
for(int i=0; i<count.length; i++){
System.out.println("第" + (i+1) + "条语句影响的行数为:" + count[i] );
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally{
if(con != null){
try {
con.close(); // 6.关闭连接
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}
Java 1203 JDBC
最新推荐文章于 2022-12-09 10:48:10 发布