JDBC优化--写成配置文件

注：配置文件必须写在工程的src目录下

package p1;

import java.sql.*;
import java.util.*;

class Person{
	@Override
	public String toString() {
		return "Person [id=" + id + ", name=" + name + "]";
	}
	int id;
	String name;
}
public class Text1 {

	public static void main(String[] args) throws ClassNotFoundException, SQLException {
		ResourceBundle bundle=ResourceBundle.getBundle("text");
		String driver=bundle.getString("driver");
		String url=bundle.getString("url");
		String user=bundle.getString("user");//名字是固定的
		String password=bundle.getString("password");//名字是固定的
		Class.forName(driver);
		Connection connection=DriverManager.getConnection(url,user,password);
		Statement statement=connection.createStatement();
		
		String word="select * from person;"; 

		ResultSet sets=statement.executeQuery(word);
		ArrayList<Person> arr=new ArrayList<>();
		while(sets.next())
		{
			Person p=new Person();
			p.id=sets.getInt("id");
			p.name=sets.getString("name");
			arr.add(p);
		}
		System.out.println(arr);
	}

}

 

[Person [id=2, name=呵呵], Person [id=3, name=大岛君], Person [id=4, name=钢铁侠]]

 

防止sql注入: