jdbc访问数据库步骤

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 ;