1.加载驱动
public class BaseDao <T>{ private static String driver; private static String url; private static String username; private static String password; static { Properties prop = new Properties(); InputStream inputStream = BaseDao.class.getClassLoader().getResourceAsStream("database.pr operties"); try { prop.load(inputStream); } catch (IOException e) { e.printStackTrace(); } driver = prop.getProperty("driver"); url = prop.getProperty("url"); username = prop.getProperty("user"); password = prop.getProperty("password"); }
在根目录下创建一个database.properties.xml的file文件
driver=com.mysql.cj.jdbc.Driver url=jdbc:mysql://自己的主机ip/数据库名称 user=自己设置的用户 password=自己设置的密码
2.获取connection连接对象
Connection connection = getConnection();
3.创建statement,执行sql语句
PreparedStatement preparedStatement = null;
preparedStatement= connection.prepareStatement(querySql); preparedStatement.setString(); preparedStatement.setString();
4.返回resultSet查询结果
ResultSet resultSet = preparedStatement.executeQuery();
while(resultSet.next()){
}
5.释放资源
finally { this.closeConnection(connection,preparedStatement); } return ;