xx.properties文件放入scr文件夹中 :
dirverClass=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/javatest
username=root
password=
1.java方法(返回Connection对象):
package jdbc_package;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;
public class JDBCUtils {
private JDBCUtils() {}
private static Connection con;
static String dirverClass;
static String url;
static String username;
static String password;
static {
try {
getProperties();
} catch (IOException e2) {
// TODO Auto-generated catch block
e2.printStackTrace();
}
//注册jdbc驱动
try {
Class.forName(dirverClass);
} catch (ClassNotFoundException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
//连接
try {
con = DriverManager.getConnection(url, username, password);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
private static void getProperties() throws IOException {
InputStream in = PropertiesGet.class.getClassLoader().getResourceAsStream("database.properties");
Properties pro = new Properties();
pro.load(in);
dirverClass = pro.getProperty("dirverClass");
url = pro.getProperty("url");
username = pro.getProperty("username");
password = pro.getProperty("password");
}
public static Connection getConnection() {
return con;
}
}
2.调用(查询)
package jdbc_package;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class TestJDBCUtils {
public static void main(String[] args) throws SQLException {
Connection con = JDBCUtils.getConnection();
PreparedStatement pst = con.prepareStatement("select sname from sort");
ResultSet rs = pst.executeQuery();
while (rs.next()) {
System.out.println(rs.getString("sname"));
}
}
}