一、File
1.文件的创建
createNewFile()是用这个来进行新建新的文件。
例:
File file3=new File("D:\\a\\aaa.txt");
file3.createNewFile();
2.文件夹的创建
mkdir()是用这个来进行新建新的文件夹。
例:
File file2=new File("D:\\a");
file2.mkdir();
3.文件夹更名
renameTo是用这个来进行更名的。
例:
File file4=new File("D:\\a\\ccc.txt");//文件改名
file3.renameTo(file4);
4.删除文件
例:
用delete()来进行删除。
File file5=new File("D:\\aaa\\ccc.txt");//删除文件
if(file5.exists()){
file5.delete();
}
5.输出文件夹里的文件名
list()是获取文件夹里的文件名。
例:
File file=new File("D:\\aaa");
String [] fileName=file.list();//打印文件名
for(String name:fileName){
System.out.println(name);
}
6.在文件中写入文字
例:
File file1=new File("D:\\aaa\\bbb.txt");//在文件里打字
FileWriter fw=new FileWriter(file1);
fw.write("hello 我好开心,作业好少");
fw.close();
二、Jdbc的增删改查
这次的增删改查中我们将很多重复分代码放到了另一个类里面。
例:
public class DBUtil {
public static Connection getConnection() {
Connection connection=null;
try {
Class.forName("com.mysql.jdbc.Driver");
connection= DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/nbcj?useSSL=true&characterEncoding=utf-8&user=root&password=123456");
} catch (Exception e) {
e.printStackTrace();
}
return connection;
}
public static void close(ResultSet resultSet, Statement statement,Connection connection){
if(resultSet!=null){
try {
resultSet.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(statement!=null){
try {
statement.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(connection!=null){
try {
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
增的代码:
public class Jdbczj {
public static void main(String[] args){
int a=0;
Scanner scanner=new Scanner(System.in);
Connection connection=null;
PreparedStatement preparedStatement=null;
try {
connection= DBUtil.getConnection();
String sql="INSERT INTO studer (NAME,PASSWORD) VALUES (?,?)";
System.out.print("请输入要增加的name:");
String name=scanner.next();
System.out.print("请输入要增加的password:");
String password=scanner.next();
preparedStatement=connection.prepareStatement(sql);
preparedStatement.setString(1,name);
preparedStatement.setString(2,password);
a=preparedStatement.executeUpdate();
if(a!=0){
System.out.println("添加成功");
}
else{
System.out.println("没有添加成功");
}
} catch (Exception e) {
e.printStackTrace();
}finally {
DBUtil.close(null,preparedStatement,connection);
}
}
}
删的代码:
public class JdbcDelete {
public static void main(String[] args){
Scanner scanner=new Scanner(System.in);
Connection connection=null;
PreparedStatement preparedStatement=null;
try {
connection=DBUtil.getConnection();
String sql="delete from studer where id=?";
int i;
int a=0;
System.out.print("请输入要删除的编号:");
i=scanner.nextInt();
preparedStatement=connection.prepareStatement(sql);
preparedStatement.setInt(1,i);
a=preparedStatement.executeUpdate();
if(a!=0){
System.out.println("删除成功");
}
else{
System.out.println("没有要删除的编号");
}
} catch (Exception e) {
e.printStackTrace();
}finally {
DBUtil.close(null,preparedStatement,connection);
}
}
}
改的代码:
public class JdbcDelete {
public static void main(String[] args){
Scanner scanner=new Scanner(System.in);
Connection connection=null;
PreparedStatement preparedStatement=null;
try {
connection=DBUtil.getConnection();
String sql="delete from studer where id=?";
int i;
int a=0;
System.out.print("请输入要删除的编号:");
i=scanner.nextInt();
preparedStatement=connection.prepareStatement(sql);
preparedStatement.setInt(1,i);
a=preparedStatement.executeUpdate();
if(a!=0){
System.out.println("删除成功");
}
else{
System.out.println("没有要删除的编号");
}
} catch (Exception e) {
e.printStackTrace();
}finally {
DBUtil.close(null,preparedStatement,connection);
}
}
}
查的代码:
public class Jdbcselect {
public static void main(String[] args){
int a=0;
Scanner scanner=new Scanner(System.in);
Connection connection=null;
PreparedStatement preparedStatement=null;
ResultSet resultSet=null;
try {
connection= DBUtil.getConnection();
String sql="SELECT * FROM studer";
preparedStatement=connection.prepareStatement(sql);
resultSet =preparedStatement.executeQuery();
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);
}
} catch (Exception e) {
e.printStackTrace();
}finally {
DBUtil.close(null,preparedStatement,connection);
}
}
}