实验五 输入、输出流及JDBC访问数据库
一、实验目的
1.掌握字符输入和输出流的用法;
二、实验内容
1.现有如下格式的成绩单(文本格式)score.txt:
姓名:张三,数学72分,物理67分,英语70分.
姓名:李四,数学92分,物理98分,英语88分.
姓名:周五,数学68分,物理80分,英语77分.
要求按行读取成绩单,并在该行的后面加上该同学的总成绩,然后将该行写入一个名字为scoreAnalysis的文件中。
2.在源目录下建立一个test.txt文本文件,利用字符输出流向其写入”中国西安”(陕西西安),然后再利用字符输入流将该字符串读出。
3.使用文件字符输入、输出流将文件a.txt的内容尾加到文件b.txt中。
4.使用文件字符输入、输出流将文件a.txt的内容尾加到文件b.txt中。
5.使用字符缓冲流将字符串按行存入文件,然后再按行输出。字符串如下所示:
内容为:姓名:丁一;性别:女;年龄:18。
6.访问数据库
三、实验步骤与实验结果
1.分析成绩单
源代码:
package chapert1;
import java.io.*;
import java.util.*;
public class AnalysisResult {
public static void main(String args[]) {
File fRead = new File("src/chapert1/score.txt");
File fWrite = new File("src/chapert1/socreAnalysis.txt");
try{
Writer out = new FileWriter(fWrite);
BufferedWriter bufferWrite = new BufferedWriter(out);
Reader in = new FileReader(fRead);
BufferedReader bufferRead = new BufferedReader(in);
String str = null;
while((str=bufferRead.readLine())!=null) {
double totalScore=Fenxi.getTotalScore(str);
str = str+" 总分:"+totalScore;
System.out.println(str);
bufferWrite.write(str);
bufferWrite.newLine();
}
bufferRead.close();
bufferWrite.close();
}
catch(IOException e) {
System.out.println(e.toString());
}
}
}
package chapert1;
import java.util.*;
public class Fenxi {
public static double getTotalScore(String s) {
Scanner scanner = new Scanner(s);
scanner.useDelimiter("[^0123456789.]+");
double totalScore=0;
while(scanner.hasNext()){
try{ double score = scanner.nextDouble();
totalScore = totalScore+score;
}
catch(InputMismatchException exp){
String t = scanner.next();
}
}
return totalScore;
}
}
2.中国西安
源代码:
package chapert4;
import java.io.File;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.IOException;
public class test1 {
public static void main(String[] args) throws IOException {
File file=new File("D:\\javalgd\\Experiment10\\bin\\chapert4","test.txt");
file.createNewFile();
FileReader in=new FileReader(file);
FileWriter out=new FileWriter(file);
out.write("中国西安");
out.close();
char[] content=new char[1024];
int len=in.read(content);
for(int i=0;i<content.length;i++) {
System.out.print(content[i]);
}
String str=new String(content,0,len);
System.out.println(str);
in.close();
}
}
3.实验三
源代码:
package chapert5;
import java.io.File;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.IOException;
public class test1 {
public static void main(String[] args) throws IOException {
/*a.txt和b.txt提前在指定目录下建好,并且在a.txt里面写好”abc”,在b.txt里面写好”123” */
File sourceFile=new File("D:\\javalgd\\Experiment10\\bin\\chapert5","a.txt");
File targetFile=new File("D:\\javalgd\\Experiment10\\bin\\chapert5","b.txt");
char[] b=new char[20];
FileWriter out=new FileWriter(targetFile,true);//不覆盖原有内容
FileReader in=new FileReader(sourceFile);
int n;
while((n=in.read(b))!=-1) {
out.write(b,0,n);
}
out.flush();
out.close();
}
}
4.实验四
源代码:
package chapert6;
import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.IOException;
public class test1 {
public static void main(String[] args) throws IOException {
/*a.txt和b.txt提前在指定目录下建好,并且在a.txt里面写好”abc”,在b.txt里面写好”123” */
File sourceFile=new File("D:\\javalgd\\Experiment10\\bin\\chapert6","a.txt");
File targetFile=new File("D:\\javalgd\\Experiment10\\bin\\chapert6","b.txt");
char[] b=new char[20];
FileWriter out=new FileWriter(targetFile);
FileReader in=new FileReader(sourceFile);
BufferedReader bin=new BufferedReader(in);
BufferedWriter bout=new BufferedWriter(out);
String str;
while((str=bin.readLine())!=null) {
bout.write(str);
bout.newLine();
}
bout.close();
out.close();
}
}
5.实验五
源代码:
package chapert7;
import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.IOException;
public class ttt {
public static void main(String[] args) throws IOException {
File file=new File("student.txt");
String content[]= {"姓名:丁一","性别:女","年龄:18"};
//创建FileWriter对象,用来写字符流
FileWriter out=new FileWriter(file);
BufferedWriter bout=new BufferedWriter(out);
for(int i=0;i<content.length;i++) {
bout.write(content[i]);
bout.newLine();
}
bout.close();
out.close();
//创建FileReader对象,用来读取字符流
FileReader in=new FileReader(file);
BufferedReader bin=new BufferedReader(in);
String str;
while((str=bin.readLine())!=null) {
System.out.println(str);
}
bin.close();
in.close();
}
}
6.访问数据库
源代码:
package chapert3;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class test1 {
public static void main(String[] args) throws Exception {
String str="com.mysql.jdbc.Driver";
//1.加载数据库驱动
Class.forName(str);
String url="jdbc:mysql://localhost:3306/user";
String username="root";
String password="1234";
Connection conn=DriverManager.getConnection(url, username, password);
Statement stmt=conn.createStatement(); //createStatement()创建一个Statement对象来将SQL语句发送到数据库
//4.使用一个Statement对象执行SQL语句
String sql="select * from users";
ResultSet rs=stmt.executeQuery(sql);
System.out.println("id | name | psw | email | birthday |");
//System.out.println(rs.next());
while(rs.next()) {
int id=rs.getInt("id");
String name=rs.getString("name");
String psw=rs.getString("psw");
String email=rs.getString("email");
String birthday=rs.getString("birthday");
System.out.println(id+" | "+name+" | "+psw+" | "+email+" | "+birthday+" | ");
}
if(rs!=null)
{rs.close();
rs=null;}
if(stmt!=null) {
stmt.close();
stmt=null;
}
if(conn!=null) {
conn.close();
conn=null;
}
}
}
四、实验总结
通过本次实验掌握了字符输入和输出流的用法,在实验过程中遇到了很多问题,几经周折,查阅了教材,还去网上查阅了资料,最后才将问题解决。程序顺利运行。