注意:需要一个Java类,一个dbinfo.properties配置文件
**Test3**
-----
import java.sql.*;
import java.io.*;
import java.util.*;
public class Test3
{
public static void main(String[] args) throws Exception{
FileReader reader = new FileReader("dbinfo.properties");
Properties pro = new Properties();
pro.load(reader);
reader.close();
String driver = pro.getProperty("driver");
String url = pro.getProperty("url");
String user = pro.getProperty("user");
String password = pro.getProperty("password");
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try{
Class.forName(driver);
conn = DriverManager.getConnection(url,user,password);
stmt = conn.createStatement();
String sql = "select deptno,dname,loc from dept";
rs = stmt.executeQuery(sql);
while(rs.next()){
int deptno = rs.getInt("deptno");
String dname = rs.getString("dname");
String loc = rs.getString("loc");
System.out.println(deptno + "," + dname + "," + loc);
}
}catch(SQLException e){
e.printStackTrace();
} finally{
if(rs != null){
try{
rs.close();
}catch(SQLException e){
e.printStackTrace();
}
}
if(stmt != null){
try{
stmt.close();
}catch(SQLException e){
e.printStackTrace();
}
}
if(conn != null){
try{
conn.close();
}catch(SQLException e){
e.printStackTrace();
}
}
}
}
}
***dbinfo.properties**
----------------------
driver=com.mysql.jdbc.Driver
url=jdbc:mysql:
user=root
password=123