打卡打卡
今天我们学习了简单的io流
用java代码建新文件夹
package test;
import java.io.File;
import java.io.IOException;
public class TestFile {
public static void main(String[] args)throws IOException {
File file=new File(“D:\Program Files\study\peixun\aaa.txt”);
file.createNewFile();
System.out.println(file);
}
}
重命名文件夹
package test;
import java.io.File;
import java.io.IOException;
public class TestFile {
public static void main(String[] args)throws IOException {
File file=new File(“D:\Program Files\study\peixun\aaa.txt”);
file.createNewFile();
File filel=new File(“D:\Program Files\study\peixun\bbb.txt”);
file.renameTo(filel);
System.out.println(file);
}
}
删除文件夹
package test;
import java.io.File;
import java.io.IOException;
public class TestFile {
public static void main(String[] args)throws IOException {
File file=new File(“D:\Program Files\study\peixun\bbb.txt”);
file.createNewFile();
file.delete();
System.out.println(file);
}
}
历遍一个文件夹,显示;里面含有的文件名
package zhongruan.service;
import java.io.File;
import java.io.IOException;
public class Muluxianshi {
public static void main(String[] args) throws IOException {
File f = new File(“D:\Program Files\study\peixun\a”);
File[] list = f.listFiles();
for(File i:list){
System.out.println(i);
}
}
}
在文件夹中写入hello
package test;
import java.io.*;
public class DuxieFile {
public static void main(String[] args) throws IOException {
File a=new File(“D:/test.txt”);
a.createNewFile();
FileWriter fs=new FileWriter(“D:/test.txt”);
fs.write(“hello”);
fs.close();
FileReader fr=new FileReader(“D:/test.txt”);
BufferedReader br=new BufferedReader(fr);
String s=br.readLine();
System.out.println(s);
}
}
好
接着前几天来我们继续讲了jdbc
下面是jdbc删除
先建新一个类,因为jdbc代码七步走,不同功能的代码会有很多重复的内容
所以我们将加载驱动、创建连接还有关闭资源这三步归为一个类里
在写代码的时候就可以直接引用了
不说了,看代码
package test;
import java.sql.*;
public class DBUtil {
public Connection getConnection(){
Connection connection=null;
//1.加载驱动
try {
Class.forName(“com.mysql.jdbc.Driver”);
//2.创建连接
connection= DriverManager.getConnection(“jdbc:mysql://127.0.0.1:3306/nbcj?useSSL=true&characterEncoding=utf-8&user=root&password=123456”);
System.out.println(“创建连接成功”);
} catch (Exception e) {
e.printStackTrace();
}
return connection;
}
//3.关闭资源
public static void closeAll(ResultSet rs, PreparedStatement preparedStatement, Connection connection){
if(rs!=null){
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(preparedStatement!=null){
try {
preparedStatement.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(connection!=null){
try {
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
再接下来就是我们的main执行语句了
package test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
public class JdbcDelete {
public static void main(String[] args) {
Connection connection=null;
PreparedStatement preparedStatement=null;
DBUtil dbUtil=null;
//1.加载驱动
try {
dbUtil=new DBUtil();
connection = dbUtil.getConnection();
//3.写sql
String sql=“delete from student where id=?”;
//4.获得statement对象
preparedStatement = connection.prepareStatement(sql);
preparedStatement.setInt(1,1);
preparedStatement.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
}finally {
dbUtil.closeAll(null,preparedStatement,connection);
}
}
}
这样delete删除代码就变得很简洁了
可以在试着使用新建的类来简洁化原来的jdbc查询
如下:
package test;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class Testjdb {
public static void main(String[] args) throws Exception {
DBUtil dbUtil=new DBUtil();
Connection connection = dbUtil.getConnection();
//3.写sql语句
String sql=“select * from student”;
//4.得到statement对象
PreparedStatement preparedStatement = connection.prepareStatement(sql);
//5.执行sql得到结果集
ResultSet resultSet=preparedStatement.executeQuery();
//6.处理结果集
while (resultSet.next()){
Student student=new Student() ;
student.setId( resultSet. getInt( 1));
student.setName( resultSet.getString(2));
student.setPassword(resultSet.getString(3));
System.out.println(student);
}
//7.关闭资源
DBUtil.closeAll(resultSet,preparedStatement,connection);
}
}
好,今天就到这啦